Oracle Database Administration II — Question 153

Which two are true about various Oracle security and auditing capabilities? (Choose two.)

Answer options

• A. Application-common Transparent Security Data Protection (TSDP) policies can be created only if all the PDBs in the application container are closed.
• B. Application-common TSDP policies are always container specific.
• C. Application-common OLS policies can be created only if all the PDBs in the application container are closed.
• D. Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container when they are updated.
• E. Unified auditing can be automatically synchronized to all application PDBs in an application container.

Correct answer: B, E

Explanation

Option B is correct because application-common TSDP policies are indeed specific to the container. Option E is also correct since unified auditing can be synchronized across all application PDBs. Options A and C are incorrect as TSDP and OLS policies can be created without requiring all PDBs to be closed. Option D is incorrect because FGA policies do not automatically synchronize across PDBs.