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:同一个字段上可以创建不止一个索引,如果指定不同的字段组合(正确)
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:同一个字段上可以创建不止一个索引,如果指定不同的字段组合(正确)