Bright Tutorials Bright Tutorials
CBSE Class 11 Informatics Practices Question 6 of 87

Structured Query Language (SQL) — Question 6

Back to all questions
6
Question

Question 6

Assertion (A): ORDER BY clause is used to sort the records of a table.

Reasoning (R): SQL provides two keywords for sorting in ascending and descending orders, ASC and DESC.

  1. Both A and R are true and R is the correct explanation of A.
  2. Both A and R are true but R is not the correct explanation of A.
  3. A is true but R is false.
  4. A is false but R is true.
Answer

Both A and R are true and R is the correct explanation of A.

Explanation
The SQL ORDER BY clause is used to sort the data is ascending or descending order based on one or more columns. This clause sorts the records in ascending order (ASC) by default. To sort the records in descending order, DESC keyword is used.