Oracle Database 19c Performance and Tuning Management

Question 1

Examine this statement and its corresponding execution plan:

Which phase introduces the CONCATENATION step?

A. SQL Transformation

B. SQL Row Source Generation

C. SQL Adaptive Execution

D. SQL Execution

E. SQL Semantic Check

Correct Answer: A

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

Question 2

Which two Oracle Database features use database services?

A. Database Resource Manager

B. Oracle SQL Performance Management

C. Oracle Automatic Reoptimization

D. Oracle Scheduler

E. Oracle SQL Tuning Advisor

Correct Answer: A,D

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

Question 3

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 using the columns in IX_SALES_TIME_ID as the hash partitioning key.

B. Re-create the SALES table sorted in order of index IX_SALES_TIME_ID.

C. Partition index IX_SALES_TIME_ID using hash partitioning.

D. Re-create index IX_SALES_TIME_ID using ADVANCED COMPRESSION.

Correct Answer: D

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

Question 4

You must produce a consolidated formatted trace file by combining all trace files generated by all clients for a single service.
Which combination of utilities does this?

A. TKPROF and Trace Analyzer

B. Trace Analyzer and Tracsess

C. Trcsess and TKPROF

D. Autotrace and TKPROF

Correct Answer: C

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

Question 5

Which three statements are true about tuning dimensions and details of v$sys_time_model and DB time?

A. Systems in which CPU time is dominant need more tuning that those in which WAIT TIME is dominant.

B. When WAIT TIME is high, instance tuning may improve performance.

C. The proportion of WAIT TIME to CPU TIME always increases with increased system load.

D. DB Time accounts for all time used by background processes and user sessions.

E. Parse Time Elapsed accounts for successful soft and hard parse operations only.

F. Statspack cannot account for high CPU time when CPU TIME is a Top 10 event in DB time. When CPU time is high, SQL tuning may improve performance.

Correct Answer: B,D,F

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

Question 6

Which statement is true about DB time in V$$YS_TIME_MODEL?

A. DB time is organized as a simple list of statistics and any time period is attributable to only one statistic.

B. DB tine excludes the time spent waiting for a CPU in the operating system run queue.

C. DB time includes the time spent executing the RMAN backup and restore command.

D. DB time can be many times greater than the elapsed time since the database instance started.

Correct Answer: D

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

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

Latest Update

Useful Links

Contact Us