Which of the following privileges will allow a user to reference a table when creating a FOREIGN KEY constraint?
A) FOREIGN KEY
B) REFERENCES
C) SELECT
D) none of the above

Question

​Which of the following privileges will allow a user to reference a table when creating a FOREIGN KEY constraint?
A) ​FOREIGN KEY
B) ​REFERENCES
C) ​SELECT
D) ​none of the above

Quizplus · Accepted Answer

The REFERENCES privilege is required for a user to create a FOREIGN KEY constraint because it allows them to reference another table as the parent. The FOREIGN KEY privilege is not necessary as it only allows a user to create a FOREIGN KEY constraint on their own table. SELECT privilege is not relevant to creating a FOREIGN KEY constraint.

​Which of the Following Privileges Will Allow a User to Reference

Which of the Following Privileges Will Allow a User to Reference