Home » MCQs » Oracle MCQs

Oracle Operators MCQs

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

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

1. UNION
2. UNITE
3. UNIQUE
4. None

Answer: A) UNION

Explanation:

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

Discuss this Question

---

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

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

Answer: A) SELECT

Explanation:

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

Discuss this Question

---

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

1. Duplicate
2. Triplate
3. Identical
4. Multiple

Answer: C) Identical

Explanation:

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

Discuss this Question

---

4. In the case of UNION Operations, there must be the ___ number of expressions in both statements of the SELECT statement.

1. Different
2. Multiple
3. Same
4. None

Answer: C) Same

Explanation:

In the case of UNION Operations, there must be the same number of expressions in both statements of the SELECT statement.

Discuss this Question

---

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

1. Single
2. Double
3. Triple
4. Multiple

Answer: A) Single

Explanation:

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

Discuss this Question

---

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

1. UNION NONE
2. UNION ALL
3. UNION ONE
4. UNION MULTIPLE

Answer: B) UNION ALL

Explanation:

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

Discuss this Question

---

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

1. UNION
2. UNION NONE
3. UNION ONE
4. None

Answer: A) UNION

Explanation:

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

Discuss this Question

---

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

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

Answer: B) SELECT

Explanation:

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

Discuss this Question

---

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

1. Add
2. Update
3. Remove
4. None

Answer: C) Remove

Explanation:

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

Discuss this Question

---

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

1. Similar
2. Different
3. Multiple
4. None

Answer: A) Similar

Explanation:

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

Discuss this Question

---

11. Which of the following statement is TRUE?

1. Duplicates are removed by the UNION ALL operator but not by the UNION operator.
2. Duplicates are removed by the UNION operator but not by the UNION ALL operator.
3. Duplicates are removed by the UNION ALL operator.
4. Duplicates are not removed by the UNION operator.

Answer: B) Duplicates are removed by the UNION operator but not by the UNION ALL operator

Explanation:

Duplicates are removed by the UNION operator but not by the UNION ALL operator.

Discuss this Question

---

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

1. INTER
2. INTRASECT
3. INTERSECT
4. None

Answer: C) INTERSECT

Explanation:

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

Discuss this Question

---

13. The INTERSECT Operator picks up records that are ____ from several SELECT queries in Oracle.

1. Common
2. Intersecting
3. Both A and B
4. None of the above

Answer: C) Both A and B

Explanation:

The INTERSECT operator picks up records that are common or intersecting from several SELECT queries in Oracle.

Discuss this Question

---

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

1. ADD
2. MINUS
3. MULTIPLY
4. DIVIDE

Answer: B) MINUS

Explanation:

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

Discuss this Question

---

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

1. Adds
2. Removes
3. Inserts
4. Updates

Answer: B) Removes

Explanation:

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

Discuss this Question

---

---