Examine the following steps performed on a database instance:

Examine the following steps performed on a database instance:1.The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION2.The SKD user creates a table3.The SKD user grants the CREATE TABLE system privilege to the HR user4.The HR user creates a table5.The DBA revokes the CREATE TABLE system privilege from SKDWhich statement is true after step 5 is performed?

Question:

Examine the following steps performed on a database instance:

Options:

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

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

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

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

Correct Answer

The Correct Answer for this Question is

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