Which SQL statement accomplishes this?

The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement
accomplishes this?

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



Leave a Reply 1

Your email address will not be published. Required fields are marked *


TSEKOS

TSEKOS

the explanation given is for another question inherent how is possible to see the coloumns of a constranint. Anyway the answer is D