Zenoti Interview Questions, Process, and Tips

Q1. Some basic questions on resume
Add your answer
Q2. Excel file is shared and was asked to do analysis
Add your answer

Q1. Print Longest Increasing Subsequence
Ans. 
Print the longest increasing subsequence of an array of strings.
• Use dynamic programming to find the longest increasing subsequence.

• Iterate through the array and keep track of the longest increasing subsequence ending at each index.

• Return the longest increasing subsequence found.
Answered by AI
Add your answer

Q1. SQL query order of execution
Ans. 
SQL query order of execution determines the sequence in which different parts of a query are processed.
• SQL query is parsed and checked for syntax errors

• Query optimizer creates an execution plan

• Data is retrieved from tables based on the execution plan

• Filters and joins are applied to the retrieved data

• Aggregations and calculations are performed on the filtered data
Answered by AI
Add your answer
Q2. How would you handles null data value in joins
Ans. 
Null data values in joins can be handled using COALESCE function or LEFT JOIN with IS NULL condition.
• Use COALESCE function to replace null values with a specified default value

• Use LEFT JOIN with IS NULL condition to include rows with null values in the result set

• Consider using CASE statements to handle null values based on specific conditions
Answered by AI
Add your answer

Leetcode Medium Type Questions

Q1. Design a Online System to book Salon Professionals like Urban Company.
Ans. 
Design an online system to book salon professionals like Urban Company.
• User registration and login system

• Search functionality to find salon professionals based on location, services offered, ratings, etc.

• Booking system with calendar availability and payment integration

• Review and rating system for users to provide feedback on salon professionals

• Notification system for booking confirmations, reminders, and updates
Answered by AI
Add your answer

Q1. Mostly based on resume
Add your answer

Q1. Walk through your profile.
Add your answer
Q2. Scenario Based questions
Add your answer