Powerdrift Studios Interview Questions and Answers

Questions from trees and linkedin

Q1. Question on dsa and on oops
Add your answer
Q2. Reverse linked list with multiple approach
Ans. 
Reverse a linked list using multiple approaches.
• Iterative approach: Use three pointers to reverse the links between nodes.

• Recursive approach: Recursively reverse the rest of the list and adjust the links.

• Stack approach: Push all the nodes onto a stack and then pop them to create the reversed list.
Answered by AI
Add your answer

The test consisted of 4 DSA questions (1 easy, 2 medium, 1 hard) that had to be completed in 2 hours. They were standard questions from Leetcode and the test was similar to Leetcode's weekly coding contest.

Q1. Simple DSA questions like time complexity to insert in a Hash Map, the difference between singly and doubly linked lists, etc.
Add your answer
Q2. Subarray with sum 0
Ans. 
Find subarray in an array with sum 0
• Iterate through the array and keep track of the running sum

• Store the running sum in a hashmap and check if the same sum has been seen before

• If the sum is 0 or if the running sum is already in the hashmap, a subarray with sum 0 exists
Answered by AI
Add your answer
Q3. Linked List Cycle
Add your answer
Q4. Rainwater trapping proble
Add your answer

Q1. Design a database for a blogging website
Ans. 
Database design for a blogging website
• Create tables for users, blog posts, comments, and categories

• Use primary and foreign keys to establish relationships between tables

• Include fields such as title, content, author, date, and tags

• Implement indexing for faster retrieval of data

• Consider implementing a caching mechanism for improved performance
Answered by AI
Add your answer
Q2. What can be done to balance the load of requests coming to a single server
Ans. 
To balance the load of requests on a single server, one can implement load balancing techniques.
• Implementing a load balancer to distribute incoming requests evenly across multiple servers

• Using round-robin algorithm to route requests to different servers in a sequential manner

• Utilizing server health checks to monitor the performance of each server and adjust the load distribution accordingly
Answered by AI
Add your answer

Q1. Design database for my college
Ans. 
Design a database for a college
• Create tables for students, courses, professors, departments, and grades

• Establish relationships between tables using foreign keys

• Include attributes such as student ID, course ID, professor ID, department ID, and grade

• Consider normalization to reduce redundancy and improve data integrity
Answered by AI
Add your answer
Q2. Pseudo code to validate password
Ans. 
Pseudo code to validate password
• Create a function that takes a password as input

• Check if the password meets the required criteria (e.g. length, special characters)

• Return true if the password is valid, false otherwise
Answered by AI
Add your answer
Q3. Strengths and weakness that can affect my profesional life
Add your answer
Q4. Challenges faced during the projects in my resum and how did I overcome them
Add your answer

5 questions of medium difficulty level covering topics like queue, dynamic programming, binary search, greedy.

Q1. System design. Using a NoSQL document schema. Design a document store schema to store bike model data.
Add your answer

Q1. Willing to relocate to Navi Mumbai. Strengths and weekness General process related to my compatibility with the company.
Add your answer

90 mins, easy, Data structures and algorithm basics

Q1. Given an array, remove all duplicates in place
Ans. 
Remove duplicates from array of strings in place
• Use a HashSet to keep track of unique elements

• Iterate through the array and remove duplicates by checking if element is already in the HashSet

• Update the array in place by shifting elements to fill in the removed duplicates
Answered by AI
Add your answer

Q1. Caching and its uses
Ans. 
Caching is the process of storing data in a temporary location to reduce access time and improve performance.
• Caching helps reduce the load on servers by serving frequently accessed data quickly

• It can improve performance by reducing the time needed to retrieve data from the original source

• Examples include browser caching, CDN caching, and database caching
Answered by AI
Add your answer

Q1. Personality grading
Add your answer

2 hours coding round, only 1 person out of 90 cleared

Q1. Asked loads of dsa, super technical questions
Add your answer

Q1. Discuss 4 case study related to supply chain management.
Add your answer

Q1. Basic background
Add your answer

Q1. Direct and indirect tax compliances. Knowledge check in income tax and gst
Add your answer

Q1. This round was with VP of Finance containing questions related to again knowledge check of income tax and gst
Add your answer

Q1. Java core, spring boot
Add your answer
Q2. DBMS concepts
Add your answer

Q1. Explain group by clause with used cases
Ans. 
Group by clause is used to group data based on a specific column in a table.
• Used with aggregate functions like SUM, COUNT, AVG, etc.

• Helps in analyzing data by grouping it based on a common attribute.

• Can be used with multiple columns to create nested groups.

• Example: GROUP BY department in a table of employees to get the total salary for each department.
Answered by AI
Add your answer
Q2. CountA,CountB,Countif used case in Google sheet
Ans. 
CountA, CountB, Countif are functions used in Google Sheets to count cells based on certain criteria.
• CountA counts the number of cells in a range that are not empty.

• CountB counts the number of cells in a range that are not blank.

• Countif counts the number of cells in a range that meet a certain condition.

• Countif can be used with operators like >, <, =, and functions like AND, OR.

• Countif can also be used with wildcards l
Answered by AI
Add your answer

Q1. Where have stayed...why want to switch...what will be your priority ..job or family
View 3 more answers