Auditors require that every change to an employee's salary is recorded automatically, with the old value, new value, user and time, whatever application makes the change. Which database feature suits this?

Les auditeurs exigent que chaque modification du salaire d'un employé soit enregistrée automatiquement, avec l'ancienne valeur, la nouvelle, l'utilisateur et l'heure, quelle que soit l'application qui fait la modification. Quelle fonction de la base convient ?

Answers

AA trigger on UPDATE of Staff that writes to an audit tableUn déclencheur sur UPDATE de Staff qui écrit dans une table d'audit

BA view on the Staff table that shows salaries in a different currencyUne vue sur la table Staff qui affiche les salaires dans une autre devise

CA CHECK constraint on SalaryUne contrainte CHECK sur Salary

DAn index on SalaryUn index sur Salary

The answer and explanation are in the full bank.

This question is one of 2,831 in the paid banks. Each comes with the correct answer and the reasoning behind it, not just a mark.

Unlock for 5,000 RWF

MIFOTRA exam practicealigned to Practice set: Database Management·2 marks·Medium

Auditors require that every change to an employee's salary is recorded automatically, with the old value, new value, user and time, whatever application makes the change. Which database feature suits this?

More Database questions