A.Application-common Oracle Label Security (OLS) policies cannot be created in an application root outside an install/patch BEGIN-END block.

B.Application-common TSDP policies are always container specific.

C.Virtual Private Database (VPD) policies on objects in an application root are automatically synchronized with all application PDBs contained in the application container.

D.Application-common Transparent Security Data Protection (TSDP) policies can be created only within an application 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.

A.All memory advisors use data from Automatic Workload Repository.

B.If Automatic Memory Management is enabled, no memory advisors are available.

C.If Automatic Memory Management is enabled, the Shared Pool Advisor and Buffer Cache Advisor are available to set the maximum size for these individual System Global Area components.

D.If Automatic Shared Memory Management is enabled, both the SGA Advisor and PGA Advisor are always available.

E.If Manual Shared Memory Management is enabled, only the Shared Pool Advisor and Buffer Cache Advisor are available.

A.It always analyzes all schemas in the database.

B.It runs automatically every night by default.

C.It can recommend changes to improve the statistics gathering process.

D.It can be run only manually.

E.It can be run only automatically.

A.It considers all SQL statements being analyzed by the advisor task as a group.

B.It checks each query being analyzed for missing or stale statistics.

C.It prevents performance regressions for SQL statements when changes are made.

D.It only recommends syntactic changes to SQL statements.

E.It can recommend semantic changes to SQL statements.

A.It will create '$ORACLE_HOME/dbs/cdb1/CDB1/controlfile02.ctl'

B.It will re-create '/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl'

C.It will fail because there is no autobackup of the controlfiles.

D.It will create '/u01/app/oralce/oradata/CDB1/controlfile/controlfile02.ctl'.

E.It will create '/u01/app/oracle/product/12.2.0.1/db_1/dbs/snapcf_cdb1control02.ctl'.