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

Question

Quizplus · Accepted Answer

The new report will show a new calculated value because the calculation of the number of years worked is based on the date of hire. If the date of hire is changed, the calculation will reflect this change and produce a new value.

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