Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

There are five employees in department 5 0 . A statement trigger is created by: CREATE OR REPLACE TRIGGER emp _ upd _ trigg AFTER

There are five employees in department 50. A statement trigger is created by: CREATE OR REPLACE TRIGGER emp_upd_trigg AFTER DELETE ON EMPLOYEES BEGIN ... A user now executes: DELETE FROM employees WHERE department_id =50; How many times will the trigger fire, and when? Once, before the DELETE is executed The trigger will not fire at all. Six times, once after each row and once at the end of the statement Once, after the DELETE is executed Five times, after each employee row is deleted

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Beginning ASP.NET 2.0 And Databases

Authors: John Kauffman, Bradley Millington

1st Edition

0471781347, 978-0471781349

More Books

Students also viewed these Databases questions