Which two statements are true regarding indexes?

Which two statements are true regarding indexes? (Choose two.)

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.



Leave a Reply 5

Your email address will not be published. Required fields are marked *


leo

leo

what is “cluster”?

roxi

roxi

Why is A correct and not B

youyou

youyou

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.

davor

davor

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

davor

davor

Ah, “same columns”. So C is incorrect.