What does the Query Analyzer, or SQL Server Management Studio, tool do?

In regard to SQL Server Mirroring - A server instance can be a partner in some sessions and a witness in other sessions.

What does the 'IN' clause do?

What is the default port number for SQL Server?

Which of the following acts as the Database Engine's security system?

Which is the slowest?

Examine the data in the EMPLOYEES table given below: LAST_NAME DEPARTMENT_ID SALARY Allen 10 3000 Miller 20 1500 King 20 2200 Davis 30 5000 Which of the following sub-queries work?

You have a table named 'employees', having the following structure. empid int(4) deptname varchar(50) salary int(4) And a view is created as follows: create view viemployees as select * from employees You want to insert a new row into the table having the following values: empid=1010, deptname=HR, salary=10000. Which of the following are the correct insert SQL queries?

Which of the following statements regarding 'views' are incorrect?

Which of the following operators perform pattern matching?

Which of the following are the SQL Transaction statements?