Question 1

What is the purpose of SQL Tuning Advisor in Automatic Workload Repository (AWR)?

Options :

A : It provides recommendations for creating new indexes to improve query performance.

B : It analyzes high-load SQL and provides recommendations to improve their performance.

C : It recommends configuration changes to the database to improve overall performance.

D : It provides recommendations for configuring Automatic Memory Management (AMM).

Answer: B

Question 2

Which of the following statements is true about the optimizer index skip scan feature in Oracle Database 19c?

Options :

A : The optimizer index skip scan feature allows the optimizer to skip over one or more leading columns of an index in order to improve query performance.

B : The optimizer index skip scan feature allows the optimizer to skip over only the first column of an index in order to improve query performance.

C : The optimizer index skip scan feature allows the optimizer to scan an index in reverse order, starting from the last column instead of the first column.

D : The optimizer index skip scan feature is not available in Oracle Database 19c.

Answer: A

Question 3

What is the purpose of the Automatic Workload Repository (AWR) in Oracle Database 19c performance management and tuning?

Options :

A : To monitor the performance of the database, store a history of system activity, and identify potential performance issues for further analysis

B : To perform backups and recovery of the database and ensure data consistency

C : To manage users, roles, and privileges for accessing the database

D : To automate routine administrative tasks, such as space and memory management

Answer: A

Question 4

Which of the following can be a cause of excessive contention for a particular resource in an Oracle Database?

Options :

A : A large number of concurrent transactions attempting to access the resource

B : Inadequate system resources such as CPU, memory, or I/O bandwidth

C : A high volume of network traffic within the database

D : Insufficient database storage space

Answer: A

Question 5

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