IBM
C2090-312 · Question #35
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…
The correct answer is D. Yes, an UPDATE statement against the EMPD view is allowed if an INSTEAD OF trigger is. See the full explanation below for the reasoning.
Question
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?
Options
- ANo, an UPDATE statement against the EMPD view is not allowed at all.
- BYes, the view EMPD can be updated directly via an UPDATE statement.
- CNo, only a clone of the view EMPD can be updated via an UPDATE statement.
- DYes, an UPDATE statement against the EMPD view is allowed if an INSTEAD OF trigger is
How the community answered
(28 responses)- A14% (4)
- B4% (1)
- C7% (2)
- D75% (21)
Community Discussion
No community discussion yet for this question.