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"