Expleo Group Plsql Developer Interview Questions and Answers

Round duration - 90 minutes
Round difficulty - Medium

We were supposed to give test in any time between 3 PM to 9 PM.

Q1. 
Total Unique Paths Problem Statement
You are located at point ‘A’, the top-left corner of an M x N matrix, and your target is point ‘B’, the bottom-right corner of the same matrix. Your task is to calcula...read more
Ans. 
The problem involves finding the total number of unique paths from the top-left to bottom-right cell of a matrix by moving only right or down.
• Use dynamic programming to solve the problem efficiently.

• Create a 2D array to store the number of unique paths at each cell.

• Initialize the first row and first column with 1 as there is only one way to reach them.

• For each cell (i, j), the number of unique paths is the sum of paths...read more
Answered by AI
Add your answer
Q2. 
Subtree Node Count Problem
We are provided with a tree containing 'N' nodes, numbered from 0 to N-1. The objective is to determine the total number of nodes within each subtree of the provided tree. Speci...read more
Ans. 
Given a tree with N nodes, find the number of elements in each subtree rooted at every node.
• Traverse the tree using Depth First Search (DFS) to calculate subtree sizes for each node.

• Use an array to store subtree sizes for each node, starting with leaf nodes having size 1.

• The subtree size of a node is the sum of subtree sizes of its children plus 1 for the node itself.
Answered by AI
Add your answer

Round duration - 120 minutes
Round difficulty - Medium

Pair Programming Interview( this round is similar to machine coding round) it started around 11 AM

Focus Areas: Problem solving and implementation of extensions.

The pair coding round is focused on OOPS concepts. You are paired with a TWer for this round. They let you code first for an hour and in the next hour they review your code and suggest changes which would improve the code structure, readability and make it modular and reusable and functional.
 

Q1. 
River Crossing: Help Ninja Cross Over
Ninja stands at the start of a wooden bridge over a river. Some segments of the bridge are damaged. The undamaged segments, marked as 'safe', are listed in an array S...read more
Ans. 
Check if Ninja can cross the river by jumping from one safe segment to another based on given constraints.
• Iterate through the 'SAFE' array and check if Ninja can make the required jumps to reach the last safe segment.

• Ensure that the next jump is either 'X' - 1, 'X', or 'X' + 1 units from the previous jump.

• Return 'true' if Ninja can successfully cross the river, otherwise return 'false'.
Answered by AI
Add your answer

Round duration - 120 minutes
Round difficulty - Medium

Students who were shortlisted from Pair Programming round was selected for this round around 3 PM. In this round there were two interviewer.

Q1. 
Middle of a Linked List
You are given the head node of a singly linked list. Your task is to return a pointer pointing to the middle of the linked list.
If there is an odd number of elements, return the ...read more
Ans. 
Return the middle element of a singly linked list, or the one farther from the head if there are even elements.
• Traverse the linked list with two pointers, one moving twice as fast as the other

• When the fast pointer reaches the end, the slow pointer will be at the middle

• Return the element pointed to by the slow pointer
Answered by AI
Add your answer

DSA

About Social changes

Q1. Tell me about yourself.
Add your answer
Q2. Very basic questions
Add your answer

Q1. Basic CSS, Event Loop, Callback, promises, js programming, tricky questions
Add your answer

Q1. Callback, clouser,
Add your answer

Coding assignment and some mcq questions

Q1. Questions on java , oops , stream , collection and array code
Add your answer
Q2. Springboot flow , annotations
Add your answer

Q1. Technical interview is depend on client
Add your answer

Q1. Architecture of software
Ans. 
Software architecture refers to the high-level structures of a software system and the discipline of creating such structures.
• Software architecture defines the components, relationships, and interactions of a system.

• It involves making decisions about the organization of a system to meet specific requirements.

• Common architectural styles include client-server, layered, and microservices.

• Architectural patterns like MVC an...read more
Answered by AI
Add your answer

Q1. Basic Java Question
Add your answer
Q2. Spring Boot related questions
Add your answer

Q1. Design a rest API and code it.
Ans. 
Design and code a REST API for a software developer interview.
• Define the endpoints and HTTP methods for the API (e.g. GET /users, POST /users)

• Implement authentication and authorization mechanisms (e.g. JWT tokens)

• Use proper status codes for responses (e.g. 200 OK, 401 Unauthorized)

• Include error handling and validation for input data

• Document the API using tools like Swagger or OpenAPI
Answered by AI
Add your answer
Q2. Questions related to JPA HIBERNATE SQL
Add your answer

Q1. Discussion related to Last company Project and architecture level questions
Add your answer
Q2. Write code to calculate frequency of a word using Stream API and lambda expressions
Ans. 
Calculate word frequency using Stream API and lambda expressions
• Use Stream API to convert array of strings to stream

• Use Collectors.groupingBy to group words by their frequency

• Use Collectors.counting to count the occurrences of each word
Answered by AI
Add your answer