READ Free Dumps For Oracle- 1z1-051
| Question ID 4942 | The user Alice wants to grant all users query privileges on her DEPT table. Which SQL |
| Option A | A. GRANT select ON dept TO ALL_USERS; |
| Option B | B. GRANT select ON dept TO ALL; |
| Option C | C. GRANT QUERY ON dept TO ALL_USERS |
| Option D | D. GRANT select ON dept TO PUBLIC; |
| Correct Answer | D |
| Question ID 4943 | Which view should a user query to display the columns associated with the constraints on a table owned by the user? |
| Option A | A. USER_CONSTRAINTS |
| Option B | B. USER_OBJECTS |
| Option C | C. ALL_CONSTRAINTS |
| Option D | D. USER_CONS_COLUMNS |
| Option E | E. USER_COLUMNS |
| Correct Answer | D |