OCP-1Z0-051-V9.02-48题

48. 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. 

Answer: AD

答案解析：

参考： http://blog.csdn.net/rlhua/article/details/12780775

A正确，可以在表和簇上面创建索引。

B错误，不能再简单视图上创建索引

C错误，可以和别的列组合来创建别的索引。

D正确，通过指定不同列的组合来在同一列创建一个或多个索引，这是是正确的。