nerdexam
Oracle

1Z0-034 · Question #46

ENCRYPT_TS is an encrypted tablespace that contains tables with data. Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in…

The correct answer is C. The data remains encrypted when it is stored in the redo logs. See the full explanation below for the reasoning.

Question

ENCRYPT_TS is an encrypted tablespace that contains tables with data. Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?

Options

  • AThe data is decrypted during SORT and JOIN operations.
  • BThe data remains encrypted when it is read into memory.
  • CThe data remains encrypted when it is stored in the redo logs.
  • DThe data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was

How the community answered

(49 responses)
  • A
    8% (4)
  • B
    14% (7)
  • C
    73% (36)
  • D
    4% (2)

Community Discussion

No community discussion yet for this question.

Full 1Z0-034 Practice