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

Which two statements are true about disabling Automatic Shared Memory Management (ASMM)?

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

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

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

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

E. The SGA size remains unaffected after disabling ASMM.

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

Discussion 0

Correct Answer: C,E Vote an answer

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

Question #14

Which two statements are true about the use and monitoring of Buffer Cache Hit ratios and their value in tuning Database I/O performance?

A. Both the RECYCLE and KEEP buffer caches should always have a very high cache hit ratio.

B. A 60% cache hit ratio can be observed for database instances which have very good I/O performance.

C. The buffer cache advisory view v$db_cache_advice provides advice on cache hit ratios appropriate for the instance workload.

D. A 99% cache hit ratio can be observed for database instances which have very poor I/O performance.

E. The performance of workloads that primarily generate full table scans and fast full index scans are always affected by the cache hit ratio.

Discussion 0

Correct Answer: C,D Vote an answer

Question #15

Examine these statements and output:

What parameter change activates the generation and use of SQL Plan Directives7

A. optimizer_adaptive_statistics = TRUE

B. optimizer_adaptive_plans=TRUE

C. optimizer_dynamic_sampling=11

D. optimizer_features_enable=12.2.0.1

E. optimizer_capture_sql_plan_baselines_TRUE

Discussion 0

Correct Answer: A Vote an answer

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

Question #16

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: B,E Vote an answer

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

Question #17

Accessing the SALES tables causes excessive db file sequential read wait events.
Examine this AWR except:

Now, examine these attributes displayed by querying dba_tables:

Finally, examine these parameter settings:

Which two must both be used to reduce these excessive waits?

A. Increase PCTFREE for the SALES table.

B. Re-create the SALES table.

C. Compress the SALES table.

D. Partition the SALES table.

E. Coalesce all sales table indexes.

Discussion 0

Correct Answer: C,D Vote an answer

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

Question #18

Which two statements are true about the use and monitoring of Buffer Cache Hit ratios and their value in tuning Database I/O performance?

A. Both the RECYCLE and KEEP buffer caches should always have a very high cache hit ratio.

B. A 60% cache hit ratio can be observed for database instances which have very good I/O performance.

C. The buffer cache advisory view v$db_cache_advice provides advice on cache hit ratios appropriate for the instance workload.

D. A 99% cache hit ratio can be observed for database instances which have very poor I/O performance.

E. The performance of workloads that primarily generate full table scans and fast full index scans are always affected by the cache hit ratio.

Discussion 0

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