Oracle
1Z0-067 · Question #224
ENCRYPT_TS an encrypted tablespace that contains tables with data. Which statement is true about queries and data manipulation language statements on these tables?
The correct answer is C. Redo generated by DML remains encrypted. See the full explanation below for the reasoning.
Question
ENCRYPT_TS an encrypted tablespace that contains tables with data. Which statement is true about queries and data manipulation language statements on these tables?
Options
- AQueries may be performed on columns that have the NO SALT option.
- BData remains encrypted when read into the buffer cache.
- CRedo generated by DML remains encrypted.
- DUNDO generated by DML remains encrypted if the UNDO tablespace is encrypted.
- EData remains encrypted when read into the PGA for direct path reads.
How the community answered
(53 responses)- A6% (3)
- B15% (8)
- C75% (40)
- D2% (1)
- E2% (1)
Community Discussion
No community discussion yet for this question.