Multiple Choice
What will be the outcome of the following SQL statements issued in the HAPPY INSURANCE database?
GRANT SELECT,INSERT,ALTER,UPDATE ON client TO shannon;
REVOKE INSERT ON client FROM 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 insert data in CLIENT
Correct Answer:

Verified
Correct Answer:
Verified
Q18: The data definition DBMS component uses the
Q19: In a role-based access control system,the membership
Q20: The data definition component is a part
Q21: What is data backup?
Q24: What is the query cost?
Q25: The TCL commands are used by the
Q26: What is update failure?
Q27: What will be the outcome of the
Q28: In a role-based access control system,users can
Q81: What is a data dictionary?