When implementing Transparent Data Encryption (TDE), which of the following answers describes
the correct order of the listed operations?
A.
Create a wallet, create a master key, and create tables that contain encrypted columns.
B.
Create tables that contain encrypted columns, create a wallet, create a master key, and open the
wallet.
C.
Create a wallet, open the wallet, create a master key, and create tables that contain encrypted
columns.
D.
Create a master key, create a wallet, open the wallet, and create tables that contain encrypted
columns.
Explanation:
Step 2: Create the Wallet
To create the wallet, use the ALTER SYSTEM SQL statement. By default, the Oracle wallet stores a
history of retired master keys, which enables you to change them and still be able to decrypt data
that was encrypted under an old master key
…
ALTER SYSTEM SET ENCRYPTION KEY IDENTIFIED BY “password”;
This statement generates the wallet with a new encryption key and sets it as the current transparent
data encryption master key.
…
Immediately after you create the wallet key, the wallet is open, and you are ready to start encrypting
data.