1Z0-084 Exam Training Practice Tests (Oracle Database 19c Performance and Tuning Management)]

Question 1

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 their wait time incremented every microsecond. C. Rows for sessions that are not waiting might contain the actual wait time for the last event for which they waited. D. Rows for sessions that are currently waiting have a wait time of 0. E. Rows for sessions displaying WAITED UNKNOWN TIME in the STATE column indicate that the session is still waiting.

Correct Answer: C,D

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

Question 2

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. Coalesce all sales table indexes. C. Compress the SALES table. D. Re-create the SALES table. E. Partition the SALES table.

Correct Answer: C,E

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

Question 3

Examine these statements and output:

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

A. optimizer_adaptive_plans=TRUE B. optimizer_features_enable=12.2.0.1 C. optimizer_adaptive_statistics = TRUE D. optimizer_dynamic_sampling=11 E. optimizer_capture_sql_plan_baselines_TRUE

Correct Answer: C

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

Question 4

Examine this statement and output:

Which two situations can trigger this error?

A. The instance is unable to access the capture directory. B. There is a file in the capture directory. C. The capture directory is part of the root file system. D. The user lacks the required privileges to execute the DBMS WORKLOAD CAPTURE package or the directory. E. The syntax is incomplete.

Correct Answer: A,D

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

Question 5

An Oracle 19c database uses default values for all optimizer initialization parameters.
After a table undergoes partition maintenance, a large number of wait events occur for:
cursor: pin S wait on X
Which command reduces the number of these wait events?

A. ALTER SYSTEM SET SESSION CACHED CURSORS = 500; B. ALTER SYSTEM SET CURSOR_INVALIDATION = DEFERRED; C. ALTER SYSTEM SET CURSOR_SPACE_FOR_TIME - TRUE; D. ALTER SYSTEM SET CURSOR_SHARING = FORCE;

Correct Answer: B

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

Question 6

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. The performance of workloads that primarily generate full table scans and fast full index scans are always affected by the cache hit ratio. B. A 99% cache hit ratio can be observed for database instances which have very poor I/O performance. C. Both the RECYCLE and KEEP buffer caches should always have a very high cache hit ratio. D. A 60% cache hit ratio can be observed for database instances which have very good I/O performance. E. The buffer cache advisory view v$db_cache_advice provides advice on cache hit ratios appropriate for the instance workload.

Correct Answer: B,E

Oracle Database 19c Performance and Tuning Management - 1Z0-084 Exam Practice Test