Understanding Oracle Operators: Beginner-Level Quiz

When you run several SELECT statements in Oracle, you can use the ____ Operator to return the results.

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

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

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

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

Which is not a type of operator in Oracle?

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

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.

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

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

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

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.

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

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

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

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

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?

The INTERSECT Operator picks up records that are ____ from several SELECT queries 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.