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

a FOREIGN KEY constraint can reference a UNIQUE constraint

Data Transformation Services do what?

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

Differential backups do what?

What is the role of a processadmin user?

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. While using the Select query, the IN clause is a better choice than the EXIST clause.

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.

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 functions does the following SQL QUERY perform? DBCC CHECKIDENT ('table_name', RESEED, new_reseed_value)