Question 1

You must configure and enable Database Smart Flash Cache for a database. You configure these flash devices: Examine these parameter settings:What must be configured so that the database uses these devices for the Database Smart Flash Cache?

Options :

A : Set DB_FLASH_CACHE_SIZE to 192G and MEMORY_TARGET to 256G.

B : Set DB_FLASH_CACHE_SIZE parameter to 192G.

C : Disable Automatic Memory Management and set SGA_TARGET to 256G.

D : Set DB_FLASH_CACHE_SIZE to 256G and change device /dev/sdk to 128G.

E : Set DB_FLASH_CACHE_SIZE parameter to 128G, 64G.

Answer: E

Question 2

Which initialization parameter can be used to control the size of the buffer cache in Oracle Database?

Options :

A : PGA_AGGREGATE_TARGET

B : SHARED_POOL_SIZE

C : DB_CACHE_SIZE

D : SGA_TARGET

Answer: C

Question 3

Which statement about Undo and Redo Management is correct?

Options :

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 4

Which statement regarding SQL Plan Management (SPM) is true?

Options :

A : SPM automatically creates and maintains execution plans for SQL statements.

B : SPM requires the OPTIMIZER_FEATURES_ENABLE initialization parameter to be set to the current Oracle Database release level.

C : SPM captures execution plans and uses them to compare with new plans generated for the same SQL statement.

D : SPM automatically updates execution plans based on changes in the database environment.

Answer: C

Question 5

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