Oracle Database SQL — Question 242

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

Answer options

• A. Any user can create a PUBLIC synonym.
• B. A synonym has an object number.
• C. All private synonym names must be unique in the database.
• D. A synonym can be created on an object in a package.
• E. A synonym can have a synonym.

Correct answer: B, E

Explanation

Option B is correct because a synonym indeed has an associated object number that identifies it within the database. Option E is also correct as synonyms can reference other synonyms, allowing for flexible naming. The other options are incorrect; for example, while any user can create a PUBLIC synonym, not all users can, and private synonyms do not need to be unique across the entire database, just within their schema.