Question 1

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

Question 2

Which of the following best describes the purpose of the buffer cache in Oracle Database?

Options :

A : To store copies of data blocks read from disk, reducing disk IO

B : To store the SQL statements executed by the database, optimizing query performance

C : To store copies of frequently accessed tables and indexes, improving response time

D : To store metadata about the database objects, facilitating efficient data access

Answer: A

Question 3

Which of the following options allows you to manage and control the execution plans used by the Oracle database optimizer?

Options :

A : Automatic Workload Repository (AWR)

B : SQL Performance Analyzer (SPA)

C : SQL Plan Management (SPM)

D :

Automatic Database Diagnostic Monitor (ADDM)

Answer: C

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

Options :

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

Confidently Practice Online with Free 1Z0-084 Exam Cram

Buying Options: