单项选择题
Which statement most accurately describes the implementation of a SQL Access Advisor recommendation？（）
A. SQL Access Advisor recommendations are automatically implemented.
B. Individual SQL Access Advisor recommendations can be scheduled for implementation.
C. All SQL Access Advisor recommendations for a specific task must be implemented at the same time.
D. SQL Access Advisor recommendations are automatically scheduled for implementation during the maintenance window.
E. None of the above.
相关考题
-
单项选择题
The DB_BLOCK_CHECKING initialization parameter is set to OFF.Which block checking would be performed?（）
A. The Oracle database will perform block checking for the index blocks only
B. The Oracle database will not perform block checking for any of the data blocks
C. The Oracle database will perform block checking for the default permanent tablespace only
D. The Oracle database will perform block checking for the data blocks in all user tablespaces
E. The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only -
多项选择题
Which two statements are true regarding an Automatic Storage Management (ASM) instance?（） (Choose two.)
A. As ASM instance mounts an ASM control file
B. An ASM instance uses the ASMB process for rebalancing of disks within a disk group
C. Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitly
D. An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started -
单项选择题
WhichofthefollowingisapotentialperformancetuningrecommendationfromtheSQLAccessAdvisor？（）
A. Create new indexes.
B. Modify existing indexes.
C. Implement partitioning on a nonpartitioned table.
D. Create materialized views.
E. All of the above
