Home » MCQs » Oracle MCQs

Oracle Intersect and Minus Operators MCQs

Oracle Intersect and Minus Operators MCQs: This section contains multiple-choice questions and answers on Intersect and Minus Operators in Oracle.
Submitted by Anushree Goswami, on June 27, 2022

1. INTERSECT Operators return the results of multiple ____ statements in Oracle.

1. SELECT
2. UPDATE
3. INSERT
4. DELETE

Answer: A) SELECT

Explanation:

INTERSECT Operators return the results of multiple SELECT statements in Oracle.

Discuss this Question

---

2. INTERSECT Operators return the results of multiple SELECT statements in Oracle.

1. expression1, expression2, ... expression_n
2. table1, table2
3. Conditions
4. All of the above

Answer: D) All of the above

Explanation:

The parameters in the syntax of Oracle INTERSECT Operator -

1. expression1, expression2, ... expression_n
2. table1, table2
3. Conditions

Discuss this Question

---

3. Expression parameter specify which columns you would like to ____.

1. Show
2. Add
3. Retrieve
4. None

Answer: C) Retrieve

Explanation:

Expression parameter specify which columns you would like to retrieve.

Discuss this Question

---

4. Table specifies the ____ from which you want records to be retrieved.

1. Records
2. Tables
3. Rows
4. Columns

Answer: B) Tables

Explanation:

Table specifies the tables from which you want records to be retrieved.

Discuss this Question

---

5. The ____ parameter specify what conditions must be satisfied before records can be selected.

1. Expression
2. Table
3. Conditions
4. None

Answer: C) Conditions

Explanation:

The conditions specify what conditions must be satisfied before records can be selected.

Discuss this Question

---

6. Both SELECT statements must have the same number of ____ and a similar data type in Oracle MINUS.

1. Conditions
2. Expressions
3. Values
4. None

Answer: B) Expressions

Explanation:

Both SELECT statements must have the same number of expressions and a similar datatype.

Discuss this Question

---

7. Which of the following is NOT present in the syntax of Oracle MINUS?

1. Where
2. Table
3. Condition
4. None

Answer: D) None

Explanation:

Where, Table, and Condition are all present in the syntax of Oracle MINUS.

Discuss this Question

---

---