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 #1

SGA_TARGET and PGA_AGGREGATE_TARGET are configured to nonzero values.
MEMORY_target is then set to a nonzero value but memory_MAX_TARGET is not set.
Which two statements are true?

Discussion 0

Correct Answer: A,C Vote an answer

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

Question #2

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$RMAN_BACKUP_JOB_DETAILS

C. V$SESSION

D. V$SESSION_LONGOPS

Discussion 0

Correct Answer: D Vote an answer

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

Question #3

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

Question #4

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 expdp from Statspack and import it by using $ORACLE_HOME/rdbms/admin
/awrload into the AWR repository.

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

Discussion 0

Correct Answer: D Vote an answer

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

Question #5

During which application lifecycle phase do you take baselines?

A. Production

B. Migration or upgrade

C. Testing

D. Deployment

E. Design and development

Discussion 0

Correct Answer: A 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 disabling Automatic Shared Memory Management (ASMM)?

A. It requires a database instance restart to take effect.

B. All SGA components excluding fixed SGA and other internal allocations are readjusted immediately after disabling ASMM.

C. Both SGA_TARGET and SGA_MAX_SIZE must be set to zero.

D. All SGA components retain their current sizes at the time of disabling.

E. The SGA size remains unaffected after disabling ASMM.

F. All auto-tuned SGA components are reset to their original user-defined values.

Discussion 0

Correct Answer: D,E 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.