nerdexam
Oracle

1Z0-061 · Question #315

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? (Choose the best answer.)

The correct answer is B. The third statement will show the contents of EMPLOYEES. See the full explanation below for the reasoning.

Question

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? (Choose the best answer.)

Options

  • 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

How the community answered

(34 responses)
  • A
    6% (2)
  • B
    82% (28)
  • C
    9% (3)
  • D
    3% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-061 Practice