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.

State whether True or False. The 'Having' clause can not be used when there is a 'Where' clause in the statement already.

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?

What is the default isolation level in SQL Server?