OCP 11g试题解析：1Z0-051-048题

OCP 11g试题解析：1Z0-051-048题，完整题库请点击这里联系老师咨询了解

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

试题解析：

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

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

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

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