Oracle synonyms are used to simplify the referencing of complex schema objects:
* Option A: Incorrect. A synonym cannot have another synonym; it directly references the base object.
* Option B: Incorrect. A synonym does not have an object number as it is merely an alias for another
* object.
* Option C: Correct. Any user with sufficient privileges can create a public synonym, which is accessible to all users in the database.
* Option D: Incorrect. All private synonym names must be unique within a schema but not across the entire database.
* Option E: Correct. Synonyms can be created for objects within packages, such as procedures or functions, simplifying the referencing of these objects without needing to specify the full package name.