Question 1

Which of the following is considered a best practice for performance management and tuning in Oracle Database 19c?

Options :

A : Regularly gather optimizer statistics

B : Increase the size of the shared pool size

C : Disable Automatic Memory Management

D : Use a larger block size for all tablespaces

Answer: A

Question 2

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 3

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

Options :

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

Question 4

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

Options :

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 5

Which statement regarding SQL plan baselines is true?

Options :

A : An accepted baseline becomes the only plan used for that SQL statement.

B : A fixed baseline cannot be changed or removed.

C : A SQL statement can have multiple plan baselines, only one of which can be accepted.

D : A plan baseline can only be created for a single SQL statement.

Answer: C

Confidently Practice Online with Free 1Z0-084 Exam Cram

Buying Options: