Q. Which of the following is valid syntax for SET STATISTICS XML?

View solution

Q. __________ returns detailed information about how the statements are executed.

View solution

Q. The way that a statement can be physically executed is called _____________

View solution

Q. SET SHOWPLAN_TEXT is intended to return readable output for ________ utility.

View solution

Q. Setting the SORT_IN_TEMPDB option to ON can direct the SQL Server Database Engine to use ________ to store the intermediate sort results.

View solution

Q. Point out the correct statement.

View solution

Q. Which of the following rebuilds the IX_Employee_OrganizationLevel_OrganizationNode index with a fill factor of 80 on the HumanResources.Employee table?

View solution

Q. Which of the following guideline is considered during column design?

View solution

Q. Point out the wrong statement.

View solution

Q. By default, indexes are stored in the ______ filegroup as the base table on which the index is created.

View solution

Q. Specifying the order in which key values are stored in an index is useful when queries referencing the table have _____________

View solution

Q. Every table should have a ________ index defined on the column or columns.

View solution

Q. Which of the following option is immediately applied to the index by using the SET clause in the ALTER INDEX statement?

View solution

Q. Which of the following code snippet demonstrates ALTER statement with STATISTICS_NORECOMPUTE in ONLINE state?

View solution

Q. Which of the following query is used to enable a disabled index using CREATE INDEX?

View solution

Q. Point out the correct statement.

View solution

Q. Which of the following query enables the IX_Employee_OrganizationLevel_OrganizationNode index on the Employee table?

View solution

Q. Which of the following query can enable all indexes on Employee table?

View solution

Q. Point out the wrong statement.

View solution

Q. Which of the following query disables all the indexes on Employee table?

View solution