Solved

What Will Be the Outcome of the Following SQL Statements

Question 27

Multiple Choice

What will be the outcome of the following SQL statements issued in the HAPPY INSURANCE database?
CREATE ROLE supervisor;
GRANT SELECT,INSERT,UPDATE ON client TO supervisor;
GRANT SUPERVISOR TO shannon;


A) Shannon can read data from CLIENT,change data in CLIENT,change the metadata of CLIENT,insert data in CLIENT
B) Shannon can read data from CLIENT,change data in CLIENT,insert data in CLIENT
C) Shannon can read data from CLIENT,change data in CLIENT,change the metadata of CLIENT
D) Shannon can change the metadata of CLIENT

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions