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)- A9% (5)
- B5% (3)
- C71% (41)
- D16% (9)
Community Discussion
No community discussion yet for this question.