Home » Oracle » 1z0-051 » 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;
Correct Answer: D
Explanation/Reference:
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
Download Printable PDF. VALID exam to help you PASS.
|
|