Moody's Software Development Intern interview questions

Round 1: The Online Assessment was 1 hr long. It contained 15 MCQs based on computer fundamentals like OOPs, DBMS, OS and other debugging. The MCQs were basic to moderate level. Then there were 5 SQL queries to be written based on certain conditions. The SQL queries were moderate - difficult level. Then there were 2 DSA based questions. DSA questions were basic to moderate level only. Overall the questions in Online Assessment were testing accuracy and speed while the difficulty level was basic to moderate only. 25 students could make it through. Round 2: There were 2 people from Moodys side, the first being a director-level person and the other being a software engineer(SDE-2 level. The round started with a discussion on projects done and the exposure I had on the technological front. Then I was presented with a DSA question based on binary search and was expected to optimise it to the best. Pseudo code was expected from my end. Then the interviewer asked some DBMS and SQL basics and gave some SQL queries to be framed which were moderately difficult. At the end the interviewer asked some behavioural questions on why did I choose Tech sector to be my choice as a career and my goals for next 5 years. The interview ended. Result: 3 people got the offer and I was one of them.