Suppose an Employee's Date of Hire Is Changed in an Employee

question 19

Multiple Choice

Suppose an employee's date of hire is changed in an employee table.When a database user subsequently runs a report showing the number of years the employee has worked for the company (a calculated field) , what will happen?

• A)Nothing.The same value that was calculated in any prior report will continue to show in the new report
• B)The new report will show a new calculated value
• C)The new report will show the average of the original value and the new value
• D)This depends upon other settings not indicated in the statement