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…

Synonyms in Oracle are aliases for database objects that can simplify SQL statements for database

users.

A . The term "GLOBAL" is not used in the creation of synonyms in Oracle.

B . The statement without the keyword PUBLIC will create a private synonym that is only accessible

to the user creating the synonym, not all users.

C . The correct syntax does not include PUBLIC as a prefix to the synonym name itself, making this

option incorrect.

D . You cannot specify the SYS schema for creating synonyms, as it is reserved for system objects.

E . This is the correct syntax to create a public synonym, which makes the underlying object

accessible to all users.

Reference:

Oracle Database SQL Language Reference, 12c Release 1 (12.1): "CREATE SYNONYM"