Question 1

Which of the following is considered a best practice for performance management and tuning in Oracle Database 19c?

Options :

A : Regularly gather optimizer statistics

B : Increase the size of the shared pool size

C : Disable Automatic Memory Management

D : Use a larger block size for all tablespaces

Answer: A

Question 2

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 3

Which of the following is a benefit of using Incremental Backup strategy for Performance Management and Tuning?

Options :

A : Reduced backup time

B :

Higher data protection

C :

Reduced storage space requirements

D : Faster recovery time

Answer: A

Question 4

Which of the following features can be used to manage Oracle Database memory?

Options :

A : Automatic Memory Management

B : Manual Memory Management

C : Automatic Storage Management

D : Automatic Undo Management

Answer: A

Question 5

Which of the following describes the benefit of using Resource Manager to manage resources in Oracle Database 19c?

Options :

A : Resource Manager enables the classification of users, making tasks such as user authentication and role management more manageable.

B : Resource Manager enables the prioritization of database server hardware, ensuring that more important tasks are given priority access to computing resources while lesser tasks are relegated until the primary request is done.

C : Resource Manager enables dynamic switching between different workloads on the database, ensuring that the server always has the resources to handle traffic spikes.

D : Resource Manager enables the definition of shared pool sizes and enables automatic distribution of resources between databases based on the workload and prior resource usage.

Answer: B

Free 1Z0-084 Mock Exam – Practice Online Confidently

Buying Options: