多項選擇題

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.

你可能感興趣的試題

單項選擇題

You are creating the simple resource plan using the DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN procedure. Which resource allocation policy will be used for the resource plan？（）

A. RATIO
B. EMPHASIS
C. ACTIVE_SESS_POOL_MTH
D. RESOURCE_DEGREE_LIMIT_ABSOLUTE

單項選擇題

You issued the following block of code：
SQL>BEGIN
DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP（
’PROG_ROLE’， ’DEVELOPERS’ ，F(xiàn)ALSE）；
END；
SQL>/
Which option is NOT a result of executing the above code？（）

A. The switch privilege is granted to the PROG_ROLE role.
B. The users granted the role PROG_ROLE will be able to switch to the DEVELOPERS group.
C. The users cannot grant the switch privilege to other users.
D. The above code will not be executed successfully because the GRANT_SWITCH_CONSUMER_GROUP procedure is an invalid procedure in Oracle10g.

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美 国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

你可能感興趣的試題

You are creating the simple resource plan using the DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN procedure. Which resource allocation policy will be used for the resource plan？（）

You issued the following block of code： SQL>BEGIN DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP（ ’PROG_ROLE’， ’DEVELOPERS’ ，F(xiàn)ALSE）； END； SQL>/ Which option is NOT a result of executing the above code？（）

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

You are creating the simple resource plan using the DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN procedure. Which resource allocation policy will be used for the resource plan？（）

You issued the following block of code：
SQL>BEGIN
DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP（
’PROG_ROLE’， ’DEVELOPERS’ ，F(xiàn)ALSE）；
END；
SQL>/
Which option is NOT a result of executing the above code？（）