单选题 You have included the following parameter settings in your SPFILE:// SGA_MAX_SIZE=8G SGA_TARGET=6G DB_CACHE_SIZE=2G SHARED_POOL_SIZE=1G LOG_BUFFER=64M DB_KEEP_CACHE_SIZE=960M Which statement is true if you modify the SGA_TARGET initialization parameter？（）
The SGA_TARGET initialization parameter cannot be set to a value greater than 8G
The DB_CACHE_SIZE initialization parameter cannot be set to a value less than 2G
The DB_CACHE_SIZE initialization parameter cannot be set to a value greater than 2G
The DB_KEEP_CACHE_SIZE initialization parameter cannot be set to a value greater than 960M
The DB_KEEP_CACHE_SIZE initialization parameter cannot be set to a value less than 960M
单选题 While setting up the thresholds for tablespace space usage metrics for one of your tablespaces， you define the critical threshold as 60% and warning threshold as 75%. What would be the result of this setting？（）
It would result in an error because the warning threshold cannot be more than the critical threshold.
The warning threshold is ignored and alerts would be generated when space usage exceeds the critical threshold.
The critical threshold is ignored and alerts would be generated when space usage exceeds the warning threshold.
Both threshold values are used and alerts are generated when space usage exceeds the respective threshold values.
单选题 You are using Recovery wizard for performing incomplete recovery. Which of the following object types is NOT available in the Perform Recovery ：Type screen？（）
单选题 From the V$SESSION_LONGOPS view， you find that some of the database users have long-running queries and are consuming a lot of CPU time. This causes problems for you when you try to log on as the system user and perform small maintenance tasks. You would like to ensure that users SYS and SYSTEM get priority over all other users. Which method would you use to achieve this objective？（）
create a plan directive in the SYS_GROUP
create the pending area for the consumer group
activate the provided SYSTEM_PLAN in Resource Manager
set the TIMED_STATISTICS parameter to TRUE in the parameter file
set the execution time limit for all users， except SYS and SYSTEM， in their profiles
多选题 You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area？ （）
control file autobackups
copies of all the parameter files
trace file generated using BACKUP CONTROLFILE TO TRACE
单选题 You create a table in your database that contains 50，000 rows approximately. The queries performed on the table are complex and performed on the table frequently. Which advisor helps you achieve the best performance of database for queries by recommending the appropriate indexes？（）
SQL Access Advisor
SQL Tuning Advisor
单选题 Why would you use the following FLASHBACK TABLE command？（） FLASHBACK TABLE emp TO TIMESTAMP （’11：45’.’hh12：mi’）；
to undo the changes made to the EMP table since the specified time
to restore the EMP table that was wrongly dropped from the database
to view the transactions that have modified the EMP table since the specified time
to view the changes made to the EMP table for one or more rows since the specified time
多选题 Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel-based recovery？ （）
You find that one of the redo log members in each redo log group is lost.
You find that a data file that belongs to the USERS tablespace is damaged.
You find that a data file that belongs to the SYSTEM tablespace is damaged.
You find that the current redo log group is damaged and is not available for recovery.
You realized while performing a recovery that an archived redo log file needed for recovery is lost.
多选题 You have created a resource plan， PROD_DB_PLAN， with the following consumer groups with the respective plan directives： Consumer group SALESwith CPU_P1as 60 and DEGREE_OF_PARALLELISMas 4. Consumer group MARKETwith CPU_P1as 20. Consumer group DEVwith CPU_P1as 20. Consumer groupOTHERSwith CPU_P1as 0 and CPU_P2as 100. Which two statements are correct in this scenario？（）
The maximum degree of parallelism for the members of the consumer groups is 4.
The CPU allocation will always be equal for the consumer groups MARKET and DEV.
The OTHERS consumer group would get 100% of the CPU if there are unused level 1 CPU resources.
The SALES and MARKET consumer groups would get 100% of the CPU if there are unused level 2 CPU resources.
The maximum degree of parallelism for the members of the consumer group SALES is 4 with no restriction for the remaining groups.
单选题 You are maintaining your database in Oracle10g. You are performing the backup by using the BACKUP AS BACKUPSET command at the RMAN prompt. Which file cannot be backed up by using the BACKUP AS BACKUPSET command？（）
Current control file
Server parameter file （spfile）