Explanation: To find out what’s signed by the certificate, you can use the sys.certificates. 9. ___________ encryption was introduced in SQL Server 2005 and is available in all editions of SQL Server.
A. Column-level Encryption
B. Transparent Data Encryption
C. Bit Locker
D. None of the mentioned
Answer:A
Explanation: To find out what’s signed by the certificate, you can use the sys.certificates. 9. ___________ encryption was introduced in SQL Server 2005 and is available in all editions of SQL Server.
A. Column-level Encryption B. Transparent Data Encryption C. Bit Locker D. None of the mentioned
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 ?