Which methods would you use to achieve this?

USER_DATA is a nonencrypted tablespace that contains a set of tables with data. You want
to convert all existing data in the USER_DATA tablespace and the new data into the
encrypted format. Which methods would you use to achieve this? (Choose all that apply.)

USER_DATA is a nonencrypted tablespace that contains a set of tables with data. You want
to convert all existing data in the USER_DATA tablespace and the new data into the
encrypted format. Which methods would you use to achieve this? (Choose all that apply.)

A.
Enable row movement for each table to be encrypted and then use ALTER
TABLESPACE to encrypt the tablespace.

B.
Encrypt the USER_DATA tablespace using the ALTER TABLESPACE statement so that
all the data in the tablespace is automatically encrypted.

C.
Use Data Pump to transfer the existing data to a new encrypted tablespace.

D.
Use ALTER TABLE..MOVE to transfer the existing data to a new encrypted tablespace.

E.
Use CREATE TABLE AS SELECT to transfer the existing data to a new encrypted
tablespace.

Explanation:



Leave a Reply 0

Your email address will not be published. Required fields are marked *