Changepond interview question

Trigger, sub queries, Mview