Which statement about the Oracle Advanced Security Data Redaction feature is true? 

Answer options:

A. It transparently encrypts data at rest in Oracle databases.
B. It securely manages encryption keys.
C. It protects against theft or loss of disks and backups.
D. It prevents OS users from inspecting tablespace files.
E. It limits the exposure of sensitive data in applications.
F. It alters data in caches, buffers, and persistent storage.
G. It impacts operational activities such as backup & restore, upgrade & patch, and replication.

E

Redacting Sensitive Data for Display Data Redaction provides selective, on-the-fly redaction of sensitive data in query results prior to display by applications so that unauthorized users cannot view the sensitive data. It enables consistent redaction of database columns across application modules accessing the same data. Data Redaction minimizes changes to applications because it does not alter actual data in internal database buffers, caches, or storage, and it preserves the original data type and formatting when transformed data is returned to the application. Data Redaction has no impact on database operational activities such as backup and restore, upgrade and patch, and high availability clusters. References: