DESL Analyst Interview Questions and Answers

Shortlisted students were divided in group of 19

Selected students from gd got the call for case study round

Q1. Questions were based on the case study and guesstimates
Add your answer
Q2. No. of aeroplane flying in the sky right now
Ans. 
It is impossible to accurately determine the exact number of airplanes flying in the sky at any given moment.
• The number of airplanes in the sky constantly changes due to take-offs, landings, and flights being at different stages.

• Factors such as time of day, weather conditions, and air traffic also affect the number of airplanes in the sky.

• Air traffic control systems may provide estimates of the number of airplanes in a
Answered by AI
Add your answer
Q3. How will u utilise 1 acre of land provided to u near ur college
Ans. 
I would utilize the 1 acre of land near my college for creating a sustainable community garden.
• Establishing vegetable and fruit gardens to promote healthy eating among students

• Setting up a composting area to reduce waste and enrich the soil

• Creating a space for outdoor classes and events to enhance learning and community engagement
Answered by AI
Add your answer
Q4. How to start a starbuck franchisein ur town
Ans. 
To start a Starbucks franchise in your town, you need to follow a specific process set by the company.
• Contact Starbucks corporate office to inquire about franchise opportunities

• Meet the financial requirements and submit a franchise application

• Find a suitable location for the Starbucks store

• Complete the required training and adhere to Starbucks' standards and guidelines
Answered by AI
Add your answer
Q5. Sql extraction of the given table and data
Ans. 
Use SQL query to extract data from a given table
• Use SELECT statement to retrieve data from the table

• Specify the columns you want to retrieve after SELECT

• Use FROM clause to specify the table name

• Add conditions using WHERE clause if needed

• Use ORDER BY clause to sort the results if necessary
Answered by AI
Add your answer

Q1. In Angular input and output parameters.
Ans. 
In Angular, input parameters are used to pass data into a component, while output parameters are used to emit events from a component.
• Input parameters are defined using the @Input decorator in Angular.

• Output parameters are defined using the @Output decorator in Angular.

• Input parameters allow parent components to pass data into child components.

• Output parameters allow child components to emit events to parent components...read more
Answered by AI
Add your answer
Q2. Write inner join query using two table
Ans. 
Inner join query is used to retrieve records that have matching values in both tables.
• Use SELECT statement to specify the columns you want to retrieve

• Use INNER JOIN keyword to combine the tables based on a related column

• Specify the ON clause to define the relationship between the tables
Answered by AI
Add your answer

Q1. Fibonacci series code
Add your answer
Q2. Sql query related question
Add your answer

Q1. Package discussion expectation and they offer
Add your answer
Q2. Joining date, and the policies of company
Add your answer

It was a 1 hour test. It consists of two sections (i) 8 ques were of Business case studies (ii) 12 ques were of quantitative aptitude.

Q1. What is the difference between where and having clause ?
Ans. 
Where clause is used to filter rows before grouping, while having clause is used to filter groups after grouping.
• Where clause is used with SELECT, UPDATE, DELETE statements to filter rows based on a condition.

• Having clause is used with GROUP BY statement to filter groups based on a condition.

• Where clause is applied before grouping, while having clause is applied after grouping.

• Example: SELECT * FROM table_name WHERE co...read more
Answered by AI
Add your answer
Q2. One ques was a guesstimate problem.
Add your answer

Q1. Self Introduction.
Add your answer
Q2. Business case problem which was to be solved in 15 minutes.
Add your answer

Q1. Basic information about past experiences
Add your answer

Q1. This was round with the associate consultant
Add your answer

It was a case study round with the manager and about the CV

Q1. This round was with the associate partner. There was one small case study.
Add your answer