Pharmarack Technologies Senior Product Designer Interview Questions and Answers

C++ coding question with multiple choice output and 1 code to write.

Q1. Data structure, virtual pointer, oops concept
Add your answer

Q1. Salary discussion and basic bavkground check.
Add your answer

Javascript basic question was asked

Q1. Email regex, angular framework
Add your answer
Q2. That all the question asked
Add your answer

Q1. Explain about yourself
Add your answer
Q2. Daily activity in current job role
Add your answer

Hackerearth platform was provided , Question was based on Tree dsa. Need to run and pass few test cases.

Design patterns , chess LLD

Design blocking queue which can handle the multithreading scenario

Q1. Last project experiences
Ans. 
Developed a web application for tracking inventory and sales data
• Used React for front-end development

• Implemented RESTful APIs using Node.js and Express

• Utilized MongoDB for database management
Answered by AI
Add your answer
Q2. And management cases.
Add your answer
Q3. Discussion about recent projects
Add your answer
Q4. Discussion about working in projects for which hiring for
Add your answer
Q5. Discussion about why leaving previous company.
Add your answer

Q1. There was simple DSA question ,
Add your answer

Round duration - 60 minutes
Round difficulty - Easy

It was my first round - they asked basics of OOPS,DBMS and operating systems. Be prepared with System Design also.

Q1. What are the ACID properties in database management systems?
Ans. 
ACID properties are a set of properties that guarantee reliability and consistency in database transactions.
• ACID stands for Atomicity, Consistency, Isolation, and Durability.

• Atomicity ensures that a transaction is treated as a single unit of work, either all of its operations are executed or none.

• Consistency ensures that a transaction brings the database from one valid state to another.

• Isolation ensures that concurrent...read more
Answered by AI
Add your answer
Q2. What is a transaction in the context of a Database Management System (DBMS)?
Ans. 
A transaction is a logical unit of work that consists of multiple database operations that must be executed as a single, indivisible unit.
• A transaction ensures data consistency and integrity.

• It follows the ACID properties: Atomicity, Consistency, Isolation, and Durability.

• Transactions are used to maintain data integrity in databases.

• Examples of transactions include transferring funds between bank accounts or updating i...read more
Answered by AI
Add your answer
Q3. What is the difference between SQL and NoSQL databases?
Ans. 
SQL databases are relational databases that use structured query language, while NoSQL databases are non-relational databases that use various data models.
• SQL databases are based on a fixed schema, while NoSQL databases are schema-less.

• SQL databases are better suited for complex queries and structured data, while NoSQL databases are better for unstructured and semi-structured data.

• SQL databases ensure ACID (Atomicity, ...read more
Answered by AI
Add your answer
Q4. What is a semaphore?
Ans. 
A semaphore is a synchronization object that controls access to a shared resource through the use of a counter.
• Semaphores are used to manage concurrent access to shared resources in multi-threaded or multi-process environments.

• They can be used to limit the number of threads or processes that can access a resource simultaneously.

• Semaphores can have two types: counting semaphores and binary semaphores.

• Counting semaphores...read more
Answered by AI
Add your answer
Q5. How can you achieve multitasking in Java?
Ans. 
Multitasking in Java can be achieved using threads.
• Create multiple threads to execute tasks concurrently.

• Use the Thread class or the Runnable interface to define the tasks.

• Use synchronization mechanisms like locks or semaphores to coordinate access to shared resources.

• Java provides built-in support for multitasking with the Thread class and the Executor framework.

• Example: creating two threads to perform different tasks...read more
Answered by AI
Add your answer
Q6. Can you design a schema for restaurant applications, similar to Zomato?
Ans. 
Design a schema for a restaurant app like Zomato.
• Create tables for restaurants, users, reviews, and orders

• Include columns for restaurant details like name, address, cuisine type

• Include columns for user details like name, email, and password

• Link reviews to restaurants and users

• Link orders to restaurants and users

• Consider additional tables for menu items, categories, and ratings
Answered by AI
Add your answer

A 1-hour long coding test was conducted

Q1. Hashing and collision in hashing
Ans. 
Hashing is a process of converting data into a fixed-size output. Collision occurs when two different inputs produce the same output.
• Hashing is used for indexing and retrieving data quickly

• Hash functions should be deterministic and produce the same output for the same input

• Collisions can be resolved using techniques like chaining or open addressing

• Examples of hashing algorithms include MD5, SHA-1, and SHA-256
Answered by AI
Add your answer

Q1. Minimum weight to reach bottom right corner in matrix starting from top left. you can move only down and right
Ans. 
The minimum weight to reach the bottom right corner in a matrix starting from the top left by moving only down and right.
• Use dynamic programming to calculate the minimum weight at each cell by considering the weights of the cells above and to the left.

• At each cell, the minimum weight to reach that cell is the minimum of the weight of the cell itself plus the minimum weight of the cells above and to the left.

• Example: Fo...read more
Answered by AI
Add your answer