Oracle Database 19c Performance and Tuning Management (1Z0-084) Free Practice Test

Question 1

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

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

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

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

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

E. 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.

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

Correct Answer: A,B,E

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

Question 2

Which two actions can cause invalidation or loss of one or more results in the SQL Query Result Cache?

A. Decreasing the value set for RESULT_CACHE_REMOTE_EXPIRATION.

B. A request was made by the RCBG background of a non-RAC database.

C. result_cache_max_size is set dynamically to 0.

D. One or more results were aged out of the result cache.

E. A request was made by the RCBG background process in a physical standby database that is opened read only and whose primary has a result cache.

Correct Answer: C,D

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

Question 3

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 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. Both the RECYCLE and KEEP buffer caches should always have a very high cache hit ratio.

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

Correct Answer: C,E

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

Question 4

Which procedure gathers statistics that are always used in the generation of any execution plan?

A. DBMS_STATS.GATHER_SYSTEM_STATS

B. DBMS_STATS.GATHER_FIXED_ OBJECTS_STATS

C. DBMS_STATS.GATHER_DICTIONARY_STATS

D. DBMS_STATS.GATHER_DATABASE_STATS

Correct Answer: D

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

Question 5

Which two Oracle Database features use database services?

A. Database Resource Manager

B. Oracle Automatic Reoptimization

C. Oracle Scheduler

D. Oracle SQL Performance Management

E. Oracle SQL Tuning Advisor

Correct Answer: A,C

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

Question 6

You want to reduce the amount of db file scattered read that is generated in the database. You execute the SQL Tuning Advisor against the relevant workload. Which two can be part of the expected result?

A. recommendations regarding the creation of materialized views

B. recommendations regarding the creation of additional indexes

C. recommendations regarding partitioning the tables

D. recommendations regarding rewriting the SQL statements

E. recommendations regarding the creation of SQL Patches

Correct Answer: B,D

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

Welcome to TestSimulate

Oracle Database 19c Performance and Tuning Management (1Z0-084) Free Practice Test