Oracle
1Z0-050 · Question #4
1Z0-050 Question #4: Real Exam Question with Answer & Explanation
The correct answer is A. Use Data Pump to transfer the existing data to a new encrypted tablespace. B. Use ALTER TABLE..MOVE to transfer the existing data to a new encrypted tablespace. C. Use CREATE TABLE AS SELECT to transfer the existing data to a new encrypted tablespace.. See the full explanation below for the reasoning.
Question
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.)
Options
- AUse Data Pump to transfer the existing data to a new encrypted tablespace.
- BUse ALTER TABLE..MOVE to transfer the existing data to a new encrypted tablespace.
- CUse CREATE TABLE AS SELECT to transfer the existing data to a new encrypted tablespace.
- DEnable row movement for each table to be encrypted and then use ALTER TABLESPACE to
- EEncrypt the USER_DATA tablespace using the ALTER TABLESPACE statement so that all the
Community Discussion
No community discussion yet for this question.