PwC Interview Question

Asked only two question about Referential Integrity and Window function