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

The correct answer is A. Use Data Pump. B. Use ALTERTABLE. . .MOVE C. Use CREATE TABLE AS SELECT. Finally, note that you can only create encrypted tablespaces; you cannot modify existing tablespaces to encrypt them. So, when you need existing data in encrypted tablespaces, the best solution is to first create encrypted tablespaces and then move the objects from the…

New Features for Security

Question

Options

AUse Data Pump.
BUse ALTERTABLE. . .MOVE
CUse CREATE TABLE AS SELECT
DUse alter tablespace to encrypt the tablespace after enabling row movement on all its
EUse altertablespace to encrypt the tablespace.

How the community answered

(28 responses)

A
82% (23)
D
11% (3)
E
7% (2)

Explanation

Finally, note that you can only create encrypted tablespaces; you cannot modify existing tablespaces to encrypt them. So, when you need existing data in encrypted tablespaces, the best solution is to first create encrypted tablespaces and then move the objects from the unencrypted tablespaces to them.

Topics

#tablespace encryption#TDE#Data Pump encrypt#ALTER TABLE MOVE

Community Discussion

No community discussion yet for this question.

Full 1Z0-067 Practice