Online 1Z0-084 Practice Test

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 tool can be used to monitor and troubleshoot performance issues in Oracle Database 19c?

Options :

A : Oracle Enterprise Manager

B : SQL Developer

C : Oracle SQL Monitor

D : Oracle Exadata

Answer: A

Question 3

Which statement(s) correctly define statistics in Oracle Database 19c?

Options :

A : Statistics are metadata about the objects in the database and can be used to help optimize SQL execution plans.

B : Statistics are a set of customized queries that can be run to troubleshoot performance issues.

C :

Statistics are used exclusively by DBAs to monitor system metrics and resource consumption.

D : Statistics are a subset of the various types of indexes that can be created on tables.

Answer: A

Question 4

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 5

Which of the following options allows you to manage and control the execution plans used by the Oracle database optimizer?

Options :

A : Automatic Workload Repository (AWR)

B : SQL Performance Analyzer (SPA)

C : SQL Plan Management (SPM)

D :

Automatic Database Diagnostic Monitor (ADDM)

Answer: C

EXPERTY DESIGNED 1Z0-084 PRACTICE TEST