Q. The SORT_IN_TEMPDB option cannot be set for ________ statements.

View solution

Q. Which of the following query will disable the index on Employee table?

View solution

Q. The use of parameters, including parameter markers in _______ applications, can increase the reuse of execution plans.

View solution

Q. Point out the correct statement.

View solution

Q. Use to bind an integer variable to the first parameter marker in an SQL statement.

View solution

Q. Which of the following query cannot be parameterized according to the rules of forced parameterization?

View solution

Q. Point out the wrong statement.

View solution

Q. Which of the following SQL Server SQL Statistics counter represents number of auto-parameterization attempts per second?

View solution

Q. The maximum size for all caches is a function of the ________ size.

View solution

Q. The conditions that invalidate a plan include which of the following?

View solution

Q. What is the syntax for DBCC FREEPROCCACHE with all the optional parameters in T-SQL?

View solution

Q. _________ uniquely identifies a query plan for a batch that has executed and whose plan resides in the plan cache.

View solution

Q. The INSERT, UPDATE, or DELETE statement fails if the OLE DB provider used to access the linked server does not support the _________ interface.

View solution

Q. Point out the correct statement.

View solution

Q. __________ marks the end of a successful implicit or explicit transaction.

View solution

Q. What is the syntax for COMMIT WORK statement in transaction?

View solution

Q. Point out the wrong statement.

View solution

Q. ____________ rolls back a user-specified transaction to the beginning of the transaction.

View solution

Q. Which of the following is valid syntax for SAVE TRANSACTION with all the optional parameters?

View solution

Q. In _______ transaction we include the DML statements that need to be executed as a unit.

View solution