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

(a)
i hope u understand

Answer 2

Indexing is a technique to reduce the quantity of disk access times when a query gets processed.

An index is a data structure maintained to easily access the required data during query execution. There are two types of Indexing.

Clustered and Non Clustered Indexing.

The right thing about the indexing of a file in a database is it can have single clustered index with multiple secondary indexes. The answer is option A.