READ Free Dumps For Oracle- 1z0-001
| Question ID 8134 | You issue this command: CREATE PUBLIC SYNONYM empFOR ed.employee; Which task has been accomplished? |
| Option A | The object can now be accessed by the all users. |
| Option B | All users are given object privileges to the table. |
| Option C | The need to qualify object name with its schema was eliminated only for you. |
| Option D | The need to qualify the name with its schema has been eliminated for all the users, who have access to this table. |
| Correct Answer | D |
| Question ID 8135 | Incorrect Answers: A: Creation public synonym will not open access for ALL users, but will make more easy access for user which have access to EMPLOYEE table of user ED. B: Creation public synonym for table does not provide objects privileges for ALL users to the table. C: Because of creation PUBLIC synonym for ED.EMPLOYEE need to qualify the object name with its owner name is eliminated for ALL users who have already access to this table, not only for you. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 183-185 Chapter 4: Creating Other Database Objects in Oracle |