Oracle Database SQL — Question 177

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

Answer options

• A. Users must have the required privileges on the underlying objects to use public synonyms.
• B. Synonyms can be created for roles.
• C. Synonyms cannot be created for sequences.
• D. Synonyms cannot be created for synonyms.
• E. Synonyms can be created for packages.
• F. Users must have the DBA role to create public synonyms.

Correct answer: A, E

Explanation

Option A is correct because users indeed need the necessary privileges on the underlying objects to access public synonyms. Option E is also correct as synonyms can be created for packages. The other options are incorrect; for instance, synonyms cannot be created for roles (B), sequences (C), or other synonyms (D), and it is not necessary to have the DBA role to create public synonyms (F).