ocp 11g試題解析：1Z0-051-041題
最新學訊：近期OCP認證正在報名中，因考試人員較多請盡快報名獲取最近考試時間，報名費用請聯系在線老師，甲骨文官方認證，報名從速！
我要咨詢ocp 11g試題解析：1Z0-051-041題，完整題庫請點擊這里聯系老師咨詢了解
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.
Answer: CD
試題解析：
A錯誤，創建視圖的子查詢可以使用group by子句。
B錯誤，子查詢中帶有DISTINCT 不能對視圖進行DML操作。
C正確，子查詢中帶有ROWNUM 關鍵字不能對視圖進行DML操作。
D正確，所有非空列都可以進行DML操作。
