多项选择题
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.
单项选择题 YouarecreatingthesimpleresourceplanusingtheDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLANprocedure.Whichresourceallocationpolicywillbeusedfortheresourceplan?()
单项选择题 You issued the following block of code: SQL>BEGIN DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP( ’PROG_ROLE’, ’DEVELOPERS’ ,FALSE); END; SQL>/ Which option is NOT a result of executing the above code?()
单项选择题 You want to enable the user, Scott, to change to the GRP1 consumer group by issuing the following code: SQL> EXEC DBMS_SESSION.SWITCH_CURRENT_CONSUMER_GROUP (’SCOTT’, ’GRP1’, FALSE); How will you grant the switch privilege to the user, Scott?()