Codemasters Interview Questions and Answers

Q1. What is the difference between Union and Union all ?
Ans. 
Union combines the results of two or more SELECT statements, while Union all includes all rows, including duplicates.
• Union removes duplicate rows from the result set, while Union all includes all rows.

• Union sorts the result set, while Union all does not.

• Union is slower than Union all because it performs a distinct operation.

• Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;

• Example: SELECT column1 FRO
Answered by AI
Add your answer
Q2. Which query is more faster , joins or union?
Ans. 
Joins are generally faster than unions.
• Joins are typically faster than unions because they combine data from multiple tables based on a common column, while unions combine data from multiple queries into a single result set.

• Joins can utilize indexes on the columns being joined, which can improve performance.

• Unions involve combining the results of multiple queries, which can be slower as it requires merging and sorting ...read more
Answered by AI
Add your answer

Q1. All related to domain javascript/react,
Add your answer
Q2. Fallback in lazy loading,optimization techniques/for API call
Ans. 
Fallback in lazy loading is important for optimizing API calls to ensure a smooth user experience.
• Implementing a loading spinner or placeholder while content is being loaded asynchronously

• Using a default value or cached data if the API call fails

• Implementing error handling to gracefully handle any issues with the API call
Answered by AI
Add your answer

For the coding test the question are related to array ,pattern , string , like palindrome, reverse of string 2nd last occurance of target element, 2 d arrays rotation so basically question are related to string and array.

Q1. Question related to oops like polymorphism ,virtual functions inheritance access modifiers objects classes, constructor etc .
Add your answer
Q2. Git and GitHub
Add your answer

Q1. Question were about ur projects detail description of projects
Add your answer
Q2. Question related to technologies used in projects
Add your answer

Coding test was of 1hr 20mins the test was totally on reactjs coding questions which consists of 22 questions , 10 mcqs 10 output based and 2 coding questions

Q1. React scenario based questions
Add your answer

Q1. Problem Solving on any product
Add your answer
Q2. Breakdown of any product
Ans. 
A breakdown of a product involves analyzing its components, features, functionality, and value proposition.
• Identify the key components of the product

• Analyze the features and functionalities of each component

• Evaluate the value proposition of the product in relation to customer needs and market trends
Answered by AI
Add your answer

20 question You have to Score 12

Q1. Basic question games and M testing
Add your answer

Q1. Manual Testing question And Game related Questions
Add your answer
Q2. Regression testing
Add your answer
Q3. Smoke testing sanity
Add your answer

Q1. PM round basic speaking
Add your answer

Coding related to java collections

Q1. Familiar with Design patterns ?explain few
Ans. 
Design patterns are reusable solutions to common problems in software design.
• Design patterns help in creating maintainable and scalable code.

• Examples of design patterns include Singleton, Factory, Observer, and Strategy.

• Singleton pattern ensures a class has only one instance and provides a global point of access to it.

• Factory pattern creates objects without specifying the exact class of object that will be created.

• Obse...read more
Answered by AI
Add your answer
Q2. What is Mutilthreading,explain with examples
Ans. 
Multithreading is the ability of a CPU to execute multiple threads concurrently, allowing for improved performance and responsiveness.
• Multithreading allows multiple tasks to be executed simultaneously on a single CPU.

• Each thread has its own stack and program counter, but shares the same memory space.

• Examples include running multiple processes in a web server, handling user input while performing background tasks, and p
Answered by AI
Add your answer

Q1. Probability question
Add your answer
Q2. Baseball game, ticket pricing
Add your answer

Q1. JS - closures , hoisting, event loop ,
Add your answer
Q2. Mongodb - sharding , clutering
Add your answer

Javascript programs - check sum , sql vs mongodb , system desgin