Oracle Updated 1z0-071 Exam Questions and Answers by luan

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"

Oracle's interval data types store a period of time. When you want to format an interval as a string, you can use the TO_CHAR function.

A. This statement will not execute successfully because TO_DATE expects a string representing a date, not a number derived from an interval.

B. This statement will not execute successfully because TO_NUMBER does not support interval data types as an input.

C. This statement will not execute successfully because TO_DATE does not support interval data types as an input.

D. This statement will not execute successfully because TO_NUMBER expects a number or a string representing a number as an argument, not a date.

E. This statement will execute successfully. TO_CHAR function can be used to convert interval values to a formatted string, such as 'HH24:MM'.

Regarding the precedence of operators and conditions in Oracle Database 12c:

Option B: NOT has a higher order of precedence than AND and OR in a condition.

In logical operations, NOT is evaluated first, followed by AND and then OR.

Option E: || has a higher order of precedence than +(addition).

The string concatenation operator || has a higher precedence than the arithmetic + operator.

Options A, C, and D are incorrect because:

Option A: Multiplication (*) has a higher precedence than addition (+).

Option C: AND has a higher precedence than OR.

Option D: Conditions (which may contain operators) are evaluated according to the rules of operator precedence.