Understanding Oracle Operators: Beginner-Level Quiz

In the results sets of the SELECT statements inside the UNION ALL, the result sets must contain fields of a ___ type.

_______ operation preserves those that would have been lost in _______.

Duplicates are removed by the UNION operator but not by the UNION ALL operator. True or False?

If a SQL statement contains multiple set operators, then Oracle Database evaluates them from the right to left unless parentheses explicitly specify another order. True or False?

Duplicates are removed by the UNION ALL operator but not by the UNION operator. True or False?

The UNION operator combines the results of two or more SELECT queries into a single result set – as if it came from a single query.

The INTERSECT Operator picks up records that are ____ from several SELECT queries in Oracle.

Which is not a type of operator in Oracle?

As SELECT statements have datasets, the MINUS operator ___ all the documents from the first dataset, then returns all documents from the second dataset.

As part of a UNION operation, individual SELECT statements must have ___ fields and similar types of data in their result sets.

Which statement is true regarding operators used with subqueries?

Operators are used to expressing the conditions in Select statements. True or False?

When two or more Oracle Select statements are combined with the _____ operator, the result sets are combined.

Oracle lets you combine two ____ statements and remove duplicate rows between them using the UNION operator.

The ______ Operator in Oracle is used with the WHERE clause to search for a specific pattern in a given string. The string pattern contains wildcard characters that represent missing characters.

The ______ operator is used to combine the result set of two or more SELECT statements into a single result set and then eliminates any duplicate rows from the final result set.

By contrast, UNION ALL does not ____ duplicate rows between several SELECT statements, which is what sets it apart from the UNION operator.

Duplicates are removed by the UNION ALL operator. True or False?

How many types of SET operators are there?

Which operator will be evaluated first in the following SELECT statement?

SELECT (2+3*4/2-5) FROM dual;