Free Oracle 1Z0-084 Practice Test & Real Exam Questions

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: Aug 21, 2026

Question #1

You need to collect and aggregate statistics for the ACCTG service and PAYROLL module, and execute:

Where do you find the output of this command?

A. By viewing V$SERV_MOD_ACT_STATS

B. In the current working directory

C. In $ORACLE_BASE/diag/rdbms/<db unique name>/<instance name>/trace

D. By viewing V$SERVICE_STATS

Discussion 0

Correct Answer: A Vote an answer

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

Question #2

Which statement is true about DB time in V$$YS_TIME_MODEL?

A. DB time can be many times greater than the elapsed time since the database instance started.

B. DB time is organized as a simple list of statistics and any time period is attributable to only one statistic.

C. DB time includes the time spent executing the RMAN backup and restore command.

D. DB tine excludes the time spent waiting for a CPU in the operating system run queue.

Discussion 0

Correct Answer: A Vote an answer

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

Question #3

Which three statements are true about server-generated alerts?

A. Their threshold settings can be modified by using DBMS_SERVER_ALERT.

B. They are notifications from the Oracle Database Server of an existing or impending problem.

C. They are logged in the alert log.

D. They provide notifications but never any suggestions for correcting the identified problems.

E. They may contain suggestions for correcting the identified problems.

F. They can be viewed only from the Cloud Control Database home page.

Discussion 0

Correct Answer: B,C,E Vote an answer

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

Question #4

You must produce a consolidated formatted trace file by combining all trace files generated by all clients for a single service.
Which combination of utilities does this?

A. Trace Analyzer and Tracsess

B. TKPROF and Trace Analyzer

C. Trcsess and TKPROF

D. Autotrace and TKPROF

Discussion 0

Correct Answer: C Vote an answer

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

Question #5

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. Setting cursor_sharing to EXACT prevents Adaptive Cursor Sharing from being used.

C. 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.

D. 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.

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

Discussion 0

Correct Answer: B,C Vote an answer

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

Question #6

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

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

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

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

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

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

Discussion 0

Correct Answer: B,E Vote an answer

Explanation: Only visible for Pass4Leader 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.