1Z0-071 practice question 11 of 35

You have the privileges to create any type of synonym. Which stalement will create a synonym called EMP for the HCM.EMPLOYEE_RECORDS table that is accesible to all users?

Full set: 326 questions
Answer options
A: CREATE GLOBAL SYNONYM emp FOR hcm.employee_records;
B: CREATE SYNONYM emp FOR hcm.employee_records;
C: CREATE SYNONYM PUBLIC.emp FOR hcm.employee_records;
D: CREATE SYNONYM SYS.emp FOR hcm.employee_records;
E: CREATE PUBLIC SYNONYM emp FOR hcm. employee_records; Correct answer
Correct Answer:
E. CREATE PUBLIC SYNONYM emp FOR hcm. employee_records;
Explanation

To create a synonym that is accessible to all users in the database, you must create a PUBLIC synonym. The correct syntax for this is CREATE PUBLIC SYNONYM synonymname FOR objectname;. Option E uses this exact syntax to create a public synonym named emp for the hcm.employeerecords table. Once created, any user with appropriate privileges on the underlying table can refer to it as emp without needing to specify the hcm schema.

Why Incorrect

A. GLOBAL is not a valid keyword in the CREATE SYNONYM statement. The syntax is incorrect.
B. This statement creates a private synonym in the current user's schema, which is not accessible to all users by default.
C. This is not the correct syntax. To create a public synonym, the PUBLIC keyword must

References

1. Oracle Database SQL Language Reference 19c, “CREATE SYNONYM” statement – public synonym syntax (Doc ID: E96306-01, §CREATE SYNONYM).

2. Oracle Database Concepts 19c, “Schema Objects: Synonyms” – visibility rules for public vs. private synonyms (Doc ID: E96299-01, §5.8).

Scroll to Top