Which function can you use with ORDER BY clause to specify custom sort order ?

(a) SORT()

(b) CUSTOM()

(c) FIELD()

(d) All of these

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

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

To create summary results, …………… clause is used.

1. SORT BY
2. SUMMARY 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