S&P Global Associate Software Engineer 2 Interview Questions and Answers for Experienced

Q1. How is GIL and how python handle multi threading
Ans. 
GIL stands for Global Interpreter Lock in Python, which limits execution of multiple threads at once.
• GIL is a mutex that protects access to Python objects, preventing multiple threads from executing Python bytecodes at once.

• Due to GIL, Python threads are not suitable for CPU-bound tasks but are still useful for I/O-bound tasks.

• To handle multi-threading in Python, one can use multiprocessing module or asynchronous progr...read more
Answered by AI
Add your answer
Q2. Explain How React works under the hood.
Ans. 
React uses a virtual DOM to efficiently update the actual DOM based on changes in state or props.
• React creates a virtual DOM representation of the actual DOM.

• When state or props change, React compares the virtual DOM with the actual DOM to determine the minimal set of changes needed.

• React then updates the actual DOM efficiently to reflect the changes.
Answered by AI
Add your answer

Apt + coding questions, medium difficulty

Q1. Basics qs on oops and known programming language
Add your answer

Q1. In-depth of oops and live coding questions
Add your answer

Q1. Basics qs like y and what
Add your answer

Q1. On manual and automation testing
Add your answer

Q1. What are joins, given 2 tables, join them
Ans. 
Joins are used to combine data from two or more tables based on a related column between them.
• Use JOIN keyword followed by the name of the table to join

• Specify the columns to be selected using SELECT keyword

• Use ON keyword to specify the related column between tables

• Types of joins: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id
Answered by AI
Add your answer
Q2. All C# OOPS Concepts, Inheritance, Overriding and Overloading
Add your answer

Basic ds algo round with questions asked around arrays strings

Group discussion communication one person to another person

Writing test Coding test one round

Case study HR discussion technically

Coding test Assignment technical

Assignment Only round and case study

Q1. Technical Assignment technical
Add your answer

Q1. Technical Group discussion
Add your answer

Q1. Other Group discussion communication
Add your answer

HR Discussion technically HR technically

Case study Only round Communication

Q1. One on One round
Add your answer

Group discussion One one round

Assignment Disscuss one on one round

Apptitude Group discussion one on round assignment case study technical

Q1. Technical One on round
Add your answer
Q2. Aptitude test case study
Add your answer
Q3. HR discussion Apptitude test
Add your answer

1st Round is Up to an hr in that we have to perform Coding as per the test provided & also SQL round involve in it we have to show as output as per the test is concerned to provide valid outputs.

2nd round was an aptitude test of 90 mins it was like 100 Questions we have to solve and submit that it involved Logical Reasoning, Mathematical problems, Word Problems, etc.

Q1. Tell me about your projects and what you have done in your previous company.
Add your answer
Q2. On basis of Projects, the Technical questions that were asked, and also other situations given on that basis what I will do in the Logical process need to explain the steps.
Add your answer
Q3. Basics Of Java OOPs Concepts Questions
Add your answer