Which two statements are true regarding indexes?

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.

Discussion

5 Responses to “Which two statements are true regarding indexes?”

  1. leo says:

    what is “cluster”?

  2. roxi says:

    Why is A correct and not B

  3. youyou says:

    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.

  4. davor says:

    According to SQL fundamentals I: you can’t index the same column twice even if you want to. So C is correct.

Leave a Reply