1Z0-084 Practice Online

Question 1

Which approach is recommended for tuning SQL statements that perform poorly?

A :

Running the SQL Access Advisor

B : Running the SQL Tuning Advisor

C : Running the SQL Performance Analyzer

D : Running the SQL Plan Management

Answer: B

Question 2

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

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 3

Which initialization parameter can be used to control the size of the buffer cache in Oracle Database?

A : PGA_AGGREGATE_TARGET

B :

SHARED_POOL_SIZE

C : DB_CACHE_SIZE

D : SGA_TARGET

Answer: C

Question 4

Which Real Application Testing feature enables the creation of a real-time test environment that closely mimics the actual production workload?

A : SQL Performance Analyzer

B : Database Replay

C : Workload Capture and Replay

D : SQL Tuning Advisor

Answer: B

Question 5

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

A : Automatic Memory Management

B : Manual Memory Management

C : Automatic Storage Management

D : Automatic Undo Management

Answer: A

Name:	Oracle Database 19c: Performance Management and Tuning
Exam Code:	1Z0-084
Certification:	Oracle Database
Vendor:	Oracle
Total Questions:	378
Last Updated:	Apr 24, 2024