A clustering index is defined on the fields which are of type
Pick an option to check yourself, or open the answer below.
Show answer & explanation
Correct answer: A. non-key and ordering
Explanation
A clustering index is built on an ordering field that is not a key (values repeat).
More Database Management Systems questions
- In RDBMS, which type of Join returns all rows that satisfy the join condition ?
- Consider a relation book (title, price) which contains the titles and prices of different books. Assuming that no two books have the same p…
- In a Hierachical database, a hashing function is used to locate the ________.
- Relations produced from E - R Model will always be in ________.
- Consider the following schedules involving two transactions: S₁: r₁(X); r₁(Y); r₂(X); r₂(Y); w₂(Y); w₁(X) S₂: r₁(X); r₂(X); r₂(Y); w₂(Y); r…
- For a database relation R(a, b, c, d) where the domains of a, b, c and d include only atomic values, and only the following functional depe…