MSCI Associate Consultant Interview Questions and Answers

Q1. What are joins in sql
Ans. 
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
• Joins are used to retrieve data from multiple tables based on a related column

• Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
Answered by AI
Add your answer
Q2. What is OOP features
Ans. 
OOP features are key concepts in Object-Oriented Programming that include encapsulation, inheritance, polymorphism, and abstraction.
• Encapsulation: Bundling data and methods that operate on the data into a single unit (object)

• Inheritance: Ability for a class to inherit properties and behavior from another class

• Polymorphism: Ability for objects to be treated as instances of their parent class or their own class

• Abstractio...read more
Answered by AI
Add your answer
Q3. Primary key , foreign key
Add your answer
Q4. Exception in java
Ans. 
An exception in Java is a runtime error that disrupts the normal flow of a program.
• Exceptions are objects that are thrown when an error occurs during the execution of a program.

• They can be caught and handled using try-catch blocks.

• Common types of exceptions in Java include NullPointerException, ArrayIndexOutOfBoundsException, and IOException.
Answered by AI
Add your answer

Q1. This was based on my previous exp in the cloud and the services I have worked with.
Add your answer

Q1. Please briefly explain your fitment to the current JD
Add your answer
Q2. Explained about the fitment and in terms of Stong Areas and exposure to areas where fitment wasnt 100%
Add your answer

A case study of providing a technical solution to an enterprise design challenge. an hour time was given to prepare for the selection of tools and prepare for the presentation. After the hour passed presented my solution and multiple options/tools to achieve the functionality. Cross questions were done to ascertain the depth of solution provided and scalability aspect of the same.

Q1. Behavioral and organizational awareness questions were asked. Real-life challenges were put in terms of checking the awareness of boundaries for technical architecture, product owners, and operational area...read more
Add your answer

Q1. What are the salary expectations, notice period tenure and possibility for reducing the notice period. Reasons for change and what is the guarantee of you joining once the offer letter is released and you ...read more
Add your answer

There was an aptitude test which consisted of English,Logical Reasoning and Quantitative all with 60 Questions in 60 Minutes. There were also 2 easy to medium level codes on Arrays.

Q1. First they asked to introduce yourself , then they directly started with Technical question in which they gave me 2 codes. 1.Reverse a given sentences maintaining spaces ,2. Write a code for simple calcula...read more
Add your answer

Test on HackerRank, Some MCQs related to programming concepts and 1 coding question (Leetcode Easy) level

Q1. Basic Programming Questions, Fundamentals of DBMS, OS and Basic DSA Questions
Add your answer

Q1. Basic HR Questions
Add your answer

It was basic aptitude test on rs aggrawal

Q1. Try catch exception handling
Add your answer

Q1. Where do you live
Add your answer