Cognizant interview question

Asked about SQL joins and sub query and asked about working of hashmap in java