MSCI Interview Questions, Process, and Tips

Simple java questions, one coding question and one design question

Q1. What is visitor pattern?
Ans. 
Visitor pattern is a design pattern where a visitor class is used to perform operations on elements of a data structure.
• Visitor pattern allows adding new operations to existing classes without modifying them

• It separates the algorithm from the object structure on which it operates

• Commonly used in compilers, interpreters, and other complex systems
Answered by AI
Add your answer
Q2. You have a 2d array {{1,2},{1,3},{5,6}}. Calculate the sum of elements of 1st position in every array with Java 8.
Ans. 
Calculate sum of elements at 1st position in each array using Java 8.
• Use Java 8 stream to map each array to its 1st element and then sum them up.

• Example: {{1,2},{1,3},{5,6}} -> 1 + 1 + 5 = 7
Answered by AI
Add your answer
Q3. Design Thread collector class
Ans. 
Thread collector class to manage and organize threads in a system
• Create a ThreadCollector class with methods to add, remove, and retrieve threads

• Implement a data structure like a list or queue to store the threads

• Ensure thread safety by using synchronization mechanisms like locks or semaphores
Answered by AI
Add your answer
Q4. What is volatile?
Ans. 
Volatile refers to a type of memory storage that is temporary and can change frequently.
• Volatile memory loses its data when power is turned off, unlike non-volatile memory.

• Volatile memory is commonly used for temporary storage of data that needs to be quickly accessed and modified.

• Examples of volatile memory include RAM (Random Access Memory) in computers and cache memory in processors.
Answered by AI
Add your answer
Q5. Sql query to remove duplicates
Ans. 
Use the DISTINCT keyword in a SELECT statement to remove duplicates from a table.
• Use the SELECT DISTINCT statement to retrieve unique rows from a table.

• For example: SELECT DISTINCT column_name FROM table_name;

• Another way is to use the GROUP BY clause with the COUNT() function to remove duplicates.

• For example: SELECT column_name, COUNT(*) FROM table_name GROUP BY column_name;
Answered by AI
Add your answer

Q1. Why do you think you are fit for this role?
Add your answer
Q2. Why are you leaving your current company?
Ans. 
Seeking new challenges and opportunities for growth.
• Desire for new challenges and opportunities

• Looking for career advancement

• Seeking a more innovative and dynamic work environment
Answered by AI
Add your answer

Q1. Describe your projects
Add your answer
Q2. All about resume
Add your answer

Q1. What is normalisation
Add your answer
Q2. How is data stored in power BI
Add your answer

Q1. How did you write BRDs
Add your answer
Q2. What is the motivating and demotivating factor when joining a new organization
Add your answer

2 coding questions and 1 sql query question

Q1. LRU cache memory implementation using linked list
Add your answer
Q2. Sliding window coding question
Add your answer

Q1. Questions on projects
Add your answer

Q1. What is VAR? Methods of calculating VAR
Add your answer