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 23, 2025

Add To Cart

Question 1

Which tool can be used to monitor and troubleshoot performance issues in Oracle Database 19c?

A : Oracle Enterprise Manager

B : SQL Developer

C : Oracle SQL Monitor

D : Oracle Exadata

Answer: A

Question 2

Which feature of Oracle Database can be used to capture and analyze database activity, providing insights into the performance of SQL statements and database objects?

A : Oracle Enterprise Manager

B : Automatic Database Diagnostic Monitor (ADDM)

C : SQL Tuning Advisor

D : Real-Time Database Operations (Real-Time SQL Monitoring)

Answer: B

Question 3

Which feature is used to improve the performance of SQL queries by caching the result set of the query in memory?

A : Query Result Cache

B : Database Buffer Cache

C : Shared Pool

D : In-Memory Column Store

Answer: A

Question 4

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 5

Which parameter controls the minimum size in bytes of a single Memory Block allocated in SGA for SQL execution and can have a value between 4 MB and 16 MB?

A : DB_CACHE_SIZE

B : SHARED_POOL_SIZE

C : LARGE_POOL_SIZE

D : DB_16K_CACHE_SIZE

Answer: D

Page: 1 / 76

Total 378 Questions | Updated On: Jun 23, 2025

Add To Cart