Sail E0 Webinar

MCQs

Total Questions : 10
Question 1. Which of the following feature prefers SQL Server authentication mode over winbdows authentication ?
  1.    Backward compatibility
  2.    Forward compatibility
  3.    Security
  4.    All of the mentioned
 Discuss Question
Answer: Option A. -> Backward compatibility


SQL Server Authentication is provided for backward compatibility. For example, if you create a single Windows 2000 group and add all necessary users to that group you will need to grant the Windows 2000 group login rights to SQL Server and access to any necessary databases.


Question 2. 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
 Discuss Question
Answer: Option A. -> EncryptByKey uses a symmetric key


If the symmetric key is already open in the current session, you do not have to open it again in the context of the query.


Question 3. Point out the correct statement :
  1.    SQL Server 2008 offers three authentication mode options
  2.    Microsoft's best practice recommendation is that you use Windows authentication mode whenever possible
  3.    If you use mixed authentication mode, you should enable the DBA's Windows account
  4.    None of the mentioned
 Discuss Question
Answer: Option B. -> Microsoft's best practice recommendation is that you use Windows authentication mode whenever possible


Windows authentication mode allows you to centralize account administration for your entire enterprise in a single place.


Question 4. Like data compression, TDE database encryption is performed at the ______ level.
  1.    Page
  2.    Domain
  3.    Column
  4.    Row
 Discuss Question
Answer: Option A. -> Page


Performing the encryption at the page level enables the encryption process to be completely transparent to the client applications.


Question 5. 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
 Discuss Question
Answer: Option A. -> Encryption should be considered for all data or connections


encryption is a valuable tool to help ensure security, it should not be considered for all data or connections.


Question 6. View that contains the list of all the security labels present in the database:
  1.    vwVisibleLabels
  2.    VisibleLabels
  3.    vwVisibleLabel
  4.    All of the mentioned
 Discuss Question
Answer: Option A. -> vwVisibleLabels


The purpose of vwVisibleLabels view is to enforce the row security by joining it with the base table.


Question 7. 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
 Discuss Question
Answer: Option B. -> The SCHEMA securable scope contains the USER securables


The database securable scope contains the user securables.


Question 8. _________ 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
 Discuss Question
Answer: Option B. -> sys.fn_my_permissions


Related function is HAS_PERMS_BY_NAME.


Question 9. What will the fn_Dominates return if A dominates B where A and B both are security label?
  1.    0
  2.    1
  3.    NULL
  4.    None of the mentioned
 Discuss Question
Answer: Option B. -> 1


fn_Dominates (Function) compares two labels and determines whether label A dominates label B.


Question 10. Any SQL Server authentication login can see ________ login name.
  1.    Own and sa
  2.    sa
  3.    Own
  4.    None of the mentioned
 Discuss Question
Answer: Option A. -> Own and sa


To see other logins, requires ALTER ANY LOGIN, or a permission on the login.


Latest Videos

Latest Test Papers