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

The user HR owns 


The user HR owns the EMP table. The user HR grants privileges to the user SCOTT by using this command:  SQL> GRANT SELECT,INSERT,UPDATE ON emp TO scott WITH GRANT OPTION; The user SCOTT executes this command to grant privileges to the user JIM: SQL> GRANT SELECT,INSERT,UPDATE ON hr.emp TO jim;  Now, the user HR decides to revoke privileges from JIM using this command: SQL> REVOKE SELECT,INSERT,UPDATE ON emp FROM jim; Which statement is true after HR issues the REVOKE command()

  • AThe command fails because SCOTT still has privileges.
  • BThe command succeeds and privileges are revoked from JIM.
  • CThe command fails because HR cannot revoke the privileges from JIM.
  • DThe command succeeds and only HR has the privilege to perform the SELECT, INSERT, and UPDATEoperations on the EMP table.
参考答案
参考解析:
分类:1Z0-052题库
相关推荐

1、If the user types&ensp

If the user types the password aiko when prompted, what is the result?()Apassword:gotBpassword:got&...

2、The database users are

The database users are connecting to the PROD database from different applications, thereby degradi...

3、All the database users

All the database users are presently connected to the database instance and working. The HR&ens...

4、The HR user creates&en

The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on&ensp...

5、The user HR receives&e

The user HR receives the following error while inserting data into the TTK table:ERROR at&ensp...

6、The HR user creates&en

The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on&ensp...