Which of the Following SQL Statements Rescinds Privileges for User

question 10

Multiple Choice

Which of the following SQL statements rescinds privileges for user kchen05 to create constraints and delete data in the Customers table?

• A)REVOKE ALL ON Customers TO kchen05;
• B)REVOKE CONSTRAINTS, DELETE ON Customers TO kchen05;
• C)REVOKE REFERENCES, DELETE ON Customers TO kchen05;
• D)RESCIND REFERENCES, DELETE ON Customers TO kchen05;

---

Definitions:

Smooth Flow

The unimpeded progress or movement of something, ensuring continuity and efficiency.

Nominal Brainstorming

a technique where group members generate ideas individually to avoid influence from others.

Brainstorming Literature

Literature that provides insights or methods on generating ideas and solutions through collective discussion or thought processes.

Communication

The act of transferring information from one place, person, or group to another, through speaking, writing, or using some other medium.