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

Q. Which of the following index operations require no additional disk space?

View solution

Q. Which of the following index operation require additional disk space?

View solution

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