單項選擇題

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.

你可能感興趣的試題

單項選擇題

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

A. by using the DBMS_SESSION package
B. by granting the DBA role
C. by using the DBMS_RESOURCE_MANAGER package
D. by using the DBMS_RESOURCE_MANAGER_PRIVS package

單項選擇題

You issue the following code：
EXEC DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP
（’SCOTT’ ’GRP1’， TRUE）；
What will be the result of executing the above code？（）

A. The switch privilege will be granted to the user， Scott， for changing the consumer group to GRP1.
B. The switch privilege will be granted to the user， Scott， for changing the consumer group from GRP1 to any other group.
C. The code will not execute successfully because there is no GRANT_SWITCH_CONSUMER_GROUP procedure in the DBMS_RESOURCE_MANAGER_PRIVS package.
D.The code will execute successfully but no privilege will be granted to the user， Scott.

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

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

你可能感興趣的試題

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

You issue the following code： EXEC DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP （’SCOTT’ ’GRP1’， TRUE）； What will be the result of executing the above code？（）

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

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

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

You issue the following code：
EXEC DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP
（’SCOTT’ ’GRP1’， TRUE）；
What will be the result of executing the above code？（）