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 UNION operator combines the results of two or more SELECT queries into a single result set – as if it came from a single query.

Which statement is true regarding operators used with subqueries?

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

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

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

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

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

According to Oracle, the ____ operator returns all rows that are not returned in the second SELECT statement from the first SELECT statement.

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

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

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

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

UNION ALL combines the results from multiple ____ statements in Oracle.

The _______ Operators in Oracle are used for performing mathematical calculations such as Addition, Subtraction, Multiplication, Module, and Division represented by the expected +, -, *(star or asterisk), %, and / forward slash symbols respectively on the given operand values.

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

All set operators have equal precedence. True or False?

How many types of SET operators are there?

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 ORDER BY clause can be used to order the results of a query using the Oracle ____ operator.