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: May 11, 2026

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

In Oracle Database 19c, which of the following is true about statistics gathering?

A : Statistics can be gathered automatically only for tables and indexes.

B : Automatic statistics gathering and the use of dynamic sampling can only be performed for queries that include at least one join.

C : If the database is operating in manual statistics mode, statistics can only be gathered by executing the DBMS_STATS.GATHER_DATABASE_STATS procedure.

D : Statistics gathered on partitioned tables only reflect the statistics for the entire table and do not include statistics for individual partitions.

Answer: B

Question 4

Which of the following is the best practice when creating indexes in Oracle Database?

A : Create indexes on all columns of a table.

B : Create indexes on frequently queried columns.

C : Create indexes on columns with high cardinality.

D : Create indexes on all columns used in join conditions.

Answer: B

Question 5

What is the purpose of the ASM Fast Mirror Resync (FMR) feature?

A : Rolling out new Oracle Database 19c patches with zero-downtime

B : Rapidly resyncing changed extents to a new disk after a disk failure

C : Dynamically reconfiguring ASM disks online without needing to take the disk group offline

D : Accelerating the rebalancing process during disk group rebalancing

Answer: B

Page: 1 / 76

Total 378 Questions | Updated On: May 11, 2026

Add To Cart