1Z0-084 by Oracle Valid Free Exam Practice Test

Question 1

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. Database Replay C. Statspack report D. AWR Compare Periods report

Correct Answer: C

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

Question 2

During which application lifecycle phase do you take baselines?

A. Testing B. Design and development C. Migration or upgrade D. Production E. Deployment

Correct Answer: D

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

Question 3

Multiple sessions are inserting data concurrently into a table that has an LOB column.
At some point in time, one of the sessions cannot find available space in the LOB segment and needs to allocate a new extent.
Which wait event will be raised in the other sessions that need space in the LOB column?

A. enq: HW - contention B. enq: TM - contention C. enq: SQ - contention D. enq: TX - allocate ITL entry

Correct Answer: A

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

Question 4

Examine these statements and output:

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

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

Correct Answer: C

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

Question 5

The CURS0R_SHARING and OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES parameters are set to default. The top five wait events in an awr report are due to a large number of hard parses because of several almost identical SQL statements.
Which two actions could reduce the number of hard parses?

A. Set the CURSOR_SHARING parameter to FORCE. B. Increase the size of the library cache. C. Create the RECYCLE cache and cache tables accessed by the SQL statements. D. Create the KEEP cache and cache tables accessed by the SQL statements. E. Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to TRUE.

Correct Answer: A,B

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

Question 6

Examine this statement and output:

Which two situations can trigger this error?

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

Correct Answer: A,D

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

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