By default, ORDER BY clause lists the results in …………… order.

1. Descending
2. Any
3. Same
4. Ascending

Which one of the following would arrange the rows in ascending order in SQL ?

1. SORT BY
2. ALIGN BY
3. GROUP BY
4. ORDER BY

Consider the following query

SELECT * FROM employee ORDER BY salary ..............., name ...............;

To display the salary from greater to smaller and name in alphabetical order which of the following options should be used ?

1. Ascending, Descending
2. Asc, Desc
3. Desc, Asc
4. Descending, Ascending

Select correct SQL query from below to find the temperature in increasing order of all cities.

1. SELECT city FROM weather ORDER BY temperature ;

2. SELECT city, temperature FROM weather ;

3. SELECT city, temperature FROM weather ORDER BY temperature ;

4. SELECT city, temperature FROM weather ORDER BY city ;