Free Oracle 1z1-063 Exam Dumps Questions & Answers

Which two components are contained only in CDB$ROOT? (Choose two.)

• A.  PDB service names
• B.  resource manager plans for each PDB in the CDB
• C.  database links between PDBs in the CDB
• D.  the default TEMP tablespace for the entire CDB
• E.  the unified audit trail

Examine the following set of RMAN commands:

Which statement is true about the RMAN RUN block execution?

• A.  The script is executed and both DC1 and CH1 channels are used for script execution.
• B.  The new channel, CH1, is ignored because a channel has been configured already.
• C.  The execution of the script fails because multiple channels cannot exist simultaneously.
• D.  The persistent configuration parameter, DC1, is overridden because a new channel is allocated in the RMAN RUN block.

RMAN is connected to a target database instance and an auxiliary instance. You execute the command:

What is the outcome?

• A.  RMAN uses the pull method to restore files using backup sets.
• B.  RMAN uses the push method to transfer image copies.
• C.  RMAN uses the pull method to restore files using image copies.
• D.  RMAN uses the push method to transfer backup sets.

You specified the warning and critical thresholds for a locally managed tablespace to be 60% and 70%, respectively.
From the tablespace space usage metrics, you find that the space usage has reached the specified warning threshold value, but no alerts have been generated.
What could be the reason for this?

• A.  The statistics_level parameter is set to basic.
• B.  The timed_statistics parameter is set to false.
• C.  Enterprise Manager was not used.
• D.  The event parameter was not set.
• E.  The sql_trace parameter is set to false.

Which four are true about Consolidated Database Replay? (Choose four.)

• A.  Multiple replay schedules can be defined for a consolidated replay.
• B.  The number of captured workloads must be the same as the number of PDBs in a multitenant CDB.
• C.  The workload capture and replay servers must run the same operating system (OS).
• D.  A superset of the captured workload can be replayed.
• E.  Multiple workload captures from multiple databases can be replayed simultaneously.
• F.  A single replay schedule can be defined for a consolidated replay.
• G.  A subset of the captured workload can be replayed.