Oracle Database SQL — Question 253

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. Any user can drop a PUBLIC synonym.
• E. A synonym created by one user can refer to an object belonging to another user.

Correct answer: B, C, E

Explanation

The correct answers are B, C, and E because a synonym can indeed be made accessible to all users, a SEQUENCE can have a synonym associated with it, and synonyms can reference objects owned by different users. Option A is incorrect as PL/SQL packages can have synonyms, and option D is wrong because only users with the appropriate privileges can drop a PUBLIC synonym.