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.
- SELECT
- UPDATE
- INSERT
- 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.
- expression1, expression2, ... expression_n
- table1, table2
- Conditions
- All of the above
Answer: D) All of the above
Explanation:
The parameters in the syntax of Oracle INTERSECT Operator -
- expression1, expression2, ... expression_n
- table1, table2
- Conditions
Discuss this Question
3. Expression parameter specify which columns you would like to ____.
- Show
- Add
- Retrieve
- 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.
- Records
- Tables
- Rows
- 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.
- Expression
- Table
- Conditions
- 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.
- Conditions
- Expressions
- Values
- 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?
- Where
- Table
- Condition
- None
Answer: D) None
Explanation:
Where, Table, and Condition are all present in the syntax of Oracle MINUS.
Discuss this Question