Simplilearn Interview Questions, Process, and Tips

Q1. Question based on Window Functions in sql
Add your answer
Q2. Order of execution
Ans. 
Order of execution refers to the sequence in which operations are carried out in a program or system.
• Execution starts from the top of the program and moves downwards.

• Operations within parentheses are executed first.

• Multiplication and division are executed before addition and subtraction.

• Functions are executed when they are called.

• Control structures like loops and conditionals affect the order of execution.
Answered by AI
View 1 more answer

Q1. Write a sql query to find out different routes for a airline. Table has two columns which are destination and source
Ans. 
Use a SQL query to find different routes for an airline based on source and destination columns in a table.
• Use a SELECT statement to retrieve the distinct combinations of source and destination.

• Use the DISTINCT keyword to ensure only unique routes are returned.

• Order the results by source and destination for easier analysis.
Answered by AI
View 1 more answer
Q2. Situational questions based on Business KPI
Add your answer

Q1. Simple discussion on the role and company culture
Add your answer

Q1. Case study question
Add your answer

Q1. Basic Discussion on relocation and interest in joining the company.
Add your answer

Q1. Self intro, family background, why sales, why Simplilearn, basic questions to check english communication skills
Add your answer

Q1. Different scenarios questions to check objection handling, negotiation skills.
Add your answer

Grammer
Essay writing etc too much basic aptitute

Q1. Real time pratical objection handing skills
Add your answer

Q1. Cross selling and update sell
Add your answer

Q1. Write a java program to find frequency of given string. Write a java program to find string contains all the character literals a to z. Write a java program for swapping two numbers without using addional ...read more
Add your answer
Q2. Write a query to find second maximum salary in employee table.
Ans. 
To find the second maximum salary, we can use SQL queries with subqueries or the DISTINCT keyword.
• Use a subquery to select distinct salaries and order them in descending order.

• Limit the results to the second row using OFFSET or LIMIT.

• Example query: SELECT DISTINCT salary FROM employee ORDER BY salary DESC LIMIT 1 OFFSET 1;

• Alternatively, use the MAX function: SELECT MAX(salary) FROM employee WHERE salary < (SELECT MA
Answered by AI
Add your answer

Group discussion is always give healthy remedy for sharing the nead of to clearing the reail positatin to sovle the reaile reamidy to go forther move.

Q1. The interview process and theqestion is very importent tips for the admetion carrier to follow the same time to make sure that you have any questions or iwill share immidatly it's my important rool to shar...read more
Add your answer
Q2. It's very good and Its a mandetary for each and including my knowledge to improveits my very sencear plasher to share each and every.one to share there reaile feeling to share each and every one
Add your answer

Q1. What would you improve in a physical product and how would you increase the market share of it?
Ans. 
I would improve the durability of the product and increase market share through targeted advertising and partnerships.
• Enhance the materials used in the product to increase durability and longevity

• Conduct market research to identify target demographics and tailor advertising campaigns accordingly

• Form partnerships with complementary products or services to expand reach and attract new customers
Answered by AI
Add your answer
Q2. How would you change swiggy
Add your answer

Q1. How would you redesign Swiggy checkout process?
Ans. 
I would redesign Swiggy checkout process by simplifying the steps and improving user experience.
• Streamline the checkout process by reducing the number of steps required

• Implement guest checkout option for first-time users

• Allow users to save payment information for faster future transactions

• Provide clear and concise instructions at each step of the checkout process

• Offer multiple payment options to cater to different user
Answered by AI
Add your answer

Q1. What would you do to make whatsapp pay more discoverable?
Ans. 
To make WhatsApp Pay more discoverable, I would focus on improving user education, leveraging social media platforms, and collaborating with popular brands.
• Create tutorials and guides within the app to educate users on how to use WhatsApp Pay

• Utilize social media platforms to promote WhatsApp Pay features and benefits

• Collaborate with popular brands for joint marketing campaigns to increase awareness and usage
Answered by AI
Add your answer

Q1. Explain the your sales experience
Add your answer

Q1. Sales matrix in details like leads ,b2c exp,ed tech exp etc
Add your answer

Q1. Cultural fitment related questions
Add your answer