Netcracker Technology interview question

SQL Queries, Collection,Logical Question ,Core Java