You noticed that large memory allocations for the Oracle backup and restore operations are causing a performance overhead on the shared pool. Which memory structure would you configure to avoid this performance overhead？（）

FromtheV$SESSION_LONGOPSview，youfindthatsomeofthedataba...

单项选择题From the V$SESSION_LONGOPS view， you find that some of the database users have long-running queries that consume a lot of CPU time. This causes performance problems for other users in the database， who have much shorter queries. You would like to make sure that the users with large queries do not use all the CPU time， but you still do not want to terminate them with an error message. Which method would you follow to achieve this？（）

Youlosttheindextablespaceinyourdatabase.Youdecidedtore-...

多项选择题You lost the index tablespace in your database. You decided to re-create the index tablespace and the indexes in the tablespace. What methods can you use to re-create the indexes？（）

You want an ASM instance to manage the files of your da...

单项选择题

You want an ASM instance to manage the files of your database. To achieve this objective， you specify the following parameters in the parameter file of the database： INSTANCE_TYPE = RDBMS DB_NAME = PROD 
LARGE_POOL_SIZE = 8MB DB_BLOCK_SIZE = 4K 
LOG_ARCHIVE_DEST = +dgroupA 
LOG_ARCHIVE_FORMAT = "$ORACLE_SID_%s_%t.%t" 
DB_CREATE_FILE_DEST = +dgroupA 
COMPATIBLE = 10.1.0.2.0 
CONTROL_FILES = +dgroupA 
Which parameter would be ignored while starting up the instance for the database PROD？（）