Between the statements below, which best describes Triggers in MySQL?

How are the OLD and NEW notations used in MySQL Triggers?

Which of the following is the least fitting situation to use a MySQL Trigger?

Which of the following statements is incorrect regarding the MySQL code below?

CREATE TRIGGER log_product_update

    BEFORE UPDATE ON product_list

    FOR EACH ROW 

 INSERT INTO product_change_history

 SET action = ‘update’,

     product_id = OLD.product_id,

     product_name = OLD.product_name,

     date_time_changed = NOW();

Which of the following is true regarding the MySQL Code below?

CREATE TRIGGER account_update

    AFTER UPDATE ON account

    FOR EACH ROW 

 INSERT INTO account_history

 SET action = ‘update’,

     account_id = OLD.account_id,

     account_name_before = OLD.account_name,

account_name_after = NEW.account_name,

     date_time_changed = NOW();

Which of the following is the proper code to define a function that takes in a value that could have decimal points and provides an output that is a whole number?

Which of the following is the correct MySQL code to define a new variable within a function which is a number with decimal points.

What does DETERMINISTIC mean in relation to MySQL functions?

Which of the following is not a benefit of using MySQL views?

Which of the following is correct in regards of the MySQL code below?

CREATE VIEW allDrivers AS

SELECT 

    run.run_id, run.run_date, run.run_distance, driver.driver_id, driver.driver_name

FROM

    run

        INNER JOIN

    driver ON run.driver_id = driver.driver_id

ORDER BY run.run_date ASC;

When the driver_id is defined as an INT, which of the following MySQL statements below will give different result compared to the others?

Which of the following is the correct way to output a float down to the second decimal point and ignore the rest?