7.0k views
2 votes
Which of the following is NOT a feature of unclustered index

A. There can be several unclustered indexes on a data file
B. unclustered indexes are cheap to maintain and update
C. un Clustered index has the same ordering of data records as that of the data entries in the database
D. unClustered index has a different ordering of data records as that of the data entries in the database​

User Rootart
by
5.1k points

1 Answer

3 votes

Answer:

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

Step-by-step 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.

User Payam Roozbahani
by
5.4k points