Cai Info India RPA Developer Interview Questions and Answers

Q1. Stream API related questions , methods etc.
Add your answer
Q2. What is Qualifier and Primary
Ans. 
Qualifier and Primary are annotations used in Spring framework for dependency injection.
• Qualifier annotation is used to specify which bean should be autowired when multiple beans of the same type are present

• Primary annotation is used to specify the primary bean to be autowired when multiple beans of the same type are present

• Qualifier can be used in combination with Autowired annotation to specify the bean name to be in...read more
Answered by AI
Add your answer
Q3. Spring boot annotations
Add your answer
Q4. Sort Array of 0 and 1
Ans. 
Sort an array of 0s and 1s in linear time complexity.
• Use two pointers approach - one from the start and one from the end.

• Swap 0s to the left and 1s to the right until the pointers meet.

• Time complexity: O(n), Space complexity: O(1).
Answered by AI
Add your answer
Q5. How do you handle code reviews
Ans. 
I actively participate in code reviews to ensure code quality and learn from others.
• I actively participate in code reviews by providing constructive feedback on others' code.

• I also seek feedback on my own code to improve its quality and learn from others.

• I follow coding standards and best practices during code reviews to maintain consistency and quality.

• I use code review tools like GitHub pull requests or Bitbucket to
Answered by AI
Add your answer

Q1. Coding question on backtracking
Add your answer
Q2. About state in react
Add your answer

Q1. About my work in previous company
Add your answer
Q2. About database in detail
Add your answer

Q1. MVC vs .NET lifecycle
Ans. 
MVC is a design pattern used in .NET development, while .NET lifecycle refers to the stages of a .NET application's execution.
• MVC is a design pattern that separates an application into three main components: Model, View, and Controller.

• .NET lifecycle refers to the stages of a .NET application's execution, including initialization, execution, and termination.

• MVC helps in achieving separation of concerns and making the c...read more
Answered by AI
Add your answer
Q2. Dispose vs Finalize
Ans. 
Dispose is used to release unmanaged resources immediately, while Finalize is used for cleanup operations before an object is destroyed by the garbage collector.
• Dispose is called explicitly by the developer, while Finalize is called by the garbage collector.

• Dispose should be implemented in classes that directly interact with unmanaged resources.

• Finalize should be implemented in classes that need to release resources be...read more
Answered by AI
Add your answer
Q3. Liscov Substitution
Add your answer
Q4. Dom Sanitizer in Angular
Ans. 
DOM sanitizer in Angular is used to sanitize untrusted HTML to prevent XSS attacks.
• DOM sanitizer is used to sanitize HTML content before rendering it in Angular templates.

• It helps prevent Cross-Site Scripting (XSS) attacks by removing potentially harmful content.

• Angular provides a built-in DomSanitizer service for sanitizing HTML content.

• Example: Using DomSanitizer in Angular template to sanitize a URL before rendering
Answered by AI
Add your answer
Q5. Ngrx state management, how do you manage state in your current project?
Ans. 
I use Ngrx for state management in my current project by defining actions, reducers, effects, and selectors.
• Define actions to describe user events or interactions

• Create reducers to specify how state should change in response to actions

• Implement effects to manage side effects like API calls

• Use selectors to retrieve specific pieces of state for components
Answered by AI
Add your answer
Q6. Stored procedure vs Functions
Ans. 
Stored procedures are precompiled SQL queries stored in the database, while functions are reusable code blocks that return a value.
• Stored procedures are used for performing specific tasks or operations on the database.

• Functions are used to encapsulate logic and can be called within SQL queries or other functions.

• Stored procedures can have input and output parameters, while functions always return a value.

• Stored procedu...read more
Answered by AI
Add your answer
Q7. Model binder in MVC
Ans. 
Model binder in MVC is used to map data from HTTP requests to action method parameters in controllers.
• Model binder maps form data, query string parameters, and route data to action method parameters in MVC controllers.

• It helps in simplifying the process of extracting data from HTTP requests.

• Model binder can be customized by creating custom model binders to handle complex data binding scenarios.
Answered by AI
Add your answer
Q8. Would transaction be rolled back if innermost stored procedure throws an error ?
Ans. 
Yes, the transaction will be rolled back if the innermost stored procedure throws an error.
• If an error occurs in the innermost stored procedure, it will cause the entire transaction to be rolled back.

• This ensures that the database remains in a consistent state.

• Rolling back the transaction means that any changes made by the stored procedures within the transaction will be undone.
Answered by AI
Add your answer
Q9. NgOninit vs Constructor
Ans. 
NgOnInit is a lifecycle hook in Angular that is called after the component has been initialized, while the constructor is a TypeScript feature used to initialize class properties.
• NgOnInit is specific to Angular components, while constructor is a general TypeScript feature.

• NgOnInit is used for initialization logic that relies on Angular's view and input bindings being initialized, while constructor is used for basic ini...read more
Answered by AI
Add your answer
Q10. Use of zone.js file
Ans. 
zone.js is a library for managing asynchronous operations in Angular applications.
• zone.js helps in tracking asynchronous operations and their execution context in Angular applications.

• It provides hooks for intercepting asynchronous tasks like setTimeout, setInterval, and promises.

• zone.js can be used for profiling, debugging, and error handling in Angular applications.
Answered by AI
Add your answer
Q11. Write a query to identify and remove duplicated from a table.
Ans. 
Use a query with GROUP BY and HAVING clause to identify and remove duplicates from a table.
• Use GROUP BY to group rows with the same values

• Use HAVING COUNT(*) > 1 to identify duplicates

• Use DELETE statement to remove duplicates
Answered by AI
Add your answer

Q1. The 1st round was JAM - Just a minute. They will give you a topic on the spot and we have to talk about this topic for 1-2min. Topics: The perfect prank you pulled, The best trip, Your pet's inner thoughts...read more
Add your answer

The 2nd round is GD: The GD was conducted properly for other batches. But for our batch the HR just collected everyone's resume and asked qns from our resume.
(Note: This is not an elimination round)

The 3rd round was Aptitude and Technical mcq test: 10 qns - DBMS, 20 - Quants, 20 - Java mcq
(Note: This round has negative markings)

Q1. Resume based and about projects
Add your answer
Q2. Basic sql queries Eg: SQL query to find the no of students in a department
Add your answer
Q3. Reverse a string - Python
Ans. 
Reverse a string in Python using slicing
• Use string slicing with a step of -1 to reverse the string

• Example: 'hello'[::-1] will return 'olleh'
Answered by AI
Add your answer

Q1. The last round was general hr: Since there were two many candidates the process took too much time. There was no questions asked during the hr round, who ever has agreed to the 2yrs bond were recruited
Add your answer

Q1. Spring Security Implementation
Add your answer
Q2. Api design Implementation
Ans. 
API design implementation involves creating a well-structured and user-friendly interface for interacting with software applications.
• Understand the requirements and use cases for the API

• Design clear and consistent endpoints with proper documentation

• Implement secure authentication and authorization mechanisms

• Follow RESTful principles for creating APIs

• Consider scalability and performance optimizations
Answered by AI
Add your answer
Q3. Stream API coding question
Add your answer

Q1. Ask for basic dot net questions
Add your answer

Java 8 duplicate number, hashcode set map Collection core java

Normal question aptitude like probability, scenario based questions, english grammar questions