Covalience Interview Questions and Answers

It was a mcq + coding round with computer fundamentals and aptitude + easy-medium level dsa questions.

It was an offline aptitute test with 30 questions for 30 minutes.

Q1. Detect a loop in the linked list
Ans. 
Detect a loop in a linked list by using Floyd's Cycle Detection Algorithm
• Use two pointers, slow and fast, to traverse the linked list

• If there is a loop, the fast pointer will eventually meet the slow pointer

• Initialize slow and fast pointers at the head of the linked list

• Move slow pointer by one step and fast pointer by two steps in each iteration

• If the fast pointer reaches the end of the list or meets the slow pointer,
Answered by AI
Add your answer
Q2. Find the unique element in an array
Ans. 
Find the unique element in an array of strings
• Iterate through the array and use a hashmap to store the frequency of each element

• After iterating, check the hashmap for elements with frequency 1 to find the unique element
Answered by AI
Add your answer
Q3. Tell about your projects
Ans. 
I have worked on various projects including a web application for a local business and a mobile app for tracking daily habits.
• Developed a web application using HTML, CSS, and JavaScript for a local business to manage their inventory and sales.

• Created a mobile app using React Native to track daily habits and provide reminders for healthy routines.

• Collaborated with a team to implement new features and fix bugs in existin...read more
Answered by AI
Add your answer
Q4. Write a MySQL query for selecting the id of second highest salary from employee table
Ans. 
MySQL query to select the id of second highest salary from employee table
• Use ORDER BY clause to sort salaries in descending order

• Use LIMIT to select the second row

• Use a subquery to avoid duplicates if multiple employees have the same salary
Answered by AI
Add your answer

Q1. How does your typical day begin?
Add your answer
Q2. What is the difference between Agile and Waterfall methodologies?
Add your answer

Q1. Can you describe your past experience as a business analyst?
Add your answer

Q1. Knowledge about API, ERP, SAP, DBMS, RDBMS, Joins, Normalisation, Codd Rules, Relational Algebra. May ask based on two given tables.
Add your answer
Q2. JSON, XML, OAuth, REST API, SOAP, GraphQL, HTTP Methods
Add your answer
Q3. HR questions, basic background, knowledge about B2B, B2C, e-commerce,
Add your answer

Q1. Details on project, API, procedures of API, knowledge on e-commerce, business aspects of your own projects, Core DBMS, RDBMS, Difference between SQL and NoSQL
Add your answer
Q2. May give 2 tables and check whether they are normalised or not. If not what should be done. Join them using left join or right join.
Add your answer
Q3. API, Types of Auth tokens (OAuth, Google Auth, JWT)
Add your answer
Q4. Procedures of ERP
Ans. 
Procedures of ERP involve defining business processes, configuring the system, testing, training, and ongoing support.
• Define business processes to align with ERP system capabilities

• Configure the ERP system based on defined processes

• Test the system to ensure functionality and data accuracy

• Provide training to users on how to use the ERP system effectively

• Offer ongoing support for system maintenance and troubleshooting
Answered by AI
Add your answer

Q1. Question based on CV
Add your answer

1 hour - NodeJS Based

Q1. High Level System Design
Ans. 
High level system design involves creating an overall architecture for a software system.
• Identify the main components of the system

• Define the interactions between the components

• Consider scalability, reliability, and performance

• Use diagrams to visualize the design

• Example: Designing a social media platform with user profiles, posts, and messaging functionality
Answered by AI
Add your answer

Q1. Low Level System Design
Ans. 
Low level system design involves designing the internal components of a software system.
• Focus on the architecture of the system at a detailed level

• Consider how different components interact with each other

• Optimize for performance and efficiency

• Think about scalability and maintainability

• Examples: designing a database schema, creating algorithms for data processing
Answered by AI
Add your answer

Q1. Culture Fit Round - Strength, Challenges etc
Add your answer

Q1. Basic Culture Fit, Motivations and ML Experience
Add your answer

Q1. Light Discussion about ML projects and Tech Stack mentioned in Resume
Add your answer

Q1. System Design - Design Credit Card Fraud Detection System specifically for US Festival Season
Add your answer