nerdexam
Oracle

1Z0-047 · Question #98

Which statement is true regarding synonyms?

The correct answer is C. A public synonym and a private synonym can exist with the same name for the same table. See the full explanation below for the reasoning.

Question

Which statement is true regarding synonyms?

Options

  • ASynonyms can be created for tables but not views.
  • BSynonyms are used to reference only those tables that are owned by another user.
  • CA public synonym and a private synonym can exist with the same name for the same table.
  • DThe DROP SYNONYM statement removes the synonym, and the status of the table on which the synonym

How the community answered

(58 responses)
  • A
    9% (5)
  • B
    5% (3)
  • C
    71% (41)
  • D
    16% (9)

Community Discussion

No community discussion yet for this question.

Full 1Z0-047 Practice