可学答题网 > 问答 > 1Z0-052题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

Examine the commands e


Examine the commands executed in the following sequence:  1:SQL> CREATE ROLE mgrrole;  2:SQL> GRANT create user,select any table,connect,resource TO mgrrole;  3:SQL> GRANT select,update ON sh.sales TO mgrrole;  4:SQL> CREATE ROLE ceo IDENTIFIED BY boss;  5:SQL> GRANT mgrrole,drop any table,create any directory TO ceo;  6:SQL> GRANT ceo TO mgrrole;  Which statement is true about the above commands()

  • AThe commands execute successfully.
  • BCommand 6 produces an error because of circular role grant.
  • CCommand 5 produces an error because a role cannot be granted to another role.
  • DCommand 3 produces an error because the MGRROLE role already contains system privileges.
  • EThe table created by HR remains and HR still has the CREATE TABLE system privilege.
  • FThe table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
参考答案
参考解析:
分类:1Z0-052题库
相关推荐

1、Examine the command: &

Examine the command:  ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;  What...

2、Examine the following 

Examine the following command:  ALTER DISKGROUP data MOUNT FORCE;  In which scenario can&ensp...

3、Examine the following 

Examine the following parameter settings from an initialization (init.ora) file:  DB_CREATE_FILE_DEST ...

4、Examine the following 

Examine the following command that is used to duplicate a database on the same host: &ens...

5、Examine the following 

Examine the following RMAN command:  BACKUP DATABASE TAG TESTDB KEEP UNTIL ’SYSDATE+1’ ...

6、Examine the following 

Examine the following commands executed in your database: SQL> ALTER SESSION RECYCLEBIN=ON; Session&ens...