Free Oracle 1Z0-084 Exam Questions

Become Oracle Certified with updated 1Z0-084 exam questions and correct answers

Page: 1 / 76

Total 378 Questions | Updated On: Jun 16, 2026

Add To Cart

Question 1

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

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 statement regarding Automatic Workload Repository (AWR) is correct?

A : AWR data can only be accessed using the Oracle Enterprise Manager.

B : AWR automatically collects and stores performance data at regular intervals.

C : AWR data is stored in the system tablespace by default.

D : AWR data is kept in memory and is not written to disk.

Answer: B

Question 3

Which of the following statements accurately describes the Automatic Workload Repository (AWR) feature in Oracle Database 19c for performance management and tuning?

A : AWR provides historical performance data that can be used for diagnosing performance issues and identifying trends.

B : AWR captures and stores all SQL statements executed in the database along with their execution plans.

C : AWR automatically generates recommendations for performance tuning based on the collected performance data.

D : AWR provides real-time monitoring of database performance and generates alerts for potential issues.

Answer: A

Question 4

Which statement about Undo and Redo Management is correct?

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 5

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

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

Page: 1 / 76

Total 378 Questions | Updated On: Jun 16, 2026

Add To Cart