Examine the trigger heading: CREATE OR REPLACE TRIGGER salary_check BEFORE UPDATE OF sal, job ON emp FOR EACH ROW Under which condition does this trigger fire?

Question

Options

• Awhen a row is inserted into the EMP table
• Bwhen the value of the SAL or JOB column in a row is updated in the EMP table
• Cwhen any column other than the SAL and JOB columns in a row are updated in the EMP table
• Donly when both values of the SAL and JOB columns in a row are updated together in the EMP table

• B
  81% (17)
• C
  5% (1)
• D
  14% (3)

No community discussion yet for this question.