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.
References:
* Oracle Database SQL Language Reference, 12c Release 1 (12.1): "CREATE SYNONYM"