OCP 1Z0 052 156

156. 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 table created by SKD is not accessible and SKD cannot create new tables. 
B.The tables created by SKD and HR remain, but both cannot create new tables. 
C.The table created by HR remains and HR still has the CREATE TABLE system privilege. 
D.The  table  created by HR  remains  and HR  can  grant  the CREATE TABLE  system  privilege  to other 
users. 
Answer: C

The REVOKE statement can revoke only privileges and roles that were previously granteddirectly with a GRANT statement. You cannot use this statement to revoke:

• Privileges or roles not granted to the revokee

• Roles or object privileges granted through the operating system

• Privileges or roles granted to the revokee through roles