The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement
accomplishes this?
A.
GRANT select ON dept
TO ALL_USERS;
B.
GRANT select ON dept
TO ALL;
C.
GRANT QUERY ON dept
TO ALL_USERS
D.
GRANT select ON dept
TO PUBLIC;
Explanation:
view the columns associated with the constraint names in the
USER_CONS_COLUMNS view.
Incorrect answer:
Atable to view all constraints definition and names
Bshow all object name belong to user
Cdoes not display column associated
Eno such view
Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 10-25
the explanation given is for another question inherent how is possible to see the coloumns of a constranint. Anyway the answer is D