Which statement is true after step 5 is performed?

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 is performed?

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 is performed?

A.
The tables created by SKD and HR remain, but both cannot create new tables

B.
The table created by HR remains and HR still has the CREATE TABLE system privilege

C.
The table created by SKD is not accessible and SKD cannot create new tables

D.
The table created by HR remains and HR can grant the CREATE TABLE system
privilege to other users



Leave a Reply 1

Your email address will not be published. Required fields are marked *


chu

chu

The answer is:
B.
The table created by HR remains and HR still has the CREATE TABLE system privilege