Oracle 1Z0-084 Actual Free Exam Questions & Community Discussion

Exam Code/Number: 1Z0-084
Exam Name/Title: Oracle Database 19c Performance and Tuning Management
Certification Provider: Oracle
Corresponding Certification: Oracle Database 19c

Exam Questions: 57
Updated On: Jul 12, 2026

Question #19

Examine this code block, which executes successfully:
DBMS_SERVER_ALERT. SET_THRESHOLD (
DBMS_SERVER_ALERT.CPU_TIME_PER_CALL, DBMS_SERVER_ALERT. OPERATOR_GE, '8000', DBMS_SERVER_ALERT.OPERATOR_GE, '10000', 1, 2, 'inst1', DBMS_SERVER_ALERT.OBJECT_TYPE_SERVICE, 'main.regress.rdbms.dev.us.example.com') ;

What will happen?

A. A warning alert will be issued when CPU time exceeds 1 minute for each user call.

B. A critical alert will be issued when CPU time exceeds 10000 microseconds for each user call.

C. A critical alert will be issued when CPU time exceeds 2 minutes for each user call.

D. A warning alert will be issued only when CPU time exceeds 10000 microseconds for each user call.

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #20

You are informed that the RMAN session that is performing the database duplication is much slower than usual. You want to know the approximate time when the rman operation will be completed.
Which view has this information?

A. V$SESSTAT

B. V$SESSION_LONGOPS

C. V$SESSION

D. V$RMAN_BACKUP_JOB_DETAILS

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #21

Which two statements are true about session wait information contained in v$session or v$session_wait?

A. Rows for sessions displaying WAITED UNKNOWN TIME in the STATE column indicate that the session is still waiting.

B. Rows for sessions that are not waiting might contain the actual wait time for the last event for which they waited.

C. Rows for sessions that are currently waiting have their wait time incremented every microsecond.

D. Rows for sessions that are not waiting always contain the total wait time since the session started.

E. Rows for sessions that are currently waiting have a wait time of 0.

Discussion 0

Correct Answer: B,E Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #22

Examine this output of a query of VSPGA_TAPGET_ADVICE:

Which statements is true'

A. PGAA_AGGREGATE should be set to at least 800 MB.

B. With a target of 800 MB or more, all one-pass execution work areas would be eliminated.

C. With a target of 700 MB or more, all multipass executions work areas would be eliminated.

D. GGREGATE_TARGET should be set to at least 700 MB.

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #23

Database performance has degraded recently.
index range scan operations on index ix_sales_time_id are slower due to an increase in buffer gets on sales table blocks.
Examine these attributes displayed by querying DBA_TABLES:

Now, examine these attributes displayed by querying DBA_INDEXES:

Which action will reduce the excessive buffer gets?

A. Partition index IX_SALES_TIME_ID using hash partitioning.

B. Re-create index IX_SALES_TIME_ID using ADVANCED COMPRESSION.

C. Re-create the SALES table using the columns in IX_SALES_TIME_ID as the hash partitioning key.

D. Re-create the SALES table sorted in order of index IX_SALES_TIME_ID.

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #24

Which two statements are true about cursor sharing?

A. Setting optimizer_capture_sql_plan_baselines to TRUE loads all adaptive plans for the same statement into the cursor cache.

B. Adaptive Cursor Sharing requires histograms on filtered columns, used in equality predicates, to allow different execution plans to be generated for statements whose bound values would normally generate different plans at hard parse time.

C. Adaptive Cursor Sharing guarantees that a suboptimal plan will never be used on any execution of a SQL statement.

D. Setting cursor_sharing to EXACT prevents Adaptive Cursor Sharing from being used.

E. Setting Cursor_sharing to FORCE can result in a plan that is suboptimal for the majority of values bound to a bind variable when executing a cursor with one or more bind variables.

Discussion 0

Correct Answer: D,E Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Download Free Oracle 1Z0-084 Demo

Simply submit your e-mail address below to get started with our free demo of your Oracle 1Z0-084 exam.