Oracle Database SQL — Question 212

You have the privileges to create any type of synonym.

Which statement will create a synonym called EMP for the HCM.EMPLOYEE_RECORDS table that is accessible to all users?

Answer options

• A. CREATE PUBLIC SYNONYM emp FOR hcm.employee_records;
• B. CREATE GLOBAL SYNONYM emp FOR hcm.employee_records;
• C. CREATE SYNONYM emp FOR hcm.employee_records:
• D. CREATE SYNONYM SYS.emp FOR hcm.employee_records;
• E. CREATE SYNONYM PUBLIC.emp FOR hcm.employee_records;

Correct answer: A

Explanation

The correct answer is A, as a public synonym allows all users to access it. Option B is incorrect because 'GLOBAL' is not a valid synonym type in this context. Option C is incorrect as it does not specify the synonym as public, making it accessible only to the user who created it. Option D incorrectly uses 'SYS' as a prefix, which is not necessary for creating public synonyms. Option E is also incorrect as it uses 'PUBLIC' in the synonym name, which is not the proper syntax.