Oracle Database Administration I — Question 45

Which three statements are true about Oracle synonyms? (Choose three.)

Answer options

• A. A synonym cannot be created for a PL/SQL package
• B. A synonym can be available to all users
• C. A SEQUENCE can have a synonym
• D. A synonym created by one user can refer to an object belonging to another user
• E. Any user can drop a PUBLIC synonym

Correct answer: B, C, D

Explanation

The correct answers B, C, and D highlight the flexibility and accessibility of synonyms in Oracle. Specifically, a synonym can be public, can point to a SEQUENCE, and can reference objects across different users. Option A is incorrect because synonyms can indeed be created for PL/SQL packages, and option E is wrong since not every user has the privilege to drop a PUBLIC synonym.