Replicon Senior Software Engineer Interview Questions and Answers

Q1. Write an SQL query to fetch duplicates.
Ans. 
SQL query to fetch duplicates
• Use GROUP BY and HAVING clause to identify duplicates

• Select columns to be checked for duplicates

• Example: SELECT column_name, COUNT(*) FROM table_name GROUP BY column_name HAVING COUNT(*) > 1;
Answered by AI
Add your answer
Q2. Write SQL query to fetch nth highest Salary.
Ans. 
SQL query to fetch nth highest Salary
• Use the ORDER BY clause to sort the salaries in descending order

• Use the LIMIT clause to fetch the nth highest salary

• Consider handling cases where there might be ties for the nth highest salary
Answered by AI
Add your answer

They do a technical mock test

Q1. Oop Concept questions
Add your answer
Q2. Database related Questions
Add your answer
Q3. SVN related Questions
Add your answer

Q1. Props and its role in
Add your answer
Q2. States and its role in
Ans. 
States play a crucial role in the functioning of a country's government and administration.
• States are administrative divisions within a country.

• They have their own governments and are responsible for managing their own affairs.

• States play a key role in the federal system of government, where power is shared between the central government and the states.

• They are responsible for implementing policies and programs at the ...read more
Answered by AI
Add your answer

It was good ...questions were easy and straight forward..basic questions based on ds algo

Q1. Advantage and disadvantage of framework.
Ans. 
Frameworks provide structure and pre-built components for software development, but can also limit flexibility and require learning curve.
• Advantage: Provides structure and pre-built components for faster development

• Advantage: Can improve code quality and maintainability

• Disadvantage: Can limit flexibility and customization

• Disadvantage: Requires learning curve and potential dependency issues

• Example: ReactJS provides a fr...read more
Answered by AI
Add your answer

Q1. What is Oops? Advantage and disadvantage
Ans. 
Oops stands for Object-Oriented Programming. It is a programming paradigm that uses objects to represent real-world entities.
• Advantages: code reusability, modularity, encapsulation, inheritance, polymorphism

• Disadvantages: complexity, steep learning curve, performance overhead

• Example: creating a class 'Car' with properties like 'make', 'model', and 'year', and methods like 'start_engine' and 'stop_engine'
Answered by AI
Add your answer

2 dsa questions need to be implemented in 1hr

Q1. Projects you have worked on. 1. vector implementation in C++
Ans. 
Implemented vector data structure in C++
• Used templates to create a generic vector class

• Implemented basic vector operations like push, pop, insert, erase

• Optimized vector resizing by using exponential growth

• Used iterators to traverse the vector elements

• Implemented vector algorithms like sort and binary search
Answered by AI
Add your answer

Q1. Compensation, expected and other document submitting.
Add your answer