Accenture Senior Software Engineer Interview Questions, Process, and Tips

Q1. Sql join query related questions
Add your answer
Q2. Sql find duplicate
Ans. 
Use SQL query with GROUP BY and HAVING clause to find duplicates in a table.
• Use GROUP BY clause to group rows with same values

• Use HAVING clause to filter out groups with count greater than 1

• Example: SELECT column_name, COUNT(*) FROM table_name GROUP BY column_name HAVING COUNT(*) > 1
Answered by AI
Add your answer

Q1. Package discussion
Add your answer
Q2. Company policies
Add your answer

Q1. Difference between Interface and Abstraction
Ans. 
Interface defines a contract for a class to implement while Abstraction hides the implementation details.
• Interface is a blueprint of a class that defines what methods a class must implement.

• Abstraction is a concept where only relevant information is shown and irrelevant details are hidden.

• Interfaces can have multiple inheritance while Abstraction can be achieved through abstract classes or interfaces.

• Example: Interface...read more
Answered by AI
Add your answer
Q2. How data flows from frontend to backend in Asp.net core
Ans. 
Data flows from frontend to backend in Asp.net core through HTTP requests and responses.
• Frontend sends HTTP requests to backend API endpoints

• Backend processes the requests and sends back HTTP responses

• Data can be passed in the request body, query parameters, or headers

• Example: Frontend sends a POST request to create a new user, backend receives the request, processes it, and sends a success response
Answered by AI
Add your answer
Q3. Functions vs Stored Procedure
Ans. 
Functions are reusable code blocks that return a value, while stored procedures are precompiled SQL statements that can perform multiple operations.
• Functions return a value, while stored procedures do not necessarily return a value.

• Functions can be used in SQL queries, while stored procedures are called using EXECUTE statement.

• Functions are easier to test and debug compared to stored procedures.

• Stored procedures can co...read more
Answered by AI
Add your answer

Q1. What are the new features of Spring Boot 3.
Add your answer
Q2. How do you use Spring Security
Add your answer

Create Crud API to find employees based on employee id given
Use JUnit5 and mockito to write its tests to cover all possible scenarios.