试题详情
- 单项选择题 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（）
A、The command fails because SCOTT still has privileges.
B、The command succeeds and privileges are revoked from JIM.
C、The command fails because HR cannot revoke the privileges from JIM.
D、The command succeeds and only HR has the privilege to perform the SELECT， INSERT， and UPDATEoperations on the EMP table.
- C
关注下方微信公众号，在线模考后查看
热门试题
- Which is an iSQL*Plu
- You executed&e
- You are
- You plan
- Examine the details
- Assume your&en
- You want
- You realize that the
- While deployin
- Which DBMS_SCHEDULER
- Where can̳
- Which statemen
- You are m
- You have
- Which are DML statem
- You have installed
- 使用（），可以将某个SQL语句的执行依赖
- 以下（）进程，可以用于同步数据文件、日志
- Which technolo
- Given： Which t