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.
- DISTINCT
- FROM
- HAVING
- 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.
- SELECT
- INSERT
- UPDATE
- 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.
- FROM
- WHERE
- HAVING
- 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.
- WHERE
- FROM
- WHAT
- 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.
- ORDER
- ORDER TO
- ORDER FOR
- 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.
- INSERT
- UPDATE
- SELECT
- 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?
- Expressions
- ASC
- DESC
- All of the above
Answer: D) All of the above
Explanation:
The parameters in ORDER BY clause are -
- Expressions
- ASC
- DESC
- Tables
- Conditions
Discuss this Question
8. Sort records in ascending order based on this parameter, which is an optional parameter -
- ASC
- DESC
- DSC
- 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.
- GROUP
- GROUP FOR
- GROUP BY
- 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?
- Aggregate_function
- Aggregate_expression
- Both A and B
- None of the above
Answer: C) Both A and B
Explanation:
The parameters in GROUP BY clause are -
- Aggregate_function
- Aggregate_expression
- Expressions
- Tables
- 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.
- HAVE
- HAVIN
- HAVING
- 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?
- Have_conditions
- ASC
- DESC
- 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.
- Analytical
- Relational
- Aggregated
- 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