What is default sorting order when you use "ORDE

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is default sorting order when you use "ORDER BY" clause in a query statement?

The "ORDER BY column" clause will sort the query result by the value of the given column in ascending order by default. If you want to change the sorting order to descending order, you can the "ORDER BY column DESC" clause.

(Continued on next question...)

Other Job Interview Questions

• What is an Index in MS SQL Server?
• What is the meaning of the following T-SQL command: SELECT * FROM users WHERE first_name LIKE 'M%'
• What does RDBMS stand for?
• Is it true that MS SQL Server is sharing work load between the server and client computers?
• What is the meaning of the following T-SQL command: DBCC SHRINKDATABASE ( Database, 10%)
• What is the size of an Extent in MS SQL Server?
• What is the main limitation of the MS SQL Server Developer Edition?
• What is the meaning of the following T-SQL command: CREATE TABLE orders ...
• What is the T-SQL command to create a new login in MS SQL Server?
• What is "bcp"?
• More...