Infosys Interview Question

star logic pl sql questions were from nowhere (never heard off)