多项选择题
You are managing an Oracle Database 11g database with the ASM storage. The database is having big file tablespaces. You want files to open faster and less memory to be used in the shared pool to manage the extent maps.
What configuration would you effect to achieve your objective？（）
A. Set the ASM compatibility attribute for the ASM disk group to 11.1.0.
B. Set the RDBMS compatibility attribute for the ASM disk group to 11.1.0.
C. Set the COMPATIBLE initialization parameter for the ASM instance to 11.1.0.
D. Set the COMPATIBLE initialization parameter for the database instance to 11.1.0.
相关考题
-
单项选择题
You are tuning RMAN to optimize performance. You want tape I/O to be asynchronous when you perform tape backups.Which action should you take?（）
A. Set the BACKUP_TAPE_IO_SLAVES parameter to FALSE
B. Set the BACKUP_TAPE_IO_SLAVES parameter to TRUE
C. Use compression when performing tape backups
D. Configure multiple SBT channels
-
多项选择题
When executing a SQL workload，you choose to generate execution plans only， without collecting execution statistics. Which two statements describe the implications of this？（）
A. It produces less accurate results of the comparison analysis.
B. It automatically calls the SQL Tuning Advisor for recommendations.
C. It shortens the time of execution and reduces the impact on system resources.
D. Only the changes in the execution plan，and not performance regression，are detected. -
多项选择题
You execute the following Recovery Manager （RMAN） commands in he following order： BACKUP VALIDATE DATABAE RECOVER CORRUPTION LIST； Which two tasks are performed by these commands？（）
A. Repair the corrupted blocks. If any. In the backup created
B. Populate VSCOPV_CORRUPTION with names of files that have corrupted blocks
C. Back up the database after checking whether array of the files have corrupted blocks
D. Discover any corrupt blocks that are viewable with the VSDATABASE_BI-OCK_CORBUPTION view
E. Repair all corrupted blocks that have been logged in the VSDATABASE_BLOCK_ CORRUPTION
