Which clause is used in SQL to sort the final query result set in ascending or descending order? MCQ with Answer and Explanation

Question

Share Report Error

Which clause is used in SQL to sort the final query result set in ascending or descending order?

A. ORDER BY

B. GROUP BY

C. ARRANGE BY

D. SORT BY

Answer: Option A

Solution (By JKSSB Mock Tests)

The ORDER BY clause is used to sort the result set of a query in either ascending (default) or descending (using DESC) order.

This question belongs to: Computer Database Management System (DBMS)

Request complete Subject PDF

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1

What is data redundancy?

A. Processed information

B. Absence of data

C. Duplication of data in multiple places

D. Encrypted data

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Data redundancy refers to unnecessary duplication of data, which DBMS helps control.

This question belongs to: Computer Database Management System (DBMS)

Question #2

RDBMS is based on which model?

A. Hierarchical model

B. Network model

C. Relational model

D. Object-oriented model

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Relational Database Management System (RDBMS) is based on the relational model proposed by E.F. Codd.

This question belongs to: Computer Database Management System (DBMS)

Question #3

Which SQL operator returns only the rows that are common and present in the outputs of both executing SELECT queries?

A. JOIN

B. EXCEPT / MINUS

C. INTERSECT

D. UNION

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The INTERSECT operator returns only the distinct rows that appear in the result sets of both SELECT statements.

This question belongs to: Computer Database Management System (DBMS)

Explore All Database Management System (DBMS) MCQs