Answered step by step
Verified Expert Solution
Link Copied!

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 JOB_ID is updated, we want to insert a row into a logging table to record the employee_id and the new value of JOB_ID. We create a row trigger whose body includes the following code: BEGIN INSERT INTO logging_table (emp_id, job_id) 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.employee_id, :NEW.job_id); (:OLD.employee_id, :OLD.job_id); (:NEW.employee_id, :OLD.job_id); (:NEW.employee_id, :NEW.job_id); (NEW.employee_id, NEW.job_id);

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 Databases With PostgreSQL From Novice To Professional

Authors: Richard Stones, Neil Matthew

2nd Edition

1590594789, 978-1590594780

More Books

Students also viewed these Databases questions