What is the default sorting order when using ORDER BY without specifying ASC or DESC? MCQ with Answer and Explanation

Question

Share Report Error

What is the default sorting order when using ORDER BY without specifying ASC or DESC?

A. No order

B. Ascending

C. Random

D. Descending

Answer: Option B

Solution (By JKSSB Mock Tests)

ORDER BY defaults to ascending (ASC) 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

In SQL, what is the purpose of the LIKE operator?

A. To perform pattern matching on strings

B. To join tables

C. To perform arithmetic operations

D. To aggregate data

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
LIKE is used with wildcards (% and _) to search for a specified pattern in a column.

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

Question #2

Which of the following is a valid SQL string function?

A. REPLACE

B. SUBSTRING

C. All of the above

D. CONCAT

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
SUBSTRING, CONCAT, and REPLACE are common string functions in SQL.

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

Question #3

Which normal form requires that every determinant is a candidate key?

A. BCNF

B. 1NF

C. 3NF

D. 2NF

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Boyce-Codd Normal Form (BCNF) is a stricter version of 3NF where every determinant must be a candidate key.

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

Explore All Database Management System (DBMS) MCQs