Which two statements are true regarding indexes? (Choose two.)
A.
You can create only one index by using the same columns.
B.
You can create more than one index by using the same columns if you specify distinctly
different combinations of the columns.
C.
They can be created on tables and simple views.
D.
They can be created on tables and clusters.
Check the comments here:
http://www.aiotestking.com/oracle/which-two-statements-are-true-regarding-indexes/
On clusters:
https://docs.oracle.com/cd/B19306_01/server.102/b14231/clustrs.htm
answer is not true!
Carefully read the question and answer accordingly.
Which two statements are true regarding indexes? (Choose two)
1)
They can be created on tables and clusters
2)
They can be created on tables and simple views.
3)
You can create only one index by using the same columns
4)
You can create more than one index by using the same columns if you specify distinctly different combinations of the columns
1 AND 4 ARE RIGHT OPTION.