Which of the following values specifies that each instance of the XML data type in column_name can contain multiple top-level elements?

Analyze the following code snippet for creating a stored procedure in SQL Server 2008: CREATE PROCEDURE Person.GetEmployees @LastName nvarchar(50), @FirstName nvarchar(50) AS SET NOCOUNT ON SELECT FirstName, LastName, JobTitle, Department FROM Person.EmployeeDepartment WHERE FirstName = @FirstName AND LastName = @LastName GO Which of the following is a valid code to execute the GetEmployees stored procedure?

Which default password is used by sqlcmd if -P option is used at the end of the command prompt without a password?

Which clauses of SQL Server 2008 avoids enforcing a constraint when repeated inserts are performed?

Analyze the following code snippet: DECLARE @myDate DATETIME2 SELECT @myDate = '2009/10/08 12:35:29.2348 +12:15' SELECT @myDate AS '@myDate' What is the output of the above code?

Which counters are used to monitor compression of the whole instance of SQL Server?

The international Cospas-Sarsat SAR (Search and Rescue) satellite system has ceased satellite processing of __________________ MHz frequency beacons on or after February 2009.

Which V speed represents the speed indicated by the red mark in the airspeed indicator shown above?

What is the first step in mollifying a customer who has received bad service?

What is the importance of customer oriented goodwill?

John takes a loan from his friend on an amount of Rs.1400 at the rate of 6% p.a. What will be the simple interest for one year on this amount?