1Z0-084 by Oracle Actual Free Exam Q&As

Question 1

Examine this command:

What is the maximum number of baselines generated by this command that you can have at any given time?

A. 3 B. 52 C. 5 D. 1

Discussion 0

Correct Answer: B Vote an answer

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

Question 2

Which two types of performance problems are reported by ADDM for PDBS?

A. Excessive checkpoint writes B. User I/O waits C. SGA sizing issues D. I/O capacity limits E. Top SQL statements

Discussion 0

Correct Answer: D,E Vote an answer

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

Question 3

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. Partition the SALES table. D. Re-create the SALES table. E. Compress the SALES table.

Discussion 0

Correct Answer: C,E Vote an answer

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

Question 4

Examine this AWR report excerpt:

You must reduce the impact of database I/O, without increasing buffer cache size and without modifying the SQL statements.
Which compression option satisfies this requirement?

A. MN STORE COMPRESS FOR QUERY LOW B. COLUMN STORE COMPRESS FOR QUERY HIGH C. STORE COMPRESS D. ROW STORE COMPRESS ADVANCED

Discussion 0

Correct Answer: B Vote an answer

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

Question 5

Which three types of statistics are captured by statspack with snap level 6?

A. Plan usage data B. Parent and child latches C. Segment-level statistics D. Enqueue statistics E. Parent and child latches F. Optimizer execution plans

Discussion 0

Correct Answer: C,D,E Vote an answer

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

Question 6

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 index IX_SALES_TIME_ID using ADVANCED COMPRESSION. C. Re-create the SALES table using the columns in IX_SALES_TIME_ID as the hash partitioning key. D. Partition index IX_SALES_TIME_ID using hash partitioning.

Discussion 0

Correct Answer: B Vote an answer

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

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