PrepAway - Latest Free Exam Questions & Answers

What does the following statement do?

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

PrepAway - Latest Free Exam Questions & Answers

A.
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.

B.
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.

C.
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.

D.
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.

One Comment on “What does the following statement do?


Leave a Reply