OCP-1Z0-051 第41题 视图的注意事项

一、原题

Which two statements are true regarding views? (Choose two.)
A. A subquery that defines a view cannot include the GROUP BY clause.
B. A view that is created with the subquery having the DISTINCT keyword can be updated.
C. A view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updated.
D. A data manipulation language ( DML) operation can be performed on a view that is created with the subquery having all the NOT NULL columns of a table.

答案：CD

二、题目翻译

关于视图的描述哪两句话是正确的？（选择两个）
A. 定义视图的子查询不能包含GROUP BY子句。
B. 包含DISTINCT关键字的子查询建立的视图可以被更新。
C. 包含ROWNUM关键字伪列的子查询建立的视图不能被更新。
D. 包含表中所有非空列的子查询建立的视图可以执行DML操作。

三、题目解析

A选项不正确，视图可以包含GROUP BY子句，但包含了group by 子句的视图，不能进行DML操作。
B选项不正确，视图可以包含DISTINCT关键字，但包含DISTINCT关键字的视图不能被更新。
C选项正确，rownum是伪列，用户无法更新。
D选项正确。