1z0-082 Free Practice Test

Which statement is true about the INTERSECT operator used in compound queries?

1. A. Multiple INTERSECT operators are not possible in the same SQL statement
2. B. It processes NULLs in the selected columns
3. C. INTERSECT is of lower precedence than UNION or UNION ALL
4. D. It ignores NULLs

Correct Answer: B

Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.)

1. A. Column names in each SELECT in the compound query can be different
2. B. The number of columns in each SELECT in the compound query can be different
3. C. Reversing the order of the intersected tables can sometimes affect the output
4. D. INTERSECT returns rows common to both sides of the compound query
5. E. INTERSECT ignores NULLs

Correct Answer: AE

Which statement is true about aggregate functions?

1. A. Aggregate functions can be nested to any number of levels
2. B. The AVG function implicitly converts NULLS to zero
3. C. Aggregate functions can be used in any clause of a SELECT statement
4. D. The MAX and MIN functions can be used on columns with character data types

Correct Answer: A

Examine this command:

Which two statements are true? (Choose two.)

1. A. DML may be performed on tables with one or more extents in this data file during the execution of this command.
2. B. The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.
3. C. The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.
4. D. If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.
5. E. The file is renamed and stored in the same location

Correct Answer: AB

Which two statements are true about the ORDER BY clause when used with a SQL statement containing a SET operator such as UNION? (Choose two.)

1. A. Column positions must be used in the ORDER BY clause
2. B. Only column names from the first SELECT statement in the compound query are recognized
3. 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
4. D. Each SELECT statement in the compound query must have its own ORDER BY clause
5. E. Each SELECT statement in the compound query can have its own ORDER BY clause

Correct Answer: BE