Câu 42: C2090-612: DB2 10 DBA for zOS

Given the following view definition: CREATE VIEW EMPD AS (SELECT D.DEPTNAME, E. LASTNAME FROM DEPT D INNER JOIN EMP E ON D. DEPTNO =E.WORKDEPT); Can an UPDATE statement be used to update the view EMPD on joined tables DEPT and EMP?

1. A. No, an UPDATE statement against the EMPD view is not allowed at all.
2. B. Yes, the view EMPD can be updated directly via an UPDATE statement.
3. C. No, only a clone of the view EMPD can be updated via an UPDATE statement.
4. D. Yes, an UPDATE statement against the EMPD view is allowed if an INSTEAD OF trigger is defined on the view. — đáp án hiện tại