多项选择题

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

相关考题

Youhavearead-onlytablespaceonread-onlymedia.Youwanttope...

单项选择题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 ex...

单项选择题

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

YouneedtocreateaschedulethatwillrunajobonthesecondFrida...

单项选择题You need to create a schedule that will run a job on the second Friday of each month. What should the repeat interval of the schedule be set to？（）

A. FREQ = MONTHLY； BYDAY = 2FRI；
B. FREQ = MONTHLY； BYDAY = FRI（2）；
C. FREQ = MONTHLY； BYDAY = FRI2；
D. FREQ = MONTHLY； BYDAY = -2FRI；

1z0-043

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？（）