Oracle Database SQL - 1z1-071 FREE EXAM DUMPS QUESTIONS & ANSWERS

A. Operators are evaluated before conditions. B. || has a higher order of precedence than + (addition). C. AND and OR have the same order of precedence in a condition. D. NOT has a higher order of precedence than AND and OR in a condition. E. + (addition) has a higher order of precedence than * (multiplication).

A. 1 and 2 B. 2 and 3 C. 1 and 3 D. 1, 2, and 3

A. SELECT NVL('DATE', SYSDATE) FROM DUAL; B. SELECT COALESCE('DATE', SYSDATE) FROM DUAL; C. SELECT COALESCE(0, SYSDATE) FROM DUAL; D. SELECT NVL('DATE', 200) FROM (SELECT NULL AS "DATE" FROM DUAL); E. SELECT COALESCE('DATE', SYSDATE) FROM (SELECT NULL AS "DATE" FROM DUAL);

A. It succeeds and CITY can contain only `SEATTLE' or null for all rows. B. It fails because the condition for the CNAMES constraint is not valid. C. It succeeds and an index is crated for CITIZEN_ID. D. It fails because the NOT NULL and DEFAULT options cannot be combined for the same column.

A. The Oracle join operator (+) must be used on both sides of the join condition in the WHERE clause. B. It includes rows that are returned by a Cartesian product. C. It returns matched and unmatched rows from both tables being joined. D. It returns only unmatched rows from both tables being joined. E. It includes rows that are returned by an inner join.

A. Each row is evaluated by the first WHEN clause and if the condition is false then the row would be evaluated by the subsequent when clauses. B. The INSERT statement will return an error because the ELSE clause is missing. C. All rows are evaluated by all the three WHEN clauses. D. Each row is evaluated by the first WHEN clause and if the condition is true, then the row would be evaluated by the subsequent when clauses.

A. MEMBER_ID = ""; B. MEMBER_ID IS NULL; C. MEMBER_ID = NULL; D. MEMBER_ID = '';

A. Each SELECT statement in the compound query must have its own ORDER BY clause. B. Only column names from the first SELECT statement in the compound query are recognized. C. The first column in the first SELECT of the compound query with the UNION operator is used by default to sort output in the absence of an ORDER BY clause. D. Each SELECT statement in the compound query can have its own ORDER BY clause. E. Column positions must be used in the ORDER BY clause.

A. The NOT IN operator is equivalent to IS NULL. B. The IN operator cannot be used in single-row subqueries. C. The <ANY operator means less than the maximum. D. The NOT operator can be used with IN, ANY and ALL operators. E. =ANY and =ALL operators have the same functionality.