Which of the following statements is correct?

Which of the following clauses are not allowed in a single row sub-query?

What is the function of 'DBCC CHECKDB' command?

You have a table 'engineers' with the following table structure: enggid int(4) name varchar(50) salary int(4) You want to select the top 2 engineers in the decreasing order of their salaries, starting with the maximum salary. Which of the following SQL queries will fetch this data?

SQL SERVER 2005 provides a new feature to enable partitioning of the data in the database. But only those database objects can be partitioned which store data in the database. In accordance with the above statement, which of the following database objects can be partitioned?

Which of the following are the SQL Transaction statements?

Which clause would you use to perform conditional filtering on aggregate data in a query that uses 'GROUP BY'?

What is CTE

A sysadmin user is allowed to perform what actions?

What is a cursor in SQL Server?

Which is the slowest?