Online 1Z0-084 Practice Test

Question 1

Which of the following statements accurately describes the purpose and functionality of Automatic Workload Repository (AWR) in Oracle Database?

Options :

A : AWR is used for monitoring and diagnostics, capturing and maintaining performance-related data for analysis.

B : AWR provides automatic memory management for optimizing database performance.

C : AWR is a feature that allows you to track and analyze individual SQL statements within the database.

D : AWR is a background process that automates the management of storage space for database objects.

Answer: A

Question 2

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 3

Which statement about Undo and Redo Management is correct?

Options :

A : The UNDO_RETENTION parameter determines the minimum amount of time that undo data will be retained in the undo tablespace.

B :

The MAXTRANS parameter determines the maximum number of transactions that can be concurrently active on a given data block.

C : The UNDO_TABLESPACE parameter specifies the name of the default tablespace used for storing undo data.

D : The LOG_BUFFER parameter determines the size of the redo log buffer in memory.

Answer: A

Question 4

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 5

Which statement is true regarding the sizing and tuning of the shared pool and buffer cache in Oracle Database 19c?

Options :

A : The shared pool and buffer cache should always be sized to use as much memory as possible to improve performance.

B : The shared pool and buffer cache should always be sized conservatively to avoid excessive memory usage.

C : The shared pool and buffer cache should be sized based on the estimated workload and available memory.

D : The shared pool and buffer cache should only be tuned after performance issues occur.

Answer: C

EXPERTY DESIGNED 1Z0-084 PRACTICE TEST