1Z0-071 Free Practice Test

Which three statements are true regarding the SQL WHERE and HAVING clauses?

1. A. The HAVING clause conditions can have aggregating functions.
2. B. The HAVING clause conditions can use aliases for the columns.
3. C. The WHERE and HAVING clauses cannot be used together in a SQL statement.
4. D. The WHERE clause is used to exclude rows before grouping data.
5. E. The HAVING clause is used to exclude one or more aggregated results after grouping data.

Correct Answer: ADE

Evaluate the following CREATE TABLE command:
<>

1. A. It would execute successfully and only ORD_ITM_IDX index would be created.
2. B. It would give an error because the USING INDEX clause cannot be used on a composite primary.
3. C. It would execute successfully and two indexes ORD_ITM_IDX and ORD_ITM_ID PK would be created.
4. D. It would give an error because the USING INDEX is not permitted in the CRETAE TABLE command.

Correct Answer: A

View and Exhibit and examine the structure and data in the INVOICE table. (Choose two.)
<>

1. A. inv_date = \'15-february-2008\' :uses implicit conversion
2. B. inv_amt = \'0255982\' : requires explicit conversion
3. C. inv_date > \'01-02-2008\' : uses implicit conversion
4. D. CONCAT(inv_amt, inv_date) : requires explicit conversion
5. E. inv_no BETWEEN \'101\' AND \'110\' : uses implicit conversion

Correct Answer: AE

Evaluate the following query:
<>

1. A. +00-300, +54-02,+00 11:12:10.123457
2. B. +00-300,+00-650,+00 11:12:10.123457
3. C. +25-00, +54-02, +00 11:12:10.123457
4. D. +25-00,+00-650,+00 11:12:10.123457

Correct Answer: C

Which two are the minimal requirements for a self-join? (Choose two.)

1. A. Only equijoin conditions may be used in the query.
2. B. Outer joins must not be used in the query.
3. C. There must be a condition on which the self-join is performed.
4. D. No other condition except the self-join may be specified.
5. E. The table used for the self-join must have two different alias names in the query.

Correct Answer: CE