Which two are true about the Automatic Database Diasnostic Monitor (ADDM)? (Choose two.)

• A.It runs automatically after each AWR snapshot.
• B.It analyzes a period of time corresponding to the 12 hours of activity.
• C.Results are written to the alert log.
• D.It analyzes a period of time corresponding to the last day of activity.
• E.A DBA can run it manually.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about Oracle Grid Infrastructure for a Standalone Server? (Choose two.)

• A.It supports volume management, file system, and automatic restart capabilities.
• B.It must be installed before the Oracle database software is installed.
• C.The CSS daemon runs from the Grid Infrastructure home.
• D.It requires Oracle Automatic Storage Management (ASM) components to be installed separately.
• E.It can manage database resources on the server where it is installed or on a different server.

Comment: *

Name: *

Email: *

Verification: *

Oracle Managed Files (OMF) is enabled in a CDB and this command is successfully executed:

Which three are true? (Choose three.)

• A.Application PDBs that are subsequently created in the APP1 application container will be cloned from PDB$SEED.
• B.APP1can never be unplugged.
• C.An application seed PDB is created for APP1.
• D.A default service is created for the application root APP1.
• E.Application PDBs that are subsequently created in the APP1application container will be cloned from APP1$SEED.
• F.An application root PDB is created for APP1.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about Optimizer Statistics Advisor? (Choose three.)

• A.It can be run only manually.
• B.It is part of the DBMS_ADVISORpackage.
• C.It can recommend changes to improve the statistics gathering process.
• D.It always analyzes all schemas in the database.
• E.It runs automatically every night by default.
• F.It is part of the DBMS_STATSpackage.

Comment: *

Name: *

Email: *

Verification: *

The HR_ROOT application container must support the execution of a query on a table shared by application local PDBs PDB1 and PDB2, and remote PDB PDB3.
Which three are true? (Choose three.)

• A.A proxy PDB must exist in the application root in the local CDB.
• B.The HR_ROOT replica must exist in the remote CDB.
• C.PDB3's application root replica must exist in the local CDB.
• D.A database link must exist in the local CDB root referring to the remote CDB.
• E.A proxy PDB must exist in the application root in the remote CDB.
• F.A database link must exist in the remote CDB referring to the local CDB.

Comment: *

Name: *

Email: *

Verification: *