MCQ IN COMPUTER SCIENCE & ENGINEERING

Previous
Next

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
If you don’t specify ASC or DESC after a SQL ORDER BY clause, the following is used by default ____
A
ASC
B
DESC
C
There is no default value
D
None of the mentioned
Explanation: 

Detailed explanation-1: -Explanation: If we have not specified any sorting with the ORDER BY clause, SQL always uses the ASC as a default sorting order.

Detailed explanation-2: -When ASC or DESC keyword is not specified, the ORDER BY clause sorts the records in ascending order.

Detailed explanation-3: -The ASC keyword is used to sort the query result set in an ascending order. The default for ORDER BY when nothing has been explicitly specified is ASC.

Detailed explanation-4: -If you don’t specify ASC or DESC, PostgreSQL will assume you want to see results: in ascending order.

Detailed explanation-5: -By default, SQL Server sorts out results using ORDER BY clause in ascending order.

There is 1 question to complete.
Previous
Next