Question

Pick up the correct statements of the following:
P: Primary index is sparse index.
Q: Only one clustered index is allowed per table.
R: Seconddary index is created on key field.
S: Secondary index is an ordered file.
T: Chustered index is created on non-key field.
U: Clustered index is dense index

• A. P, Q, U
• B. R, S, T
• C. P, Q, T
• D. S, T, U

Answer 1

The correct option is C P, Q, T

Secondary index is created either on Nonkey (or) Candidate key on unordered file.