Question 1

Which parameter controls the minimum size in bytes of a single Memory Block allocated in SGA for SQL execution and can have a value between 4 MB and 16 MB?

Options :

A : DB_CACHE_SIZE

B : SHARED_POOL_SIZE

C : LARGE_POOL_SIZE

D : DB_16K_CACHE_SIZE

Answer: D

Question 2

What is the purpose of an index in a database?

Options :

A :

To store the data in a table

B : To provide a way to access data quickly

C : To enforce data integrity constraints

D : To perform complex calculations on data

Answer: B

Question 3

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

Options :

A :

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.

B :

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

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

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

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

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

Answer: A,D,F

Question 4

Which of the following is the most efficient method to improve SQL performance?

Options :

A : Optimizing the table schema

B : Increasing the database buffer cache size

C : Enabling query result caching

D : Running the SQL Access Advisor

Answer: A

Question 5

Which method should be used to diagnose and analyze the performance of an Oracle Database using the Automatic Database Diagnostic Monitor (ADDM)?

Options :

A : Query the V$ACTIVE_SESSION_HISTORY view

B : Query the V$SQL_MONITOR view

C : Use the SQL Tuning Advisor

D : Use the SQL Performance Analyzer

Answer: B

Free 1Z0-084 Mock Exam – Practice Online Confidently

Buying Options: