READ Free Dumps For Oracle- 1z0-007
Question ID 8015 | The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this?
|
Option A | GRANT select ON dept TO ALL_ USER;
|
Option B | GRANT select ON dept TO ALL;
|
Option C | GRANT QUERY ON dept TO ALL_USERS
|
Option D | GRANT select ON dept TO PUBLIC;
|
Correct Answer | D |
Explanation Explanation/Reference: Explanation : view the columns associated with the constraint names in the USER_CONS_COLUMNS view. Incorrect answer : A table to view all constraints definition and names B show all object name belong to user C does not display column associated E no such view Refer : Introduction to Oracle9i : SQL, Oracle University Study Guide, 10-25
Question ID 8016 | Which view should a user query to display the columns associated with the constraints on a table owned by the user?
|
Option A | USER_CONSTRAINTS
|
Option B | USER_OBJECTS
|
Option C | ALL_CONSTRAINTS
|
Option D | USER_CONS_COLUMNS
|
Option E | USER_COLUMNS
|
Correct Answer | D |
Explanation Explanation/Reference: Explanation : view the columns associated with the constraint names in the USER_CONS_COLUMNS view. Incorrect answer : A table to view all constraints definition and names B show all object name belong to user C does not display column associated E no such view Refer : Introduction to Oracle9i : SQL, Oracle University Study Guide, 10-25