Domanda di colloquio di [24]7.ai

Round 3: F2F 1. Brief About myself. 2. Java Program to Sort students marks. If their marks are the same sort them by their names in alphabetical order. 3. Java Program to read a file and print the duplicated words with their count. 4. SQL Query to group the employee id by their departments and sort them in descending order by their department id. 5. SQL Query to find the managers of the employees where the employee id, employee name, and the manager id is given. 6. How will you feed the values of JSON requests of POST type for an API without reading excel sheet or Database - By the response of other APIs interacting to the current API. 7. How will you supply the value of the current response to the other API's input? 8. For a site like Amazon, how will you validate a search result which gives 1000s of results? 9. What is the difference between Inner Join and Self Join? Can you perform an inner join in the same table?