Which two statements are true regarding indexes? (Choose two.)
A.
They can be created on tables and clusters.
B.
They can be created on tables and simple views.
C.
You can create only one index by using the same columns.
D.
You can create more than one index by using the same columns if you specify distinctly different combinations of the columns.
what is “cluster”?
Why is A correct and not B
A table cluster is a group of tables that share common columns and store related data in the same blocks. When tables are clustered, a single data block can contain rows from multiple tables. For example, a block can store rows from both the employees and departments tables rather than from only a single table.
According to SQL fundamentals I: you can’t index the same column twice even if you want to. So C is correct.
Ah, “same columns”. So C is incorrect.