Which of the following is not a Method call of .NET class for Assemblies in the SQL Server?

What is wrong with the following query in accordance with performance? SELECT * FROM [Table_Name] WHERE LOWER(Field_Name) = 'name'

How can you change 'Hansen' into 'Nilsen' in the LastName column in the Persons Table?

Examine the code given below: SELECT employee_id FROM employees WHERE commission_pct=.5 OR salary > 23000 Which of the following statements is correct with regard to this code?

___________  is the highest level of a transaction isolation implemented by SQL Server.

Which query will display data from the Pers table relating to Analysts, Clerks and Salesmen who joined between 1/1/2005 and 1/2/2005?

What is the default timeout for login to sqlcmd while you try to connect to a server?

Which of the following is a valid code to delete a clustered index with a PRIMARY KEY constraint in SQL Server 2008?

Windows Security log can be specified as a target for Audit in SQL Server 2008.

How many groupings are generated when CUBE is used with the GROUP BY clause of SQL Server 2008?

Which of the following features of SQL Server 2008 evaluates servers for compliance with a set of predefined conditions and prevents making undesirable changes to servers?