Cotecna Inspection India HR Manager Interview Questions and Answers

Q1. Write progrem to check balenced brackets in a given string
Ans. 
Program to check balanced brackets in a given string
• Use a stack to keep track of opening brackets

• Iterate through the string and push opening brackets onto the stack

• When a closing bracket is encountered, pop from the stack and check if it matches the corresponding opening bracket

• If stack is empty at the end and all brackets are matched, the string is balanced
Answered by AI
Add your answer

Q1. Sql query on joins Given two tables and create output result . It was self join
Add your answer
Q2. Oops polymorphism questions Microservices Design pattern Factory pattern
Add your answer

Q1. Moderate questions
Add your answer
Q2. Asynchronous coding, async, mvc, sql, missing number program
Add your answer

Q1. Questions were mainly based on work experience and resume
Add your answer
Q2. AWS Question regarding S3, saprk memory
Add your answer

Q1. What is a dirty read in a database?
Ans. 
A dirty read occurs when a transaction reads data that has been modified but not yet committed by another transaction.
• Dirty reads can lead to inconsistencies, as the data may change before the first transaction is committed.

• For example, if Transaction A updates a record but hasn't committed yet, and Transaction B reads that record, Transaction B sees uncommitted data.

• If Transaction A rolls back, Transaction B will have...read more
Answered by AI
Add your answer
Q2. What are design patterns?
Ans. 
Design patterns are reusable solutions to common software design problems, promoting best practices and improving code maintainability.
• Creational patterns (e.g., Singleton, Factory Method) manage object creation.

• Structural patterns (e.g., Adapter, Composite) deal with object composition.

• Behavioral patterns (e.g., Observer, Strategy) focus on communication between objects.

• Design patterns help in code reusability and sca
Answered by AI
Add your answer

Q1. Minimum in Rotated Sorted array
Ans. 
Find the minimum element in a rotated sorted array.
• Perform binary search to find the pivot point where the array is rotated.

• Compare the element at pivot point to the first element to determine which half to search for the minimum.

• Continue binary search in the appropriate half to find the minimum element.
Answered by AI
Add your answer
Q2. API and DB Schema for Instagram based application.
Ans. 
API for Instagram application to interact with user data and DB schema to store user information and posts.
• API endpoints for user authentication, posting photos, liking photos, following users, etc.

• DB schema with tables for users, posts, comments, likes, followers, etc.

• Example API endpoint: /users/{userId}/posts to retrieve all posts by a specific user.

• Example DB schema: Users table with columns for username, email, pr
Answered by AI
Add your answer

Q1. Resume introspection, AWS, K8s
Add your answer

Q1. Third party took the interview. Basics of programming and database were asked.
Add your answer

Q1. Asked to build a small game. LLD round.
Add your answer

3 simple coding questions

Q1. Merge sort with list
Ans. 
Merge sort is a divide and conquer algorithm that recursively divides the input array into smaller subarrays, sorts them, and then merges them back together.
• Divide the input list into two halves

• Recursively apply merge sort to each half

• Merge the sorted halves back together
Answered by AI
Add your answer
Q2. Similar to coin exchange DP
Add your answer
Q3. SQL query medium level
Add your answer