Oracle Database Administration I — Question 91

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. A synonym can be created on an object in a package.
• D. All private synonym names must be unique in the database.
• E. A synonym can have a synonym.

Correct answer: B, E

Explanation

Option B is correct because synonyms do indeed have an object number that uniquely identifies them in the database. Option E is also correct as it is possible for a synonym to point to another synonym. The other options are incorrect; while any user can create a public synonym, they cannot create it without proper privileges, and all private synonym names must be unique within the same schema, not the entire database.