Which three statements are true about Oracle synonyms?
A.
A synonym cannot be created for a PL /SQL package.
B.
A SEQUENCE can have a synonym.
C.
A synonym can be available to all users .
D.
A synonym created by one user can refer to an object belonging to another user.
E.
Any user can drop a PUBLIC synonym.
The Answer Is:
B, C, D
This question includes an explanation.
Explanation:
B. True. In Oracle, synonyms can be created for sequences, allowing them to be referenced with an alternative name. This can be particularly useful when sequences are accessed across different schemas.
C. True. Oracle provides the ability to create public synonyms which are available to all users in the database. A public synonym is accessible to any user that has the necessary privileges on the underlying object.
D. True. A synonym can be created by a user to refer to an object owned by another user, assuming that the creator of the synonym has the necessary privileges to access the object owned by the other user.