Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
|
Question 585
|
A clustering index is created when _______.
|
primary key is declared and ordered
|
|
|
no key ordered
|
|
|
foreign key ordered
|
|
|
there is no key and no order
|
Question 585 Explanation:
→ A Clustering index is created when primary key is declared and ordered. Clustering index is defined on an ordered data file. The data file is ordered on a non-key field.
→ Ordered Indexing is of two types −Dense Index and Sparse Index.
→ Ordered Indexing is of two types −Dense Index and Sparse Index.
Correct Answer: A
Question 585 Explanation:
→ A Clustering index is created when primary key is declared and ordered. Clustering index is defined on an ordered data file. The data file is ordered on a non-key field.
→ Ordered Indexing is of two types −Dense Index and Sparse Index.
→ Ordered Indexing is of two types −Dense Index and Sparse Index.