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:

Verified
Correct Answer:
Verified
Q23: What will be the outcome of the
Q24: What is the query cost?
Q25: The TCL commands are used by the
Q26: What is update failure?
Q28: In a role-based access control system,users can
Q29: What is a recovery log?
Q30: The data manipulation DBMS component is used:<br>A)By
Q31: What is view materialization?
Q32: What is a complete mirrored backup?
Q81: What is a data dictionary?