MCQ IN COMPUTER SCIENCE & ENGINEERING

Detailed explanation-1: -You can add server-level principals (SQL Server logins, Windows accounts, and Windows groups) into server-level roles. Each member of a fixed server role can add other logins to that same role. Members of user-defined server roles can’t add other server principals to the role.

Detailed explanation-2: -When a SQL Server login is created, the public role is assigned to the login and cannot be revoked. If the server principal is not granted or denied specific permissions on a securable object, the login will automatically inherit the permissions for that object that are granted to the public role.

Detailed explanation-3: -Using SQL Server Management Studio Right-click a stored procedure and select Properties. In the Stored Procedure Properties-stored procedure name dialog box, under select a page, select Permissions. Use this page to add users or roles to the stored procedure and specify the permissions those users or roles have.

Detailed explanation-4: -Fixed Server Roles The role bulkadmin gives administers bulk copy and other bulk operations. The role dbcreator allows its members to create, alter, or drop databases. The diskadmin role allows its members to work with the actual files on the disk-for instance, it could manage filegroups.