Question: Consider the following command SELECT pgp _ sym _ encrypt ( ' Sensitive Data', 'secret _ passphrase' ) ; as encrypted _ data; What is
Consider the following command
SELECT pgpsymencryptSensitive Data', 'secretpassphrase'; as encrypteddata;
What is the purpose of this command?
Question options:
To create a new encrypted table with the name 'Sensitive Data'.
To generate a new encryption key for the database.
To decrypt the data in the 'encrypteddata' column.
To encrypt the string 'Sensitive Data' using PGP symmetric encryption with 'secretpassphrase'.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
