
Ultimate access to all questions.
An organization stores employee salaries in the emp_sal delta table. The requirement is to keep track of both the last and current salary of all employees without increasing the number of rows in the table. Which type of table should be selected to meet this requirement?_
A
Type 1 SCD – The old record is overwritten by the new record.
B
Type 3 SCD – Changes are tracked using column addition. A new column is added for the current value while the original value is retained.
C
Type 0 SCD
D
Type 2 SCD – The new record is appended to the table whereas the old record is set to not-active either by using the end_date or active column._
E
Type 4 SCD