Oracle Exam 1Z0-061 Topic 3 Question 3 Discussion

Actual exam question for Oracle's 1Z0-061 exam

Question #: 3
Topic #: 3

[All 1Z0-061 Questions]

Consider these three statements:

create synonym s1 for employees; create public synonym s1 for departments; select * from s1;

Which of the following statements is correct?

AThe second statement will fail because an object S1 already exists.

BThe third statement will show the contents of EMPLOYEES.

CThe third statement will show the contents of DEPARTMENTS.

DThe third statement will show the contents of the table S1, if such a table exists in the current schema.

Show Suggested Answer

Suggested Answer: B

The order of priority is to search the schema namespace before the public namespace, so it will be the private synonym (to EMPLOYEES) that will be found.

by Laurel at Jun 14, 2022, 02:25 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-061 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!