Oracle Database Administration II — Question 31

Which three are true? (Choose three.)

Answer options

• A. Virtual Private Database (VPD) policies on objects in an application root are automatically synchronized with all application PDBs contained in the application container.
• B. Application-common TSDP policies are always container specific.
• C. Application-common Transparent Security Data Protection (TSDP) policies can be created only within an application install/patch BEGIN-END block.
• D. Application-common Oracle Label Security (OLS) policies cannot be created in an application root outside an install/patch BEGIN-END block.
• E. Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container.
• F. Application-common OLS policies can be created in an application root inside an install/patch BEGIN-END block.
• G. Unified auditing can be automatically synchronized to all application PDBs in an application container.

Correct answer: D, E, G

Explanation

The correct answers D, E, and G are true because Oracle Label Security policies must be created within specific blocks, while Unified auditing and Fine-grained auditing policies are synchronized automatically across PDBs. Options A, B, C, and F contain incorrect statements about the synchronization and creation of policies within application containers.