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 of the following operators perform pattern matching?

What is CTE

A sysadmin user is allowed to perform what actions?

What is a cursor in SQL Server?

Which is the slowest?

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