1to20

SQL Server 2008 Security model is based on three categories that separate the basic elements of security, which among the following are those? 1.Principals 2.Constraints 3.Securables 4.Permissions

• 1&2&3

• 1&3&4

• 1&2&4

• 2,4,3

Which statements are true about Principals? 1.Principals are entities that can configure SQL Server permissions 2.Principals are entities that can request SQL Server resources 3.Principals can be arranged in a hierarchy 4.The scope of influence of a principal depends on the scope of the definition of the principal 5.The scope of influence of a principal depends on the size of the database

• 1,2,3

• 2,3,4

• 3,4,5

• 1,2,3,4

• 2/3/4/5

Choose the different classes which the SQL Server divides principals into? 1.Windows-level principal 2.Field-level principal 3.Database-level principal 4.SQL Server-level principa

• 1/4

• 2/3/4

• 1/3

• 1/3/4

the different types of Windows-level principals? 1.Windows Authorization 2.Windows domain login 3.Windows database login 4.Windows local login

• 2/4

• 2/3

• 1/2/4

• 2

Database-level principals categorized? 1.Database administrator 2.Database User 3.Database Role 4.Windows Role 5.Application Role

• 1/4/5

• 2/3/5

• 1/2/3/5

• 2/5

• 1/2/5

Which among the following are different Securable scopes? 1.Server 2.Client 3.Database 4.Schema

• 1 3 4

• 2 4

• 1 2 4

• 3 4

Which of the securables are contained in the Database scope? 1.Login 2.User 3.Role 4.Assembly 5.End Point

• 1 2 3

• 3 4 5

• 1 3 5

• 2 3 4

• 1 2 5

What are the advantages of using SQL Server Authentication? 1.Allows SQL Server to support Web-based applications where users create their own identities 2.Allows software developers to distribute their applications by using a complex permission hierarchy based on known, preset SQL Server logins 3.Can also use Kerberos Security protocol 4.Users can connect from unknown or untrusted domains 5.Additional password policies offered by Windows can be inherited for SQL Server logins

• 2&4&5

• 1&3&4

• 1&2&5

• 2&3&5

• 1&2&4

Which all permission types are applicable to Functions? 1.SELECT 2.INSERT 3.UPDATE 4.DELETE 5.EXECUTE (scalar)

• 3 5

• 2 4

• 1 5

• 1 2 5

• 3 4

Which are the principals included in the Security context? 1.The login 2.The user 3.Authentication memberships 4.Role membership

• 2 4

• 1 4 5

• 1 4

• 1 2 4

• 1 3 4 5