a) Clustered b) Non Clustered c) ...
View QuestionIn _______________ index instead of storing all the columns for a record together, each column is stored separately with all other rows in an index.
a) Clustered b) Column store c) Non clustered d) ...
View QuestionIf an index is _________________ the metadata and statistics continue to exists
a) Disabling b) Dropping c) Altering d) Both Disabling and Dropping Answer: a Explanation: ...
View QuestionWhat are composite indexes?
a) Are those which are composed by database for its internal use b) A ...
View QuestionDoes index take space in the disk?:
a) It stores memory as and when required b) Yes, Indexes ...
View QuestionWhat is true about indexes?
a) Indexes enhance the performance even if the table is updated frequently
View QuestionWhich one is true about clustered index?
a) Clustered index is not associated with table b) Clustered index is built by ...
View QuestionHow non clustered index point to the data?
a) It never points to anything b) It points to a ...
View QuestionWhat is the purpose of the index in sql server?
a) To enhance the query performance b) To provide an index to a record
View Question