adplus-dvertising
frame-decoration

Question

Point out the correct statement.

a.

The Database Engine merges the sorted runs of index leaf rows into a single, sorted stream

b.

SQL Server also supports full-text indexes and XML indexes, but those are relevant only for specific data types

c.

The fill-factor value is a percentage from 1 to 50

d.

All of the mentioned

Answer: (a).The Database Engine merges the sorted runs of index leaf rows into a single, sorted stream

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. Point out the correct statement.

Similar Questions

Discover Related MCQs

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

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

Q. Point out the wrong statement.

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

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

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

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

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

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

Q. Point out the correct statement.

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

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

Q. Point out the wrong statement.

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

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

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

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

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

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

Q. Point out the correct statement.