Question

Which of the following is NOT a feature of unclustered index

Answer 1

Answer:

C. Unclustered index has the same ordering of data records as that of the data entries in the database

Explanation:

Indexes are used to split up queries in an SQL server or database management system DBMS.

There are two types of indexes namely clustered indexed and unclustered indexes.

Clustered indexes define the order in which data is stored in a table while unclustered index does not sort the order in a table.

In an unclustered index, the data table and the index are stored in different places, they are easy to maintain and update since they do not follow a particular order and there can be several indexes in a data file since the data table is stored differently from the index file.

So, all the other options except C are features of unclustered indexes since  unclustered index does not have the same ordering of data records as that of the data entries in the database.

So, C is the answer.