View Exhibit 1 and examine the structure of the EMP and dept tables.
View Exhibit2 and examine the trigger code that is defined on the dept table to enforce the update and delete restrict referential actions on the primary key of the dept table.
What is the outcome on compilation?
A.
It compiles and executes successfully.
B.
It gives an error on compilation because it is not a row-level trigger.
C.
It gives an error on compilation because the exception section Is used in the trigger.
D.
It compiles successfully but gives an error on execution because it is not a row-level trigger.
B is correct. It has to be ROW LEVEL trigger, we can’t use NEW and OLD in statement level trigger.
B is correct.
Will get an error..
NEW and OLD references are not allowed on table level triggers.
B
B
B is correct
NEW and OLD should be in a row level trigger
Every when in a whilst we decide on blogs that we read. Listed below would be the most up-to-date sites that we decide on.
below you will obtain the link to some web pages that we consider you ought to visit
Here are a number of the web-sites we suggest for our visitors
The data talked about in the post are some of the best accessible
below youll come across the link to some web sites that we believe you ought to visit
Here is a great Weblog You may Obtain Interesting that we Encourage You
below youll discover the link to some websites that we feel you’ll want to visit
very couple of internet sites that take place to become comprehensive beneath, from our point of view are undoubtedly effectively really worth checking out
we came across a cool web-site that you may take pleasure in. Take a appear when you want
please take a look at the websites we adhere to, such as this 1, as it represents our picks in the web
we came across a cool website which you could possibly enjoy. Take a search in case you want
usually posts some quite intriguing stuff like this. If youre new to this site
usually posts some very exciting stuff like this. If youre new to this site
here are some links to websites that we link to because we believe they are worth visiting