Question 11 : ___________ encryption was introduced in SQL Server 2005 and is available in all editions of SQL Server.
1. Column-level Encryption
2. Transparent Data Encryption
3. BitLocker
4. None of the mentioned
View Answer   Discuss with Members

Question 12 : Like data compression, TDE database encryption is performed at the ______ level.
1. Page
2. Domain
3. Column
4. Row
View Answer   Discuss with Members

Question 13 : Point out the wrong statement :
1. Encryption should be considered for all data or connections
2. Any use of encryption should also include a maintenance strategy for passwords, keys, and certificates
3. TDE is essentially an enterprise-oriented feature and is available only in the following editions of SQL Server
4. None of the mentioned
5.
View Answer   Discuss with Members

Question 14 : Point out the wrong statement :
1. EncryptByKey uses a symmetric key
2. EncryptByKey returns NULL if the key is not open
3. You can use encryption in SQL Server for connections, data, and stored procedures
4. All of the mentioned
5.
View Answer   Discuss with Members

Question 15 : To add or remove server role membership use :
1. ALTER ROLE
2. ALTER ANY LOGIN
3. ALTER SERVER ROLE
4. None of the mentioned
View Answer   Discuss with Members

Question 16 : Any SQL Server authentication login can see ________ login name.
1. Own and sa
2. sa
3. Own
4. None of the mentioned
View Answer   Discuss with Members

Question 17 : Which of the following returns a row for each security principal in a SQL Server database ?
1. sys.database_role_members
2. sys.sql_logins
3. sys.database_principals
4. None of the mentioned
View Answer   Discuss with Members

Question 18 : The schema securable scope contains the following securables:
1. Contract
2. Asymmetric key
3. Schema
4. Object
View Answer   Discuss with Members

Question 19 : Point out the wrong statement :
1. The entity that receives permission to a securable is called a principal
2. The SCHEMA securable scope contains the USER securables
3. A table is a securable
4. None of the mentioned
5.
View Answer   Discuss with Members

Question 20 : _________ returns a list of the permissions effectively granted to the principal on a securable.
1. HAS_PERMS_BY_NAME
2. sys.fn_my_permissions
3. sys.fn_permissions
4. All of the mentioned
View Answer   Discuss with Members