PwC interview question

Asked only two question about Referential Integrity and Window function