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

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

Comment: *

Name: *

Email: *

Verification: *

Which two are true about Rapid Home Provisioning (RHP), which has been available since Orcale 18c? (Choose two.)

• A.It can be used to patch Grid Infrastructure homes containing Oracle Restart.
• B.It can be used to provision applications.
• C.It can be used to provision middleware.
• D.It cannot be used to upgrade Oracle Database homes.
• E.It is an Oracle Database service

Comment: *

Name: *

Email: *

Verification: *

Which three are true about the FLASHBACK DATABASE feature? (Choose three.)

• A.A database can be flashed back using SQL*PLUS.
• B.It requires that the target database be in ARCHIVELOG mode.
• C.FLASHBACK DATABASE only uses FLASHBACK LOGS to get the database to the desired flashback time.
• D.FLASHBACK LOGS are archived after a log switch.
• E.Queries and DML have the same FLASHBACK LOG overhead when flashback is enabled for a database.
• F.It always generates REDO and UNDO.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about the Oracle database tuning methodology?

• A.SQL statements should always be tuned before tuning any file systems.
• B.The database instance memory should always be tuned before tuning any file systems.
• C.Tuning activities should stop once agreed service levels for performance have been met.
• D.The alert log should be used to find the database and instance areas most in need of tuning.
• E.The Oracle Database time model should be used to find the database and instance areas most in need of tuning.
• F.Tuning activities should stop once the user is satisfied with performance.

Comment: *

Name: *

Email: *

Verification: *

A container database called CDB1 is OMF-enabled.
PDB_FILE_NAME_CONVERT is not configured in CDB1. PDB1 was unplugged from CDB1 earlier in the week. Examine this command, which will be executed in CDB1:
CREATE PLUGGABLE DATABASE pdb1
USING '/u01/app/oracle/oradata/pdb1.xml'
SOURCE_FILE_NAME_CONVERT =
('/u01/app/oracle/oradata/', '/u02/app/oracle/oradata/');
Which two are true? (Choose two.)

• A.PDB1 must be dropped from CDB1.
• B.PDB_FILE_NAME_CONVERT must be set before executing the command.
• C./u01/app/oracle/oradata/pdb1.xml does not contain the current locations of data files for PDB1.
• D.DBMS_PDB.CHECK_PLUG_COMPATIBILITY must be run in CDB1 before executing the command.
• E.PDB1 data files already exist in the correct location.

Comment: *

Name: *

Email: *

Verification: *