Home » MCQs » Oracle MCQs

Oracle Clauses MCQs

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

1. Duplicate records are removed from the result set using Oracle ____ clause.

1. DISTINCT
2. FROM
3. HAVING
4. ORDER BY

Answer: A) DISTINCT

Explanation:

Duplicate records are removed from the result set using Oracle DISTINCT clause.

Discuss this Question

---

2. DISTINCT clauses can only be used in Oracle ____ statements.

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

Answer: A) SELECT

Explanation:

DISTINCT clauses can only be used in Oracle SELECT statements.

Discuss this Question

---

3. SELECT expressions must contain a ____ clause.

1. FROM
2. WHERE
3. HAVING
4. FOR

Answer: A) FROM

Explanation:

SELECT expressions must contain a FROM clause.

Discuss this Question

---

4. Data to be retrieved is specified by the ____ clause.

1. WHERE
2. FROM
3. WHAT
4. FOR

Answer: B) FROM

Explanation:

Data to be retrieved is specified by the FROM clause.

Discuss this Question

---

5. Using the ____ Clause in Oracle, records in a result set can be sorted or rearranged.

1. ORDER
2. ORDER TO
3. ORDER FOR
4. ORDER BY

Answer: D) ORDER BY

Explanation:

Using the ORDER BY Clause in Oracle, records in a result set can be sorted or rearranged.

Discuss this Question

---

6. Only the ____ statement uses the ORDER BY clause.

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

Answer: C) SELECT

Explanation:

Only the SELECT statement uses the ORDER BY clause.

Discuss this Question

---

7. What is/are the parameter in ORDER BY clause?

1. Expressions
2. ASC
3. DESC
4. All of the above

Answer: D) All of the above

Explanation:

The parameters in ORDER BY clause are -

1. Expressions
2. ASC
3. DESC
4. Tables
5. Conditions

Discuss this Question

---

8. Sort records in ascending order based on this parameter, which is an optional parameter -

1. ASC
2. DESC
3. DSC
4. AESC

Answer: A) ASC

Explanation:

Sort records based on this parameter, which is an optional parameter - ASC.

Discuss this Question

---

9. SELECT statements in Oracle are used to group results by a single column or multiple columns by using the _____ clause.

1. GROUP
2. GROUP FOR
3. GROUP BY
4. GROUP TO

Answer: C) GROUP BY

Explanation:

SELECT statements in Oracle are used to group results by a single column or multiple columns by using the GROUP BY clause.

Discuss this Question

---

10. What is/are the parameter(s) in GROUP BY clause?

1. Aggregate_function
2. Aggregate_expression
3. Both A and B
4. None of the above

Answer: C) Both A and B

Explanation:

The parameters in GROUP BY clause are -

1. Aggregate_function
2. Aggregate_expression
3. Expressions
4. Tables
5. Conditions

Discuss this Question

---

11. By using the _____ clause with the GROUP BY Clause in Oracle, the condition TRUE is used to limit the rows returned which are grouped into groups.

1. HAVE
2. HAVIN
3. HAVING
4. None

Answer: C) HAVING

Explanation:

By using the HAVING clause with the GROUP BY Clause in Oracle, the condition TRUE is used to limit the rows returned which are grouped into groups.

Discuss this Question

---

12. What is the parameter in HAVING clause?

1. Have_conditions
2. ASC
3. DESC
4. Having_conditions

Answer: D) Having_conditions

Explanation:

The parameter in HAVING clause is having_conditions.

Discuss this Question

---

13. having_conditions parameter specifies the conditions that will be applied only to ____ results so that the returned rows can be grouped accordingly.

1. Analytical
2. Relational
3. Aggregated
4. None

Answer: C) Aggregated

Explanation:

This parameter specifies the conditions that will be applied only to aggregated results so that the returned rows can be grouped accordingly.

Discuss this Question

---

---