Question

choose the correct option about the indexing of a file in database
a) It can have only one clustered index with multiple secondary indexes.
b) It can have multiple clustered indexes.
c) It can have both a primary and a clustered index.
d) All of the above.

Answer 1

i hope (d)
i hope u understand

Answer 2

The correct option is Option a).

The correct option about the indexing of a file in a database is it can have only one clustered index with multiple secondary indexes.

A clustered index can be created when the records in the file are to be sorted based on a non-key field unlike a primary index that is specified on an ordering key field in a set of already sorted records. Therefore, a file can have only either a primary index or a secondary index.