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

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: Oct 06, 2026

Question #13

Which Optimizer component helps decide whether to use a nested loop join or a hash join in an adaptive execution plan?

A. Statistics Feedback

B. Statistics Collector

C. Automatic Reoptimization

D. Dynamic Statistics

E. SQL Plan Directives

Discussion 0

Correct Answer: B Vote an answer

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

Question #14

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. Re-create the SALES table sorted in order of index IX_SALES_TIME_ID.

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

C. Re-create index IX_SALES_TIME_ID using ADVANCED COMPRESSION.

D. Partition index IX_SALES_TIME_ID using hash partitioning.

Discussion 0

Correct Answer: C Vote an answer

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

Question #15

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

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

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

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

D. It must always transports existing INMEMORY attributes.

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

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

Discussion 0

Correct Answer: A,F Vote an answer

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

Question #16

Which two Oracle Database features use database services?

A. Oracle Scheduler

B. Database Resource Manager

C. Oracle SQL Performance Management

D. Oracle SQL Tuning Advisor

E. Oracle Automatic Reoptimization

Discussion 0

Correct Answer: A,B Vote an answer

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

Question #17

Examine this statement and output:

Which three statements are true?

A. Session 9857 is not waiting.

B. Session 8779 may be waiting for a user or application response.

C. Both 9822 and 8779 sessions are waiting for operating system resources.

D. Session 9857 waited 1354 seconds for another process, which was also waiting for a transaction to end.

E. Session 9822 will always stop waiting if the session that owns the TX enqueue issues a COMMIT statement as session 9822 is the first session in the transaction queue.

F. Session 8779 may be waiting due to a network problem.

Discussion 0

Correct Answer: B,E,F Vote an answer

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

Question #18

Which two statements are true about space usage in temporary tablespaces?

A. A sort will fail if a sort to disk requires more disk space and no additional extent can be found/allocated in/for the sort segment.

B. When a session consumes all temporary tablespace storage, then the session would hang until the temporary space used by that session is cleared.

C. When a global temporary table instantiation is too large to fit in memory, space is allocated in a temporary tablespace.

D. Lack of temporary tablespace space for sort operations can be prevented by using temporary tablespace groups.

E. Temporary tablespaces setting Includes quotas to limit temporary space used by a session for that Temporary tablespace.

Discussion 0

Correct Answer: C,D Vote an answer

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