42. Which three statements are true regarding views? (Choose three.)
A. Views can be created only from tables.
B. Views can be created from tables or other views.
C. Only simple views can use indexes existing on the underlying tables.
D. Both simple and complex views can use indexes existing on the underlying tables.
E. Complex views can be created only on multiple tables that exist in the same schema.
F. Complex views can be created on multiple tables that exist in the same or different schemas.
Answer: BDF
A:只能从表中创建视图(错误,还可以从视图中创建视图)
B:视图可以从表或其他视图中创建(正确)
C:只有简单视图可以使用基表中存在的索引(错误,复杂视图也可以使用索引)
D:简单视图和复杂视图都可以使用基表上存在的索引(正确)
E:复杂视图只能使用同一个schema下的多张表创建(错误,不同Schema下也可以)
F:复杂视图可以在多张表上创建,这多张表可以在相同或不同的schema下(正确)
A. Views can be created only from tables.
B. Views can be created from tables or other views.
C. Only simple views can use indexes existing on the underlying tables.
D. Both simple and complex views can use indexes existing on the underlying tables.
E. Complex views can be created only on multiple tables that exist in the same schema.
F. Complex views can be created on multiple tables that exist in the same or different schemas.
Answer: BDF
A:只能从表中创建视图(错误,还可以从视图中创建视图)
B:视图可以从表或其他视图中创建(正确)
C:只有简单视图可以使用基表中存在的索引(错误,复杂视图也可以使用索引)
D:简单视图和复杂视图都可以使用基表上存在的索引(正确)
E:复杂视图只能使用同一个schema下的多张表创建(错误,不同Schema下也可以)
F:复杂视图可以在多张表上创建,这多张表可以在相同或不同的schema下(正确)