Oracle
1Z0-052 · Question #19
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 gran
Sign in or unlock 1Z0-052 to reveal the answer and full explanation for question #19. The question stem and answer options stay visible for context.
Administering User Security
Question
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?
Options
- AThe table created by SKD is not accessible and SKD cannot create new tables
- BThe tables created by SKD and HR remain, but both cannot create new tables
- CThe table created by HR remains and HR still has the CREATE TABLE system privilege
- DThe table created by HR remains and HR can grant the CREATE TABLE system privilege to other users
Unlock 1Z0-052 to see the answer
You've previewed enough free 1Z0-052 questions. Unlock 1Z0-052 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#ADMIN OPTION#privilege revocation#cascading revoke#system privileges