Free Access Oracle.1z0-063.v2022-10-18.q151 Practice Test (Page 8)

Question 31

You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.
Which method or feature should you use?

A.Compare Period ADDM report

B.AWR Compare Period report

C.Active Session History (ASH) report

D.Taking a new snapshot and comparing it with a preserved snapshot

Question 32

Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)? (Choose two.)

A.If no PDB plan is enabled for a pluggable database, all sessions for that PDB are treated to an equal share of resources.

B.To enable a resource plan for a PDB, a CDB resource plan must be created and enabled.

C.If a PDB plan is enabled for a pluggable database, Resource Manager uses the resource allocation at the PDB level and ignores the limits set at the CDB level.

D.If no PDB plan is enabled for a pluggable database, the PDB uses the CDB plan.

E.If a PDB plan is enabled for a pluggable database, resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.

Question 33

One of your database runs in ARCHIVELOG mode.
Examine these initialization parameter settings:

Which statement is true based on these settings?

A.An online redo log will not be overwritten only if an archived log cannot be created in at least two of the non- mandatory destinations and LOG_ARCHIVE_DEST_4.

B.An online redo log will not be overwritten only if an archived log cannot be created in at least two of the non- mandatory destinations.

C.An online redo log will not be overwritten only if an archived log cannot be created in LOG_ARCHIVE_DEST_4.

D.An online redo log will not be overwritten only if an archived log cannot be created in at least one of the non-mandatory destinations and LOG_ARCHIVE_DEST_4.

Question 34

Examine the resources consumed by a database instance whose current Resource Manager plan is displayed.
SQL> SELECT name, active_sessions, queue_length,
consumed_cpu_time, cpu_waits, cpu_wait_time
FROM v$rsrc_consumer_group;

Which two statements are true? (Choose two.)

A.An attempt to start a new session by a user belonging to DSS_QUERIES fails with an error.

B.The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management.

C.A user belonging to the DSS_QUERIES resource consumer group can create a new session but the session will be queued.

D.An attempt to start a new session by a user belonging to OTHE_GROUPS fails with an error.

E.The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to I/O waits and latch or enqueue contention.

Question 35

Examine the commands executed to monitor database operations:
$ > conn sys/oracle@prod as sysdba
SQL> VAR eid NUMBER
SQL>EXEC :eid := DBMS_SQL_MONITOR.BEGlN_OPERATION
('batch_job',FORCED_TRACKING=>'Y');
Which two statements are true?

A.Database operations will be monitored only when they consume a significant amount of resource.

B.Database operations for all sessions will be monitored.

C.Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + TUNING.

D.Only DML and DDL statements will be monitored for the session.

E.All subsequent statements in the session will be treated as one database operation and will be monitored.

Other Version: 3049Oracle.1z0-063.v2022-04-21.q171

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

Question 31

Question 32

Question 33

Question 34

Question 35

Download PDF File