you have a table named employees with the following structure empid int..., MS SQL Server 2005, Databases

MS SQL Server 2005

Test
- Model Test
Index

Question:You have a table named "employees" with the following table structure:
empid                int(4)
deptname            varchar(50)
salary                int(4)

The following select query is executed on this table:
SELECT * FROM employees ORDER BY deptname DESC, salary DESC
What will be the output of the above query?

A The above SQL query will give an error 
B Records will be shown with the salary field displayed in the descending order 
C Records will be shown with the deptname field in the ascending order and salary in the descending order 
D Records will be shown with the deptname field and the salary field in the descending order 
E Records will be shown in a jumbled manner

/76

+ AnswerD

+ Report

Descriptive on MS SQL Server 2005 Ebook

Total Preview: 615

Question:You have a table named "employees" with the following table structure: empid int(4) deptname varchar(50) salary int(4) The following select query is executed on this table: SELECT * FROM employees ORDER BY deptname DESC, salary DESC What will be the output of the above query?

A The above SQL query will give an error

B Records will be shown with the salary field displayed in the descending order

C Records will be shown with the deptname field in the ascending order and salary in the descending order

D Records will be shown with the deptname field and the salary field in the descending order

E Records will be shown in a jumbled manner

D