Free Access Oracle.1Z1-060.v2022-03-23.q171 Practice Test (Page 7)

Question 26

Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR) report:

What are three possible causes for the latch-related wait events?

A.Cursors are not being shared.

B.The size of the shared pool is too small.

C.There are frequent logons and logoffs.

D.The buffers are being read into the buffer cache, but some other session is changing the buffers.

E.A large number COMMITSare being performed.

Question 27

You are connected using SQL* Plus to a multitenant container database (CDB) with SYSDBAprivileges and execute the following sequence statements:

What is the result of the last SET CONTAINERstatement and why is it so?

A.If fails because the SET CONTAINERstatement cannot be used with PDB$SEED as the target pluggable database (PDB).

B.It fails because local users are unable to use the SET CONTAINERstatement.

C.It fails because common users are unable to use the SET CONTAINERstatement.

D.It succeeds because the PDB_ADMINuser has the required privileges.

Question 28

Which two statements are true concerning Information Lifecycle Management (ILM) policies? (Choose two.)

A.ILM policy functions return a Boolean value.

B.Multiple ILM policies may exist for the same segment and any compression levels may be specified for any policy.

C.Multiple ILM policies may exist for the same table, if the action is compression and the scope is at the row level.

D.Multiple ILM policies may exist for the same segment but greater compression levels must be specified at greater elapsed times.

E.Segment-level policies override row-level policies.

Question 29

Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?

A.By default, EM express is available for a database after database creation.

B.You can use EM express to manage multiple databases running on the same server.

C.You can perform basic administrative tasks for pluggable databases by using the EM express interface.

D.You cannot start up or shut down a database Instance by using EM express.

E.You can create and configure pluggable databases by using EM express.

Question 30

You notice that the elapsed time for an important database scheduler job is unacceptably long.
The job belongs to a scheduler job class and runs in a scheduler window.
Which two actions could reduce the job's elapsed time? (Choose two.)

A.increasing the job's relative priority within the job class to which it belongs

B.increasing resource allocation for the consumer group mapped to the job class in the resource manager plan associated with the scheduler window

C.moving the job to an existing higher priority scheduler window with the same schedule and duration

D.increasing the priority of the scheduler window to which the job belongs

E.increasing the value of the JOB_QUEUE_PROCESSES parameter

Latest Upload: 107Oracle.1Z0-1057-23.v2025-09-10.q47; 150Google.Professional-Cloud-Network-Engineer.v2025-09-09.q179; 131SAP.C-S4EWM-2023.v2025-09-08.q83; 155TheSecOpsGroup.CNSP.v2025-09-08.q20; 206CFAInstitute.ESG-Investing.v2025-09-08.q173; 153PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 140Salesforce.Data-Architect.v2025-09-05.q216; 136Adobe.AD0-E605.v2025-09-05.q50; 176Nutanix.NCP-MCI-6.10.v2025-09-05.q55; 114Oracle.1z0-591.v2025-09-05.q104

Question 26

Question 27

Question 28

Question 29

Question 30

Download PDF File