單項(xiàng)選擇題

You can control instance recover performance by setting parameters to define targets for（）

A.The size of the redo buffer in SGA.
B.The instance that will perform recovery in Real Application Cluster database.
C.The number of blocks to be read during instance recovery, or the time needed to complete instance recovery.
D.The number of passes through the redo logs made by the recovery process to identify blocks needing recovery.

你可能感興趣的試題

單項(xiàng)選擇題

The EMPLOYEES table has six indexes and DML operations are slow. Which command begins monitoring the EMPLOYEE_IDX_FK index to determine whether it has been used by an execution plan？（）

A.ALTER TABLE employees monitor index employee_idx_fk;
B.ALTER INDEX employee_idx_fk monitoring on;
C.ALTER TABLE employees monitor all indexes;
D.ALTER INDEX employee_idx_fk monitoring usage;

多項(xiàng)選擇題

Using a bitmap structure to manage database object space has several benefits over using freelist structures. Which three are benefits of managing space using automatic-segment-space managed objects？（）

A.It readily responds to dynamic changes for concurrent access.
B.It improves performance and space utilization in a multiple-instance environment.
C.It requires fewer space related options then freelist managed structures.
D.It improves performance for SYSTEM tablespaces where a high degree of concurrency is required.

You can control instance recover performance by setting parameters to define targets for（）

你可能感興趣的試題

The EMPLOYEES table has six indexes and DML operations are slow. Which command begins monitoring the EMPLOYEE_IDX_FK index to determine whether it has been used by an execution plan？（）

Using a bitmap structure to manage database object space has several benefits over using freelist structures. Which three are benefits of managing space using automatic-segment-space managed objects？（）

Using a bitmap structure to manage database object space has several benefits over using freelist structures. Which three are benefits of managing space using automatic-segment-space managed objects？（）