单项选择题
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 -
单项选择题
WhichoftheseappropriatelydescribestheresultsofamanualSQLTuningAdvisortask?()
A. A list of SQL statements and recommendations for tuning
B. A list of SQL statements that have been tuned by the Advisor,with before and after metrics
C. Graphs showing the actual performance improvement made by the Advisor after it implemented the recommended changes
D. All of the above
