试题详情
- 多项选择题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,D
关注下方微信公众号,在线模考后查看
热门试题
- ORACLE数据库启动后,有哪五个必要
- You are granted the
- While running&
- Given: Which s
- Given: Whichstateme
- Given:
- Which four are attri
- You are wo
- The database&e
- Evaluatethefollowing
- Which hardware stora
- In your
- Which two statements
- Your boss
- A databaseQ
- 在Oracle中,当FETCH语句从游标
- In which
- ()是包含Oracle数据库中所有数据的
- 假设需要删除某个角色test_role,
- On which