Multiple choice technology databases

What are the different types of synonyms?

  1. Schema synonym

  2. Public synonym

  3. Private synonym

  4. Database synonym
Reveal answer Fill a bubble to check yourself
B,C Correct answer
Explanation

Oracle supports two main types of synonyms: public synonyms (accessible to all users) and private synonyms (schema-specific). Public synonyms are created with CREATE PUBLIC SYNONYM and can be referenced by any user with appropriate privileges on the underlying object. Private synonyms are created in a specific schema and are only available to users who can access that schema. 'Schema synonym' and 'Database synonym' are not standard Oracle synonym categories.

Keep practicing — related questions