单选题

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.

正确答案

答案解析

略

相似试题

A user is running a long update batch file. Many tables are updated and all the statements are in one transaction. Before the process is finished， the user machine lost power. When the user calls you， what should you do as DBA？（）
单选题查看答案
Which statements are true regarding the USERS tablespace（）
多选题查看答案
View the Exhibit. Which statements are true regarding the USERS tablespace（）
多选题查看答案
You executed the following command to drop a user： DROP USER scott CASCADE； Which two statements regarding the above command are correct？（）
多选题查看答案
Given： If the user types the password aiko when prompted， what is the result？（）
单选题查看答案
View the Exhibit1， which shows the options that are selected to create the user SL_REP. Which two statements are true regarding this user（）
多选题查看答案
You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space. You can use Segment Advisor to （）
单选题查看答案
View the Exhibit.You executed the following command to perform a backup of the USERS tablespace： RMAN> BACKUP TABLESPACE USERS； Which three types of files are backed up？（）
多选题查看答案
View the Exhibit to observe the roles assigned to the SL_REP user. Which statement is true about theassignment of the SELECT_CATALOG_ROLE role to the SL_REP user（）
单选题查看答案
Examine the following steps performed on a database instance： 1. The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION. 2. The SKD user creates a table. 3. The SKD user grants the CREATE TABLE system privilege to the HR user. 4. The HR user creates a table. 5. The DBA revokes the CREATE TABLE system privilege from SKD. Which statement is true after step 5 isperformed（）
单选题查看答案

语音搜题

拍照搜题

打赏

Oracle认证

正确答案

答案解析