1z0-067 Oracle Exam Questions and Free Practice Test

Question 19

Which three statements are true about Consolidated Database Replay?

A. The workload capture and replay systems must have the same operating system (OS).

B. Multiple workload captures from multiple databases can be replayed simultaneously on all pluggable databases (PDBs) in a multitenant container database (CDB).

C. A subset of the captured workload can be replayed.

D. The number of captured workloads must be the same as the number of PDBs in a multitenant CDB.

E. Multiple replay schedules can be defined for a consolidated replay and during replay initialization, you can select from any of the existing replay schedules.

Correct Answer:BCE
https://docs.oracle.com/database/121/RATUG/GUID-36DE5567-5A64-493B-A154- 6581C678FC8A.htm#RATUG105
These capture files are platform independent and can be transported to another system. https://docs.oracle.com/database/121/RATUG/GUID-42958859-005D-4B93-9DD3- 79807968EA9E.htm#RATUG4199
You can use Consolidated Database Replay to combine the captured workloads from the three applications and replay them concurrently on PDBs. https://docs.oracle.com/database/121/RATUG/GUID-C4DC0795-74B2-456D-AA0AB4F7F45C81F8. htm
https://docs.oracle.com/database/121/RATUG/GUID-B1AEA82F-60E5-43CE-BB12- C6D72232886A.htm

Question 20

You notice that the performance of your production 24/7 Oracle 12c database has significantly degraded. Sometimes you are not able to connect to the instance because it hangs. You do not want to restart the database instance.
How can you detect the cause of the degraded performance?

A. Enable Memory Access Mode, which reads performance data from SGA.

B. Use emergency monitoring to fetch data directly from SGA for analysis.

C. Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.

D. Use Active Session History (ASH) data and hang analysis in regular performance monitoring,

E. Run ADDM in diagnostic mod

Correct Answer:B

Question 21

Identify two scenarios in which the RMAN crosscheck command can be used.

A. when checking for backups that are not required as per the retention policy

B. when updating the RMAN repository if any of the archived redo log files have been deleted without using RMAN to do the deletes

C. when updating outdated information about backups that disappeared from disk or media or became corrupted and inaccessible

D. when synchronizing backups, which were not performed by using RMAN, with the RMAN repository

E. when listing backups that are required for recovery operations

Correct Answer:BC

Question 22

Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information Lifecycle Management (ILM)?

A. tracking the most recent read time for a table segment in a user tablespace

B. tracking the most recent write time for a table segment in a user tablespace

C. tracking insert time by row for table rows

D. tracking the most recent write time for each block in a table segment

E. tracking the most recent read time for a table segment in the sysauxtablespace

F. tracking the most recent write time for a table segment in the sysauxtablespace

Correct Answer:ABD
Tracking of segment-level reads and writes At the block level, Heat Map tracks only the most recent modification time stamp.

Question 23

The CATDBI2c database contains an Oracle Database 12c catalog schema owned by the rc12c user. The CATDB11 database contains an Oracle Database l1g catalog schema owned by the RC11 user. A database with DBID=1423241 is registered in the CATDB11 catalog. Both the recovery catalog databases are open.
In the CATDB12c database, you execute the commands: Srman
RMAN> CONNECT CATALOG rc12c/pass12c@catdbI2c
RMAN> IMPOST CATALOG rc1l/pwdcatl11@catdbl1 DBID=I423241; What is the outcome of the import?

A. It fails because the target database and recovery catalog database are of different versions.

B. It succeeds and all global scripts in the RC11 catalog that have the same name as existing global scripts in the RC12C catalog are automatically renamed.

C. It succeeds but the database is not automatically registered in the Rc12c catalog.

D. It fails because RMAN is not connected to the target database with DBID=1423241.

Correct Answer:A
The version of the source recovery catalog schema must be equal to the current version of the destination recovery catalog schem
A. If they are not equal, then upgrade the schemas to the same version.
https://docs.oracle.com/database/121/RCMRF/rcmsynta026.htm#RCMRF198

Question 24

Which two resources might be prioritized between competing pluggable databases (PDBs) when creating a multitenant container database (COB) plan using Oracle Database Resource Manager?

A. maximum undo per consumer group

B. maximum idle time for a session in a PDB

C. parallel server limit

D. CPU

E. maximum number of sessions for a PDB

Correct Answer:CD

START 1z0-067 EXAM