i
Pharmarack Technologies
Filter interviews by
Clear (1)
I applied via Naukri.com and was interviewed in Oct 2021. There were 3 interview rounds.
Types of Joins are used in SQL to combine rows from two or more tables based on a related column between them.
Inner Join: Returns only the matching rows from both tables.
Left Join: Returns all the rows from the left table and the matching rows from the right table.
Right Join: Returns all the rows from the right table and the matching rows from the left table.
Full Outer Join: Returns all the rows from both tables, inclu...
Drop command removes a table from the database while delete command removes rows from a table.
Drop command is a DDL (Data Definition Language) command while delete command is a DML (Data Manipulation Language) command.
Drop command is irreversible and removes the entire table structure and its data while delete command only removes specific rows.
Drop command requires the DROP privilege while delete command requires the ...
Primary key uniquely identifies each record in a database table.
Primary key ensures data integrity and consistency.
It helps in faster data retrieval and indexing.
It can be a single column or a combination of columns.
Primary key cannot have null values.
Examples of primary keys are social security number, email address, etc.
A foreign key is a column or set of columns in a table that refers to the primary key of another table.
It is used to establish a relationship between two tables in a database.
It ensures referential integrity by preventing invalid data from being inserted into the table.
It allows for efficient querying and joining of related data.
Example: A customer table may have a foreign key that references the primary key of an orde...
Query to display employees records
Use SELECT statement to retrieve data from employee table
Specify the columns to be displayed in the SELECT statement
Use WHERE clause to filter the records based on specific conditions
Use ORDER BY clause to sort the records in ascending or descending order
Top trending discussions
I applied via Referral
I applied via Campus Placement
Binary Search has a time complexity of O(log n) and is derived from dividing the search space in half at each step.
Binary Search is a search algorithm that works on sorted arrays.
It starts by comparing the target value to the middle element of the array.
If the target value is smaller, the search continues on the lower half of the array.
If the target value is larger, the search continues on the upper half of the array.
T...
QuickSort is a sorting algorithm that uses divide and conquer approach.
Choose a pivot element from the array
Partition the array into two sub-arrays, one with elements less than the pivot and one with elements greater than the pivot
Recursively apply the above steps to the sub-arrays
Combine the sorted sub-arrays to get the final sorted array
Code for Fibonacci Series using Recursion, Iteration and Dynamic Programming
Recursion: Define a function that calls itself with the previous two numbers in the series as arguments
Iteration: Use a loop to calculate the series by adding the previous two numbers in each iteration
Dynamic Programming: Store the previous two numbers in variables and use them to calculate the next number in the series
Implementing a Queue using Stacks
Use two stacks to implement a queue
Push elements onto the first stack
When dequeuing, pop all elements from the first stack and push onto the second stack
Pop the top element from the second stack to dequeue
If the second stack is empty, pop all elements from the first stack and push onto the second stack
MergeSort is a divide and conquer algorithm that sorts an array of strings.
Divide the array into two halves
Recursively sort the two halves
Merge the sorted halves
Counting Sort is a sorting algorithm that sorts elements by counting the number of occurrences of each unique element.
Count the occurrences of each element in the array
Calculate the cumulative sum of the counts
Place each element in the sorted array based on its count and cumulative sum
Time complexity is O(n+k) where n is the number of elements and k is the range of input
Example: Sort an array of strings based on their
Chrome uses an algorithm to predict and suggest words based on user input.
Chrome's algorithm uses a combination of user history, bookmarks, and popular searches to predict and suggest words.
The algorithm also takes into account the frequency and recency of the user's input.
Chrome's suggestion feature is powered by Google's Autocomplete API, which uses machine learning to predict and suggest words.
The suggestions are di...
I applied via Approached by Company and was interviewed in Feb 2022. There were 2 interview rounds.
I applied via Walk-in and was interviewed before Apr 2023. There were 2 interview rounds.
I applied via Naukri.com and was interviewed before Jul 2023. There were 3 interview rounds.
I applied via Campus Placement and was interviewed before Mar 2023. There were 3 interview rounds.
I applied via Naukri.com and was interviewed in Jun 2024. There was 1 interview round.
based on 1 interview
Interview experience
based on 8 reviews
Rating in categories
Business Development Executive
112
salaries
| ₹2.2 L/yr - ₹5.3 L/yr |
Marketing Executive
101
salaries
| ₹2 L/yr - ₹4.5 L/yr |
Regional Sales Manager
61
salaries
| ₹6.9 L/yr - ₹14.2 L/yr |
Technical Support Engineer
60
salaries
| ₹2.6 L/yr - ₹4.3 L/yr |
Technical Support Executive
38
salaries
| ₹2.2 L/yr - ₹4.1 L/yr |
Netmeds.com
Tata 1mg
PharmEasy
Medlife