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?

A.
No, an UPDATE statement against the EMPD view is not allowed at all.

B.
Yes, the view EMPD can be updated directly via an UPDATE statement.

C.
No, only a clone of the view EMPD can be updated via an UPDATE statement.

D.
Yes, an UPDATE statement against the EMPD view is allowed if an INSTEAD OF trigger is
defined on the view.

Explanation: