多項選擇題

Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens？（）

A. log writer
B. archival
C. process monitor
D. system monitor
E. change tracking writer
F. database writer

你可能感興趣的試題

You have a read-only tablespace on read-only media. You want to perform a media recovery on the existing data files， but using a backup control file. The backup control file indicates that the status of the read-only tablespace was read/write when the control file was backed up. What should you consider？（）

A. take data files from the read-only tablespace offline before performing a recovery
B. recovery using backup control file is not possible， so restore all the files from the last full database backup， and then open the database
C. drop the read-only tablespace and re-create the tablespace after recovery
D. perform a recovery； status of the tablespace in control file will be changed automatically

單項選擇題

You want to create a consumer group， GROUP1， and you execute the following command in the command-line interface：
SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP （CONSUMER_GROUP =>’group1’，
COMMENT => ’New Group’）；
This command errors out displaying the following message：
ERROR at line 1：
ORA-29371： pending area is not active
ORA-06512： at "SYS.DBMS_RMIN"， line 115
ORA-06512： at "SYS.DBMS_RESOURCE_MANAGER"， line 108
ORA-06512： at line 1
What action would you take to overcome this error？（）

A. activate the Pending Area before creating the consumer group
B. create the Pending Area before creating the consumer group
C. increase the size of the database buffer cache to accommodate the Pending Area
D. increase the size of the shared pool to accommodate the Pending Area
E. increase the size of the large pool to accommodate the Pending Area

无码高清视频|成人自拍视频|欧美成人午夜无码A片秀色直播|草美女视频网站|美女被操网站在线观看

Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens？（）

你可能感興趣的試題

Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens？（）