Examine the following steps performed on a database instance:1. The DBA grants the CREATE TABLE system privilege to the

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

Examine the following steps performed on a database instance:1. The DBA grants the CREATE TABLE system privilege to the

Post by answerhappygod »

Examine the following steps performed on a database instance:1. The DBA grants the CREATE TABLE system privilege to the SKD user with ADMINOPTION -2. 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?

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
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply