Explanation:To use cell-level encryption, the schema must be changed to varbinary, then reconverted to the desired data type. 10. Which of the following functions decrypts data by using a symmetric key ?
A. DECRYPTBYSYMKEY
B. DECRYPTBYKEYAUTOASYMKEY
C. DECRYPTBYASYMKEY
D. DECRYPTBYKEYAUTOCERT
Answer:A
Explanation:To use cell-level encryption, the schema must be changed to varbinary, then reconverted to the desired data type. 10. Which of the following functions decrypts data by using a symmetric key ?
A. DECRYPTBYSYMKEY B. DECRYPTBYKEYAUTOASYMKEY C. DECRYPTBYASYMKEY D. DECRYPTBYKEYAUTOCERT
Explanation:DECRYPTBYKEYAUTOASYMKEY, which decrypts data by using a symmetric key that’s automatically decrypted with an asymmetric key. Sanfoundry Global Education & Learning Series – SQL Server.