Your customer is trying to decide which type of Transparent Data Encryption (TDE) to use. They want
to encrypt about 70% of the columns in a particular table, stored in a single tablespace. Which type
of encryption would you recommend?
A.
Column-based encryption because it typically performs better
B.
Tablespace encryption because it typically performs better unless a very small portion of the table
is to be encrypted
C.
Tablespace encryption because it typically performs better in all cases
D.
Column-based encryption if some of the encrypted data is large objects, table-based encryption if
there are no large objects to be encrypted
Explanation:
You can encrypt a new tablespace while you are creating it, but you cannot encrypt an existing
tablespace. As a workaround, you can use the CREATE TABLE AS SELECT, ALTER TABLE MOVE, or use
Oracle Data Pump import to get data from an existing tablespace into an encrypted tablespace.