Examice

Exam 1z0-071 All QuestionsBrowse all questions from this exam

Go to Exam

Question 209

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

Users must have the required privileges on the underlying objects to use public synonyms.

Synonyms can be created for roles.

Synonyms cannot be created for sequences.

Synonyms cannot be created for synonyms.

Synonyms can be created for packages.

Users must have the DBA role to create public synonyms.

Correct Answer: A, E

Users must have the required privileges on the underlying objects to use public synonyms, and synonyms can be created for packages. This aligns with Oracle's documentation and general understanding of Oracle synonyms.

Discussion

billysunday1Options: AE

Answer is A, E https://docs.oracle.com/en/database/oracle/oracle-database/21/sqlrf/CREATE-SYNONYM.html

id10111110Options: AE

Resource for Oracle synonyms: https://www.databasestar.com/oracle-synonym/

lucemqyOptions: AE

AE is correct