Which of the following are correct?

We have a table named 'Customer' which has a column named 'Customerid' having datatype Integer. We need to fetch the output with column title: 'Customer id is (value of customerid from the table)'. What will be the query?

Which of the following statements is wrong?

The table Comments has an auto incremented column called 'Commentid' and a 'UserComments' column, both of which store the comments of the users visiting the site. What will be the correct query to display the latest comments first?

Consider the following table: Order - - - - - Orderid Customerid Orderdate Comments Select ISNULL (Comments, 'No comments') AS comments From Order What will be the output of the above query?

What is the maximum storage capacity of XML data type in SQL SERVER 2005?

What is the 'WITH RECOMPILE' statement used for?

Which of the following allows you to modify (update or delete) all values of the parent table?

What is the name of the service that provides ETL capabilities for SQL Server for data import, data integration and data warehousing needs?

When creating indexes in SQL, what two main factors must be considered?

What is a 'CROSS APPLY' used for?