i
Pharmarack Technologies
Filter interviews by
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
posted on 23 Mar 2021
I applied via Naukri.com and was interviewed before Mar 2020. There was 1 interview round.
I applied via Campus Placement and was interviewed before Mar 2021. There were 4 interview rounds.
90 minute test on hacker rank consisting of 3 coding questions all of medium difficulty. Most candidates are required to solve more than 1 question.
Find the lowest common ancestor of a binary tree.
Traverse the tree recursively from the root node.
If the current node is null or matches either of the given nodes, return the current node.
Recursively search for the nodes in the left and right subtrees.
If both nodes are found in different subtrees, return the current node.
If both nodes are found in the same subtree, continue the search in that subtree.
Find first missing positive integer from an array of non-negative integers.
Create a hash set to store all positive integers in the array
Loop through the array and add all positive integers to the hash set
Loop through positive integers starting from 1 and return the first missing integer not in the hash set
Design a parking lot
Consider the size and capacity of the parking lot
Decide on the layout and organization of parking spaces
Implement a system to manage parking availability and reservations
Include features like ticketing, payment, and security
Consider scalability and future expansion
Group list of strings into distinct anagrams.
Create a hash table with sorted string as key and list of anagrams as value.
Iterate through the list of strings and add each string to its corresponding anagram list in the hash table.
Return the values of the hash table as a list of lists.
posted on 27 Oct 2022
I applied via Naukri.com and was interviewed before Oct 2021. There were 3 interview rounds.
I applied via Company Website and was interviewed in Apr 2021. There was 1 interview round.
posted on 21 Jun 2023
I appeared for an interview before Jun 2022.
C++ coding question with multiple choice output and 1 code to write.
posted on 26 Jun 2023
Javascript basic question was asked
I applied via Naukri.com and was interviewed in Aug 2024. There were 2 interview rounds.
C and Golang related questions, 2 Hours assement, The test involved writing code by hand in paper in the office (Bengaluru)
Go code to remove duplicate elements from a slice of strings
Use a map to keep track of unique elements
Iterate over the slice and add elements to the map
Create a new slice with unique elements from the map
Arrays have fixed length, slices are dynamic and can grow/shrink. Slices are references to arrays.
Arrays have fixed length, specified at compile time.
Slices are dynamic, can grow or shrink at runtime.
Slices are references to arrays, allowing for more flexibility.
Example: var arr [3]string // array with fixed length of 3
Example: slice := make([]string, 0) // slice with dynamic length
Struct is a user-defined data type that groups related data fields together. Interface defines a set of methods that a type must implement.
Struct is used to create complex data structures by grouping related data fields together.
Interface defines a set of methods that a type must implement. It allows for polymorphism in Go.
Example: type Person struct { Name string; Age int }
Example: type Shape interface { Area() float6...
Containerization is a method of packaging, distributing, and running applications in isolated environments called containers.
Containers are lightweight, portable, and can run on any platform that supports containerization.
They include everything needed to run the application, such as code, runtime, system tools, libraries, and settings.
Popular containerization tools include Docker, Kubernetes, and Podman.
Containerizati...
Implementing a struct in Go code
Define a struct using the 'type' keyword
Add fields to the struct with their respective data types
Access struct fields using dot notation
Goroutine is a lightweight thread managed by Go runtime, allowing concurrent execution of functions.
Goroutines are created using the 'go' keyword in Go programming language.
They are more lightweight than threads and are managed by the Go runtime.
Goroutines allow for concurrent execution of functions without the need for manual thread management.
Example: go myFunction()
Example: go func() { // code here }
Concurrency in Go is achieved using goroutines and channels.
Use goroutines to run functions concurrently
Communicate between goroutines using channels
Avoid using shared memory for synchronization
A channel in Go is a communication mechanism that allows goroutines to communicate with each other.
Buffered channels have a specific capacity and can send multiple values without the need for a corresponding receive operation immediately.
Unbuffered channels have no capacity and require both a send and receive operation to be ready at the same time for communication to occur.
Scaling refers to the ability of a system to handle increasing amounts of work or its potential to accommodate growth.
Horizontal scaling involves adding more machines to distribute the load, while vertical scaling involves increasing the resources of a single machine.
Horizontal scaling is more cost-effective and provides better fault tolerance, but can be more complex to implement.
Vertical scaling is simpler to impleme...
posted on 27 Nov 2024
I applied via Company Website and was interviewed in Oct 2024. There was 1 interview round.
1 hour interview for data structure coding
posted on 1 Jul 2022
I appeared for an interview in Jan 2022.
based on 1 interview
Interview experience
based on 8 reviews
Rating in categories
Business Development Executive
110
salaries
| ₹2.2 L/yr - ₹5 L/yr |
Marketing Executive
97
salaries
| ₹2 L/yr - ₹4.2 L/yr |
Technical Support Engineer
60
salaries
| ₹2.6 L/yr - ₹4.3 L/yr |
Regional Sales Manager
56
salaries
| ₹6.9 L/yr - ₹14.2 L/yr |
Technical Support Executive
38
salaries
| ₹2.2 L/yr - ₹4.1 L/yr |
CMS IT Services
Quantiphi Analytics Solutions Private Limited
PrimEra Medical Technologies
Mavenir Systems