题目内容

You set the undo pool resource plan directive for the consumer group named DSS_USERS that is assigned to the DAY_SHIFT plan. The database users, SCOTT and BLAKE, belong to the DSS_USERS resource group. The user, SCOTT, initiates a database session and executes a batch operation that inserts millions of rows into the HISTORY table. Which two options are true if the total undo space allocated to the DSS_USERS group exceeds the value specified in the undo pool resource plan directive?()

A. The batch operation started by the user, SCOTT, terminates with an error.
B. The batch operation started by the user, SCOTT, hangs and you are required to increase the undo pool resource plan directive.
C. The batch operation started by the user, SCOTT, runs uninterrupted because the database uses the SYSTEM tablespace for the undo operation.
D. The user, BLAKE, cannot start a transaction that uses any DML operations until you increase the value of the undo pool resource plan directive.
E. The user BLAKE can start a transaction that uses any DML operations after the batch operation started by the user, SCOTT, terminates with an error.

查看答案
更多问题

断连接方式:

简述诚信缺失的原因?

在可能发生人身伤害、设备或设施损坏和环境破坏的场合,事先采取措施,防止事故的发生。这体现了()的运用。

A. 预防原理
B. 本质安全化原则
C. 安全第一原则
D. 系统原理

说出EPR0M的含义?

答案查题题库