Question 1

Which of the following is a benefit of using SQL Plan Management (SPM)?

Options :

A : Prevents plan regression

B :

Improves query performance

C : Automatically tunes SQL statements

D : Manages index usage

Answer: A

Question 2

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 3

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

Question 4

Which of the following options can be used to improve SQL performance?

Options :

A : Creating an index on all columns used in WHERE and JOIN clauses

B : Increasing the size of the Oracle buffer cache

C : Using bind variables instead of literals

D : Enabling the FORCE MATCHING option in SQL plan management

Answer: C

Question 5

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

Free 1Z0-084 Mock Exam – Practice Online Confidently