Multiple choice technology databases

What does the following statement do? GRANT REFERENCES (col1, col2) ON TABLE table1 TO user1 WITH GRANT OPTION

  1. Gives user USER1 the ability to refer to COL1 and COL2 of table TABLE1 in queries, along with the ability to give this authority to other users and groups.

  2. Gives user USER1 the ability to refer to COL1 and COL2 of table TABLE1 in views, along with the ability to give this authority to other users and groups.

  3. Gives user USER1 the ability to define a referential constraint on table TABLE1 using columns COL1 and COL2 as the parent key of the constraint.

  4. Gives user USER1 the ability to define a referential constraint on table TABLE1 using columns COL1 and COL2 as the foreign key of the constraint.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The REFERENCES privilege allows a user to define a referential constraint (foreign key) referencing the specified columns of the parent table. Specifying a parent key is the primary function of this privilege, rather than enabling queries or views (which require SELECT) or defining columns as foreign keys.

Keep practicing — related questions