[单选]
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

In the instance of the PROD database， the checkpoint （CKPT） process runs after every minute. A database user updates the rows of the ORDERS table. Because of the configuration， the CKPT process gets initiated before the user commits the transaction. What would happen to the modified blocks when the CKPT process is started？（） The modified blocks would be written to the data files.。 The modified blocks would be written to the temp files.。 The modified blocks would be written to the control file.。 The modified blocks would be written to the redo log files.。 The modified blocks would be written to the archived redo log files.。 The modified blocks would be retained in the database buffer cache.。下列选项不属于《水利建设市场主体信用评价暂行办法》目的的是（）。推进水利行业信用体系建设。规范水利建设市场主体行为。加强行业自律管理。促进水利事业又好又快发展。 Which two statements are true regarding Health Monitor checks in Oracle Database 11g？（） Health Monitor checks can be used to scan the contents of the redo log and archive logs for accessibility and corruption.。 Health Monitor checks can be used to verify the integrity of database files and report failures if these files are inaccessible，corrupt or inconsistent.。 Health Monitor checks can be used to verify the contents of dictionary entries for each dictionary object and fix it automatically.。 Health Monitor checks are always initiated manually when there is some critical error.。 Which two are attributes of iSQL*Plus? （） /SQL*Plus commands cannot be abbreviated.。 /SQL*Plus commands are accessed from a browser.。 /SQL*Plus commands are used to manipulate data in tables.。 /SQL*Plus commands manipulate table definitions in the database.。 /SQL*Plus is the Oracle proprietary interface for executing SQL statements.。软组织化脓性感染，下列哪一种有接触性传染，应隔离（）疖。痈。急性蜂窝织炎。丹毒。急性淋巴管炎和淋巴结炎。

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

参考答案：

● 参考解析

本题暂无解析

当前位置：1z0-043题库

相关题目: