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

Exam Code/Number: 1z1-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 11, 2026

Question #25

A Standard Edition production database has performance problems for two hours on the same day each week.
Which tool must you use to diagnose the problem?

A. SQL Performance Analyzer

B. AWR Compare Periods report

C. Database Replay

D. Statspack report

Discussion 0

Correct Answer: D Vote an answer

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

Question #26

This error occurred more than four hours ago in the database:
ORA-04036 PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
You want to know which process and query were at fault.
Which two views should you use for this purpose?

A. DBA_HIST_SQLSTAT

B. DBA_HIST_PROCESS_MEM_SUMMARY

C. DBA_HIST_ACTIVE_SESS_HISTORY

D. DBA_HIST_SQLTEXT

E. DBA_HIST_PGASTAT

Discussion 0

Correct Answer: B,C Vote an answer

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

Question #27

Which two statements are true about Data Pump import for objects that used the in Memory (IM) column store in their source database?

A. Its TRANSFORM clause can be used to add the INMEMORV clause to exported tables that lack them.

B. It always gives preference to the IM column store clause defined at the tablespace level over table-level definitions.

C. It can generates the INMEMORY clause that matches the table settings at export time.

D. It must always transports existing INMEMORY attributes.

E. It ignores the IM column store clause of the exporting objects.

F. Its INMEM0RY_CLAUSE of the Data Pump Export allows modifications to IM column store clause of a table with existing INMEMORY setting.

Discussion 0

Correct Answer: A,C Vote an answer

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

Question #28

You need to transport performance data from a Standard Edition to an Enterprise Edition database. What is the recommended method to do this?

A. Export the data by using the exp utility and parameter file spuexp.par from the Statspack repository and import it by using imp into a dedicated Statspack schema on the destination.

B. Export the data by using expdp from the ftatspack repository and import it by using impdp into the AWR repository.

C. Export the data by using the expdp utility and parameter file spuexp.par from the Statspack repository and import it by using impdp into Export the data by using expdp from the Statspack repository and import it by using impdp into the AWR repository.

D. Export the data by using expdp from Statspack and import it by using $ORACLE_HOME/rdbms/admin
/awrload into the AWR repository.

Discussion 0

Correct Answer: A Vote an answer

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

Question #29

Examine this command:

What is the maximum number of baselines generated by this command that you can have at any given time?

A. 52

B. 5

C. 3

D. 1

Discussion 0

Correct Answer: A Vote an answer

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

Question #30

Which procedure gathers statistics that are always used in the generation of any execution plan?

A. DBMS_STATS.GATHER_FIXED_ OBJECTS_STATS

B. DBMS_STATS.GATHER_SYSTEM_STATS

C. DBMS_STATS.GATHER_DATABASE_STATS

D. DBMS_STATS.GATHER_DICTIONARY_STATS

Discussion 0

Correct Answer: C Vote an answer

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

Download Free Oracle 1z1-084 Demo

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