Target Interview Questions, Process, and Tips

Basics question related to python

Q1. Python frameworks
Add your answer

One easy question and one medium question.

Q1. Situation based questions.
Add your answer
Q2. Little bit technical.
Add your answer

Q1. The difference between union and union all
Ans. 
Union combines and removes duplicates, while Union All combines without removing duplicates.
• Union combines two result sets and removes duplicates

• Union All combines two result sets without removing duplicates

• Union is slower than Union All as it involves removing duplicates

• Union requires both result sets to have the same number of columns and compatible data types
Answered by AI
Add your answer
Q2. SQL query execution order
Add your answer

Q1. One on one round where they asked about past experience and questions related to the role I was applying for. Situational and behavioural questions followed, concluding with salary expectations.
Add your answer

Q1. Write design for URL sortner
Ans. 
Design a URL shortener system
• Use a unique identifier for each long URL to generate a short URL

• Store the mapping of short URL to long URL in a database

• Implement a redirect mechanism to redirect short URLs to their corresponding long URLs

• Consider scalability and performance while designing the system
Answered by AI
Add your answer
Q2. Program to detect cycle on linked list
Ans. 
Use Floyd's Tortoise and Hare algorithm to detect cycle in a linked list.
• Initialize two pointers, slow and fast, at the head of the linked list.

• Move slow pointer by one step and fast pointer by two steps.

• If they meet at any point, there is a cycle in the linked list.
Answered by AI
Add your answer

Q1. Experience based
Add your answer