SQL Order By Clause MCQ

Test your knowledge with important SQL Order By Clause MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30 + more SQL Order By Clause MCQs at Bissoy

• Which of the following order is valid and yields correct results in SQL?
  ক

  Select, from, order by, where

  খ

  Select, from, where, order by

  গ

  Select, order by, from

  ঘ

  From, order by, where
• When sorting the result set using the SQL ORDER BY clause, we can use ___________ attributes in a single SELECT statement.
  ক

  Only Asc not Desc

  খ

  Only Desc not Asc

  গ

  None of Asc and Desc

  ঘ

  Both Asc and Desc
• To sort the result with respect to multiple columns, they must be separated using ____
  ক

  |

  খ

  ,

  গ

  ;

  ঘ

  _
• Which of the following can be used with the ORDER BY clause in place of column name?
  ক

  Row name

  খ

  Table name

  গ

  Column position in the columns list

  ঘ

  Attribute name
• Aliases defined in the SELECT Statement can be used in ORDER BY Clause.
  ক

  True

  খ

  False
• The columns specified in ORDER BY clause may or may not be the columns specified in the SELECT column list.
  ক

  True

  খ

  False
• Which one of the following sorts rows in SQL?
  ক

  Sort By

  খ

  Align By

  গ

  Group By

  ঘ

  Order By
• To sort the records in descending order, which keyword is used?
  ক

  Descend

  খ

  Increase

  গ

  Desc

  ঘ

  Order
• What is the default ordering of data using ORDER BY clause?
  ক

  Descending order

  খ

  Random order

  গ

  Ascending order

  ঘ

  No change