1z1-074 무료 덤프문제 온라인 액세스

Which three statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose three.)

• A.It recommends implementing SQL profiles to generate better execution plans.
• B.It analyzes only the components and waits that are impacting database performance.
• C.It determines the segments on which waits are occurring when the database has a high number of buffer busy waits.
• D.It analyzes the performance of the database instance based on the latest two AWR snapshots.
• E.It analyzes only those memory components of the database instance that are impacting performance.
• F.It determines SQL statements that are performing poorly.

A CDB, CDB1, has a LOCATIONS application container.
NORTH_PDB and SOUTH_PDB are two application PDBs in LOCATIONS.
Both application PDBs are synchronized with the application installed in the LOCATIONS root...
In CDB2, you create a remote clone, LOC_R, of the LOCATIONS application root.
You want to query data across the LOCATIONS application PDBs created in CDB1 and CDB2.
How can you do this?

• A.by creating a proxy PDB in LOCATIONS_ROOT in CDB1, referencing LOC_R
• B.by using private database links created in CDB1 and CDB2
• C.by creating a proxy PDB in CDB2 root, referencing LOC_R
• D.by using public database links created in CDB1 and CDB2
• E.by creating a proxy PDB in CDB1 root, referencing LOC_R

Which two operations is the opc user authorized to perform in an Oracle Database Cloud environment?
(Choose two.)

• A.Run all commands as root.
• B.Run some commands as root.
• C.Only run some commands as oracle.
• D.Log in to the database deployment compute node.
• E.Only run all commands as oracle.

In which four situations does the RMAN DUPLICATE command use the "pull" method? (Choose four.)

• A.when IMAGE COPIES are used for the DUPLICATE operation
• B.when the SET ENCRYPTION clause is added before the DUPLICATE command
• C.when the USING COMPRESSED BACKUPSET clause is used
• D.when no auxiliary channels are allocated
• E.when the number of auxiliary channels allocated is less than the number of target channels allocated
• F.when the USING BACKUPSET clause is used
• G.when the SECTION SIZE clause is used

You receive complaints about poor performance in an Oracle 12c database while long running queries execute.
You must obtain statistics such as elapsed time, CPU time, number of reads and writes, I/O wait time, and other wait times for each step of each execution plan to help diagnose the problem during query execution.
How would you achieve this?

• A.by enabling SQL trace for each query
• B.by enabling tracing for sessions that run these queries
• C.by viewing Active Reports for that time period
• D.by running the Active Session History (ASH) report for that time period
• E.by running the Automatic Workload Repository (AWR) report for that time period