Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Whenever an employee's JOB _ ID is updated, we want to insert a row into a logging table to record the employee _ id and
Whenever an employee's JOBID is updated, we want to insert a row into a logging table to record the employeeid and the new value of JOBID We create a row trigger whose body includes the following code: BEGIN INSERT INTO loggingtable empid jobid VALUES Point A END; At point A which of the following will insert the correct data into the logging table? Choose two.Choose all correct answers:OLD.employeeid :NEW.jobid; :OLD.employeeid :OLD.jobid; :NEW.employeeid :OLD.jobid; :NEW.employeeid :NEW.jobid; NEWemployeeid NEW.jobid;
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started