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?

Which edition of the SQL SERVER 2005 will best meet the following scenario? A company has an online shopping website named www.shoppingxyz.com. It also has to handle its line of business portion. Its main server supports 4 CPUs and a multi-core processor.

State whether True or False. While using the Select query, the IN clause is a better choice than the EXIST clause.

Consider the following table structure of employees: empid int(4) deptname varchar(50) salary int(4) Which query will be used to display the Department (deptname) that is giving the maximum salary?

State whether True or False. Many-to-One is a type of relationship in RDBMS.

State whether True or False. You can send emails through the Database engine.

In this statement, 'SELECT * FROM employees e JOIN timesheets t ON t.employeeid = e.employeeid ', the JOIN term is the same as:

Data Transformation Services do what?

a FOREIGN KEY constraint can reference a UNIQUE constraint

Which of the following is a benefit of SQL Server replication?

What is the basic difference between varchar and nvarchar?