Understanding Oracle Operators: Beginner-Level Quiz

The _____ operator in Oracle is used to combine two result sets and returns the data which are common in both the result set.

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

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

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

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

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 _______.

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.

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

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

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

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.

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?

Which statement is true regarding operators used with subqueries?

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.

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

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.

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

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