PharmEasy Lead Analyst Interview Questions and Answers for Experienced

I'm knowlege of c language

Q1. Aney question of c language
Add your answer
Q2. And data base and etc
Add your answer

Simple SQL & Excel test

Q1. Will Face hiring Manager
Add your answer

Q1. SQL related questions like joins
Add your answer
Q2. Types of join in sql
Ans. 
Types of join in SQL include inner join, left join, right join, and full outer join.
• Inner join returns only the matching records from both tables.

• Left join returns all records from the left table and the matching records from the right table.

• Right join returns all records from the right table and the matching records from the left table.

• Full outer join returns all records when there is a match in either the left or rig
Answered by AI
Add your answer
Q3. Practical use of left join
Ans. 
A left join is used to combine data from two tables based on a common column, including all records from the left table.
• Left join returns all rows from the left table and the matching rows from the right table.

• It is useful when you want to retrieve all records from the left table, even if there are no matches in the right table.

• The result of a left join will have NULL values in the columns from the right table where th...read more
Answered by AI
Add your answer
Q4. Number of rows after applying certain join operations
Ans. 
The number of rows after applying join operations depends on the type of join used and the data in the tables being joined.
• Inner join retains only the rows that have matching values in both tables

• Left join retains all rows from the left table and the matched rows from the right table

• Right join retains all rows from the right table and the matched rows from the left table

• Full outer join retains all rows when there is a
Answered by AI
Add your answer
Q5. Difference between vlookup in excel and some function in sql
Ans. 
VLOOKUP in Excel is used to search for a value in a table and return a corresponding value, while SQL functions like JOIN and WHERE are used to retrieve data from multiple tables based on specified conditions.
• VLOOKUP is specific to Excel and works on a single table, while SQL functions can work on multiple tables.

• VLOOKUP requires the table to be sorted in ascending order, while SQL functions do not have this requiremen...read more
Answered by AI
Add your answer

Q1. Create pagination component using an api show the data for the pages
Ans. 
Create a pagination component using an API to display data for different pages.
• Use API to fetch data for each page

• Implement pagination logic to display data for each page

• Allow users to navigate between pages
Answered by AI
Add your answer

QUESTIONS BASED ON TREES , GRPAHS

BASIC APTITUDE LIKE LOCATION ETC

Q1. What di you use in project
Ans. 
I used Java, Spring Boot, and MySQL in my project to develop a web application for managing inventory.
• Java

• Spring Boot

• MySQL
Answered by AI
Add your answer
Q2. What issues did you face
Ans. 
I faced issues with debugging complex code, collaborating with team members, and meeting tight deadlines.
• Debugging complex code: Had to spend extra time identifying and fixing bugs in intricate code.

• Collaborating with team members: Communication issues and conflicting ideas slowed down progress.

• Meeting tight deadlines: Struggled to prioritize tasks and manage time effectively to meet project deadlines.
Answered by AI
Add your answer

HackerRank Test - Python, SQL

4 question were there i have completed all the problems in given time

Q1. Cab management sysntem
Add your answer

I was asked a medium-level SQL question that involved the RANK function.