We are creating Stored Procedure in Database and using "sp_" prefix in its name. Which of the following statements is correct in accordance with the performance of the Stored Procedure execution?

Which of the following commands will be used to see the structure of the table named 'salary'?

Consider the following tables: Customers - - - - - - - - Customerid Customername Address Orders - - - - - Orderid Customerid Orderdate Comments What will be the query to fetch Customername and 1st Orderdate for order placed by each customer?

Which of the following 'insert queries' will be inserted in the XML field? The creation query of the table is: CREATE TABLE Branches(recordID int, description XML)

What will be the output of the following SQL query? SET SHOWPLAN_TEXT ON GO SELECT * FROM abcsite.abctable GO

Which of the following operators allows the specification of two or more expressions to be used for a query search?

Which of the following is not considered a Boolean Operator?

True or false: You can modify data in a table using a User Defined Function.

Microsoft SQL Server 2012 includes TRY_CAST() Function, what is the advantage of using this function

Which of the following aggregate functions are supported by the Transact-SQL language?