Cognizant interview question

Opps concept DBMS SQL Basic coding