Which of the Following SQL Statements Allows a User Named

question 23

Multiple Choice

Which of the following SQL statements allows a user named mgarcia to select, insert, update, delete, and create a constraint in the Products table?

• A)ALLOW ALL ON Products TO mgarcia;
• B)GRANT SELECT FROM Products TO mgarcia;
• C)GIVE PRIVILEGES ON Products TO mgarcia;
• D)GRANT ALL ON Products TO mgarcia;

---

Definitions:

Injunctive

Relating to an authoritative rule or order which dictates expected or allowable behaviors.

Focus Theory

A theoretical framework that emphasizes how individuals allocate their attention and resources towards specific goals or tasks.

Salience

The aspect of a schema that is active in one’s mind and, consciously or not, colors perceptions and behavior.

Normative Conduct

Behaviors that are considered normal or usual within a society based on shared norms or standards.