IBM
C2090-312 · Question #35
C2090-312 Question #35: Real Exam Question with Answer & Explanation
Sign in or unlock C2090-312 to reveal the answer and full explanation for question #35. The question stem and answer options stay visible for context.
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
Unlock C2090-312 to see the answer
You've previewed enough free C2090-312 questions. Unlock C2090-312 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.