Understanding Oracle Operators: Beginner-Level Quiz

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

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

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.

In the case of UNION Operations, there must be the ___ number of expressions in both statements of the SELECT statement.

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

Hoe many types of operators are there in Oracle?

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

How many types of SET operators are there?

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

Which is not a type of operator in Oracle?

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

You can use the Oracle ____ operator if you don't want to remove duplicate data.

All set operators have equal precedence. True or False?

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

The ORDER BY clause can be used to order the results of a query using the Oracle ____ operator.

After the UNION, the result set would only contain a ____ instance of it because Oracle removes duplicates.

Which statement is true regarding operators used with subqueries?

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

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

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 operator but not by the UNION ALL operator. True or False?