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. SORT BY

C. ARRANGE BY

D. GROUP 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

The command to modify existing records in a table is:

A. MODIFY

B. UPDATE

C. ALTER

D. CHANGE

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
UPDATE is the DML command used to modify data in existing rows.

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

Question #2

Data that has been processed, organized, structured, or presented in a given context to make it useful is known as what?

A. Raw facts

B. Field

C. Database

D. Information

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Information is data that has been processed, structured, or organized in a meaningful way to provide context and utility to the user.

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

Question #3

What is a database lock?

A. A backup file

B. A mechanism to prevent simultaneous access to the same data causing inconsistency

C. A type of index

D. A user account

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Locking is a concurrency control mechanism that ensures data integrity during simultaneous transactions.

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

Explore All Database Management System (DBMS) MCQs