Below are the questions that were asked during my recent interview: SQL Query: I have two tables, User and Role. Could you provide a SQL query to join these tables and display all user data along with their respective role names from the Role table? Java 8 Features: Can you outline the key features introduced in Java 8? Stream API in Java: In a scenario where a User entry includes a reference variable to the Role class and a userList, how can we use the Stream API to print the role name along with the total number of users associated with that role? Multithreading: i didn't have much experience on multithreading so i told the same to them so they didn't ask Spring: What is spring profile?