edited by
1,295 views
1 votes
1 votes

A file is organized so that the ordering of data record is same as or close to the ordering of data block in some index. Then that index is called:-

  1. Dense
  2. Sparse.
  3. Clustered
  4. Unclustered
edited by

3 Answers

Best answer
4 votes
4 votes

Answer : C

A Clustered index is a special type of index that reorders the way records in the table are physically stored. Therefore table can have only one clustered index. With a clustered index the rows are stored physically on the disk in the same order as the index.  You can have only one clustered index per table because this defines how the data is physically arranged. A clustered index means you are telling the database to store close values actually close to one another on the disk. This has the benefit of rapid scan / retrieval of records falling into some range of clustered index values.

A clustered index created on any key column(s)  will enforce an ordering on the rows of table. All the rows will be stored in sorted manner on the key column used to create the clustered index.

Say You want to make an Index on some Ordered field then you can make either Sparse or Dense Index. No problem. We can Always make Dense index for any field(s).

selected by
0 votes
0 votes
  • Option a is right . It is a defination of dense .
0 votes
0 votes

in my point of view, { Dense, Sparse } and { key, non-key } both are different sets 

we use

1) key + file is ordered by key ===> uses Sparse Index ===> Primary Index

2) non-key+ file is ordered by non-key ===> uses Sparse Index ===> Clustered Index

3) non-key+ file is not ordered by non-key ===> uses Dense Index ===> Non-Clustered Index

4) key+ file is not ordered by key ===> uses Dense Index ===> Secondary Index


 ordering of data record is same as or close to the ordering of data block in some index it can be primary index or clustered index

Related questions

0 votes
0 votes
0 answers
1
2 votes
2 votes
1 answer
3
3 votes
3 votes
1 answer
4
Na462 asked Jan 26, 2019
1,812 views