Explanation: add_authenticator indicates whether an authenticator will be encrypted together with the cleartext. 2. Point out the wrong statement :
A. EncryptByKey uses a symmetric key
B. EncryptByKey returns NULL if the key is not open
C. You can use encryption in SQL Server for connections, data, and stored procedures.
D. All of the mentioned
Answer:A
Explanation: add_authenticator indicates whether an authenticator will be encrypted together with the cleartext. 2. Point out the wrong statement :
A. EncryptByKey uses a symmetric key B. EncryptByKey returns NULL if the key is not open C. You can use encryption in SQL Server for connections, data, and stored procedures. D. All of the mentioned
Explanation: 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. 3. Which of the following script creates master key ?