Cognizant Interview Question

Oops concepts and DBMS SQL query