iQuanti interview question

Scenario based SQL questions, SCD type 2 implementation using SQL.