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 beencrypted
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 areno large objects to be encrypted
Explanation:
You can encrypt a new tablespace while you are creating it, but you cannot encrypt an existing
tablespace. Asa workaround, you can use the CREATE TABLE AS SELECT, ALTER TABLE
MOVE, or use Oracle DataPump import to get data from an existing tablespace into an encrypted
tablespace.