Oracle Database 12c: Advanced Administration — Question 124

user_data is a nonencryptedtablespace containing tables with data.
You must encrypt ail data in this tablespace.
Which three methods can do this?

Answer options

• A. Use Data Pump.
• B. Use ALTERTABLE. . .MOVE
• C. Use CREATE TABLE AS SELECT
• D. Use alter tablespace to encrypt the tablespace after enabling row movement on all its
• E. Use altertablespace to encrypt the tablespace.

Correct answer: A, B, C

Explanation

The correct answers, A, B, and C, are methods that can be utilized to encrypt the data within the tablespace. Option D, while it mentions altering the tablespace to encrypt it, requires row movement which is not necessary for direct encryption. Option E simply states to use alter tablespace, which does not involve the direct methods to encrypt existing data.