Instead Trigger Insert Created Employee Table Employee Table 10 Rows Run One Insert Statem Q37055992

An INSTEAD OF trigger for the INSERT is created on the employeetable. the employee table has 10 rows. you run one insert statementthat inserts 5 rows in the table. inside the trigger you count howmany rows are in the INSERTED table. What is the result

a. 0

b. 1

c. 5

d. 10

e. 15

Solution

Answer 15:

as we are counting the number of rows in the inserted tables soonce we inserted 5 statements count be will 15 as news rows 5 + oldrows are 10