READ Free Dumps For Oracle- 1z0-001
| Question ID 8170 | You issue this command: CREATE SYNONYM emp FOR ed.employee; Which task has been accomplished?
|
| Option A | The need to qualify an object name with its schema was eliminated for user Ed.
|
| Option B | The need to qualify an object name with its schema was eliminated for only you.
|
| Option C | The need to qualify an object name with its schema was eliminated for all users.
|
| Option D | The need to qualify an object name with its schema was eliminated for users with access.
|
| Correct Answer | B |
Explanation Explanation/Reference: Explanation: Answer B is correct because this command will eliminate the need to qualify an object name with its owner schema for you only. Incorrect Answers: A: This command will eliminate the need to qualify an object name with its owner schema for you only, user Ed don't need to specify its name to access objects in his schema. C: This command will eliminate the need to qualify an object name with its owner schema for you only, not for all users. D: This command will eliminate the need to qualify an object name with its owner schema for you only, usage PUBLIC keyword in the CREATE SYNONYM statement will eliminate this need for all users with access to the EMPLOYEE table. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 183-185 Chapter 4: Creating Other Database Objects in Oracle
| Question ID 8171 | Examine this code : SELECT employee.ename FROM employee WHERE employee.empno NOT IN (SELECT manager.mgr FROM emp manager); What is not an operator equivalent to the above query?
|
| Option A | !=
|
| Option B | ALL.
|
| Option C | !=ALL
|
| Option D | NOT LIKE.
|
| Correct Answer | C |
Explanation Explanation/Reference: Explanation: Answer C is correct because operator !=ALL does not exist Incorrect Answers: A: Operator != can be used to rewrite this query. B: Operator ALL can be used to rewrite this query. D: Operator NOT LIKE can be used to rewrite this query. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 20-21 Chapter 1: Selecting Data from Oracle