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

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

Comment: *

Name: *

Email: *

Verification: *

Examine this output:

Which two are true? (Choose two.)

• A.Any PDB not specified in the plan will be able to use a maximum of 16.5% of the available system resources.
• B.PDB3 is guaranteed to receive at least 20% of the available system resources if there is enough demand.
• C.PDB2 is guaranteed at least 25% of the available parallel execution processes if there is enough demand.
• D.PDB3 can use all available parallel execution processes at times.
• E.Any PDB not specified in the plan will be unable to execute statements in parallel.
• F.PDB1 is always limited to 40% of the available system resources regardless of demand.

Comment: *

Name: *

Email: *

Verification: *

Examine this configuration:
1. CDB1is an Oracle Database 12c Release 2 database containing pluggable databases PDB$SEED, PDB1, and PDB2.
2. PDB$SEEDis open READ ONLY
3. PDB1is open READ WRITE
4. PDB2 is MOUNTED.
5. ORACLE_HOMEis /u01/app/oracle/product/18.1.0/dbhome_1.
You execute these commands before upgrading the database to the current release:

For which databases will fixup scripts be created?

• A.CDB1and PDB$SEEDonly
• B.CDB1, PDB1, and PDB2only
• C.PDB$SEED, PDB1, and PDB2only
• D.CDB1, PDB$SEED, PDB1, and PDB2
• E.CDB1, PDB$SEED, and PDB1 only

Comment: *

Name: *

Email: *

Verification: *

Which two are true about creating RMAN backups for an Oracle container database?

• A.Online Redo Log backups can be created while connected to CDB$ROOT
• B.Control file backups can not be created while connected to a PDB
• C.The BACKUP TABLESPACE command can back up a pDB tablespace even if RMAN is connected to CDB$ROOT.
• D.Control file backups can be created while connected to CDB$ROOT.
• E.Archived Redo Log backups can be created while connected to PDB

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *