Question

To instruct Oracle11 g to sort data in ascending order, enter ____ after the column name in the ORDER BY clause.

Answer 1

Answer:

A. ASC

Explanation:

In Oracle11 g ORDER BY clause is used to sort data andit is also used in mysql ,ms access.Though we not to mention ASC to sort in increasing order because by default it sorts the data in ascending order if we do not mention ASC or DESC.To sort in descending order we have to mention DESC.

So the correct answer to this question is ASC.

Answer 2

Answer:A)ASC

Explanation: In Oracle11 g , there are certain ORDER BY clause which instruct the result to appear in the particular order. Some ORDER BY clause are for ascending order, descending order , selection of row or column etc.

The ascending order can be done using the command of ASC in ORDER BY clause and ASC will be considered as default if the order is briefly described.