Premium Employer

i

This company page is being actively managed by PolicyBazaar Team. If you also belong to the team, you can get access from here

PolicyBazaar Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

PolicyBazaar Senior Database Developer Interview Questions, Process, and Tips

Updated 25 Jan 2022

Top PolicyBazaar Senior Database Developer Interview Questions and Answers

  • Q1. Can you discuss the numeric data types available in SQL Server?
  • Q2. What is the difference between Merge and Union All transformations in SQL?
  • Q3. What is the difference between the Snowflake schema and the Star schema in data warehousing?
View all 17 questions

PolicyBazaar Senior Database Developer Interview Experiences

2 interviews found

I was interviewed in Mar 2021.

Round 1 - Video Call 

(2 Questions)

Round duration - 60 minutes
Round difficulty - Easy

Technical round with questions based on DBMS and SQL

  • Q1. What is indexing in the context of databases?
  • Ans. 

    Indexing in databases is a technique used to improve the speed of data retrieval by creating a data structure that allows for quick lookups.

    • Indexes are created on columns in a database table to speed up the retrieval of data.

    • They work similar to the index in a book, allowing the database to quickly find the rows that match a certain value.

    • Examples of indexes include primary keys, unique keys, and composite indexes.

    • With...

  • Answered by AI
  • Q2. Can you discuss the numeric data types available in SQL Server?
  • Ans. 

    SQL Server offers various numeric data types for storing different types of numerical values.

    • SQL Server provides data types like int, bigint, smallint, tinyint for storing whole numbers.

    • Numeric data types like decimal and numeric are used for storing fixed-point numbers.

    • Float and real data types are used for storing floating-point numbers with different precision levels.

    • Money and smallmoney data types are used for stor

  • Answered by AI
Round 2 - Video Call 

(4 Questions)

Round duration - 60 minutes
Round difficulty - Medium

Technical round with questions based on DBMS and SSIS.

  • Q1. What is normalization in the context of database management systems?
  • Ans. 

    Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.

    • Normalization involves breaking down data into smaller, more manageable tables

    • It helps in reducing data redundancy by storing data in a structured manner

    • Normalization ensures data integrity by minimizing anomalies such as update, insert, and delete anomalies

    • There are different normal forms like 1NF, 2NF, 3NF, a

  • Answered by AI
  • Q2. Can you explain the concept of Containers in SSIS?
  • Ans. 

    Containers in SSIS are logical grouping of tasks and components that help in organizing and managing workflows.

    • Containers help in organizing and managing workflows in SSIS packages

    • They can be used to group related tasks together for better readability and maintenance

    • Examples of containers in SSIS include Sequence Container, For Loop Container, and Foreach Loop Container

  • Answered by AI
  • Q3. What are the different row transformations in SSIS?
  • Ans. 

    Different row transformations in SSIS include Conditional Split, Derived Column, Lookup, and Merge.

    • Conditional Split: Routes data rows to different outputs based on specified conditions.

    • Derived Column: Adds new columns or modifies existing columns using expressions.

    • Lookup: Retrieves data from a related table based on a specified key.

    • Merge: Combines data from multiple sources into a single dataset.

  • Answered by AI
  • Q4. What are event handlers in SSIS?
  • Ans. 

    Event handlers in SSIS are workflows that are triggered by specific events during the execution of a package.

    • Event handlers can be used to perform additional tasks or actions based on the success or failure of specific tasks within a package.

    • Common events that can trigger event handlers include OnError, OnPreExecute, OnPostExecute, OnWarning, etc.

    • Event handlers can be configured to send emails, log information, execute...

  • Answered by AI
Round 3 - Video Call 

(2 Questions)

Round duration - 60 minutes
Round difficulty - Easy

Technical round with questions based on Data warehousing and SSIS.

  • Q1. What is the difference between the Snowflake schema and the Star schema in data warehousing?
  • Ans. 

    Snowflake schema has normalized dimension tables while Star schema has denormalized dimension tables.

    • Snowflake schema has a centralized fact table connected to multiple dimension tables normalized into sub-dimension tables.

    • Star schema has a denormalized structure with dimension tables directly connected to the fact table.

    • Snowflake schema requires more joins for querying data compared to Star schema.

    • Star schema is easie...

  • Answered by AI
  • Q2. What is the difference between Merge and Union All transformations in SQL?
  • Ans. 

    Merge combines two result sets into one, while Union All combines and includes duplicates.

    • Merge is used to combine two result sets into one, eliminating duplicates.

    • Union All is used to combine two result sets into one, including duplicates.

    • Merge requires the result sets to have the same number of columns and compatible data types.

    • Union All does not require the result sets to have the same number of columns or data type

  • Answered by AI
Round 4 - HR 

Round duration - 30 minutes
Round difficulty - Easy

Typical HR round with behavioral problems.

Interview Preparation Tips

Professional and academic backgroundI completed Computer Science Engineering from Delhi Technological University. Eligibility criteriaAbove 7 CGPAPolicyBazaar.com interview preparation:Topics to prepare for the interview - Database, SSIS, Algorithms, System Design, Operating SystemsTime required to prepare for the interview - 4 monthsInterview preparation tips for other job seekers

Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.

Application resume tips for other job seekers

Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.

Final outcome of the interviewSelected

Skills evaluated in this interview

Rate your
company

🤫 100% anonymous

How was your last interview experience?

Share interview

I applied via Naukri.com and was interviewed in Mar 2021. There were 6 interview rounds.

Interview Questionnaire 

10 Questions

  • Q1. 1. What is indexing. some practical questions based on indexing?
  • Q2. 2. What is Bookmarking, Row id, Key Index, covering index?
  • Ans. 

    Explanation of database terms: Bookmarking, Row id, Key Index, covering index.

    • Bookmarking is a feature that allows users to save the location of a record in a database for future reference.

    • Row id is a unique identifier assigned to each row in a table.

    • Key Index is an index created on a column or set of columns that uniquely identifies each row in a table.

    • Covering index is an index that contains all the columns required ...

  • Answered by AI
  • Q3. 3.Details of all types of Data Types
  • Ans. 

    Data types are classifications of data items that determine the nature of operations that can be performed on them.

    • Numeric data types: int, float, double, decimal

    • Character and string data types: char, varchar, text

    • Date and time data types: date, time, datetime

    • Boolean data type: bool

    • Binary data types: binary, varbinary, image

  • Answered by AI
  • Q4. 4. What is Normalization
  • Ans. 

    Normalization is the process of organizing data in a database to reduce redundancy and dependency.

    • It involves breaking down a table into smaller tables and defining relationships between them.

    • Normalization helps to eliminate data inconsistencies and anomalies.

    • There are different levels of normalization, with each level having specific rules to follow.

    • For example, first normal form (1NF) requires that each column in a t...

  • Answered by AI
  • Q5. 5.Containers in SSIS
  • Ans. 

    Containers in SSIS are logical groupings of tasks and containers that define the workflow of an SSIS package.

    • Containers can be used to group related tasks together and provide a clear visual representation of the package workflow.

    • There are several types of containers in SSIS, including Sequence Containers, For Loop Containers, and Foreach Loop Containers.

    • Sequence Containers are used to group tasks together and define t...

  • Answered by AI
  • Q6. 6.Types of Transformations in SSIS?
  • Ans. 

    Transformations in SSIS are used to modify data during ETL process.

    • Data Conversion Transformation

    • Conditional Split Transformation

    • Aggregate Transformation

    • Sort Transformation

    • Merge Transformation

    • Lookup Transformation

    • Derived Column Transformation

    • Multicast Transformation

    • Union All Transformation

    • Pivot Transformation

    • Unpivot Transformation

  • Answered by AI
  • Q7. 7.Event Handling and Error Handling in SSIS?
  • Ans. 

    Event and error handling are crucial in SSIS to ensure smooth execution and proper handling of exceptions.

    • Event handling involves capturing and responding to events that occur during package execution.

    • Error handling involves identifying and handling errors that occur during package execution.

    • SSIS provides various built-in event handlers and error handlers, such as OnError, OnTaskFailed, OnPostExecute, etc.

    • Custom event ...

  • Answered by AI
  • Q8. 8.Star Flake and Snow Flake Schema which one's performance is better?
  • Ans. 

    Snow Flake Schema has better performance than Star Flake Schema.

    • Snow Flake Schema has normalized tables which reduces data redundancy and improves query performance.

    • Star Flake Schema has denormalized tables which can lead to data redundancy and slower query performance.

    • Snow Flake Schema is better suited for complex queries with multiple joins.

    • Star Flake Schema is better suited for simple queries with fewer joins.

    • Perfor...

  • Answered by AI
  • Q9. 9.What is Temp Variables, Temp Tables, CTE
  • Ans. 

    Temp variables, tables, and CTE are used in SQL to store temporary data during query execution.

    • Temp variables are used to store temporary data within a query.

    • Temp tables are used to store temporary data that can be accessed by multiple queries.

    • CTE (Common Table Expression) is a temporary result set that can be referenced within a SELECT, INSERT, UPDATE, or DELETE statement.

    • Temp variables and tables are created using th...

  • Answered by AI
  • Q10. 10. Difference between merge and union?
  • Ans. 

    Merge combines two tables based on a specified condition, while union combines two tables with the same structure.

    • Merge is used to update or insert data into a target table based on a join condition with a source table.

    • Union is used to combine the results of two SELECT statements into a single result set.

    • Merge requires a join condition and can perform insert, update, and delete operations.

    • Union requires that both table...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Look Good. Be Confident, Always wear a watch during Interview. Try to make eye contact even you can't see interviewer on screen

Skills evaluated in this interview

Senior Database Developer Interview Questions Asked at Other Companies

Q1. Can you discuss the numeric data types available in SQL Server?
Q2. What is the difference between Merge and Union All transformation ... read more
Q3. What is the difference between the Snowflake schema and the Star ... read more
Q4. 8.Star Flake and Snow Flake Schema which one's performance is bet ... read more
Q5. What is indexing in the context of databases?

Interview questions from similar companies

I was interviewed before Sep 2020.

Round 1 - Coding Test 

(1 Question)

Round duration - 90 minutes
Round difficulty - Easy

This was MCQ+Coding round.

  • Q1. How can you check if two strings are anagrams of each other?
  • Ans. 

    Check if two strings are anagrams by comparing the sorted versions of the strings.

    • Sort both strings and compare if they are equal.

    • Use a hashmap to store the frequency of characters in each string and compare the maps.

    • Ignore spaces and punctuation when comparing the strings.

  • Answered by AI
Round 2 - Face to Face 

Round duration - 90 minutes
Round difficulty - Easy

This was face to face interview round.

Round 3 - Face to Face 

Round duration - 90 minutes
Round difficulty - Easy

This was face to face interview round.

Interview Preparation Tips

Professional and academic backgroundI completed Computer Science Engineering from National Institute Of Technology, Silchar, Assam. I applied for the job as SDE - 1 in SiddharthnagarEligibility criteria6 CGPAAmazon interview preparation:Topics to prepare for the interview - Basic Computer Science backgroundTime required to prepare for the interview - 6 monthsInterview preparation tips for other job seekers

Tip 1 : Participate in live contests on websites like Codechef, Codeforces etc as much as possible.
Tip 2 : Practice previous interview questions from LeetCode, GeeksForGeeks.
Tip 3 : Revise Computer Science subjects like DBMS, OOPS thoroughly.

Application resume tips for other job seekers

Add projects and Internships if you have done any and add only those things which you really know.

Final outcome of the interviewSelected

Skills evaluated in this interview

I was interviewed before Sep 2020.

Round 1 - Coding Test 

(1 Question)

Round duration - 90 Minutes
Round difficulty - Medium

Interview started at 11:00 am. It was an online round. During the coding round I submitted optimized solution and got full acceptance of the solutions.

  • Q1. 

    Detect Cycle in a Directed Graph

    You are provided with a directed graph composed of 'N' nodes. You have a matrix called 'EDGES' with dimensions M x 2, which specifies the 'M' edges in the graph. Each edge...

  • Ans. 

    Detect cycle in a directed graph using depth-first search (DFS) algorithm.

    • Use DFS to traverse the graph and detect back edges indicating a cycle.

    • Maintain a visited array to keep track of visited nodes during traversal.

    • If a node is visited again during traversal and it is not the parent node, then a cycle exists.

    • Return true if a cycle is detected, false otherwise.

  • Answered by AI
Round 2 - Face to Face 

(1 Question)

Round duration - 80 Minutes
Round difficulty - Medium

Interview started at 10:00 am. Interview went well, I was able to connect with the interviewer and enjoyed the whole interview

  • Q1. 

    Next Smallest Palindrome Problem Statement

    Find the next smallest palindrome strictly greater than a given number 'N' represented as a string 'S'.

    Explanation:

    You are given a number in string format, a...

  • Ans. 

    Find the next smallest palindrome greater than a given number represented as a string.

    • Convert the string to an integer, find the next greater palindrome, and convert it back to a string.

    • Handle cases where the number is a palindrome or has all digits as '9'.

    • Consider both odd and even length numbers when finding the next palindrome.

  • Answered by AI
Round 3 - Face to Face 

(1 Question)

Round duration - 80 Minutes
Round difficulty - Medium

Interview started at 11:00 am. Interview went well.

  • Q1. 

    Boundary Traversal of a Binary Tree

    Given a binary tree of integers, your task is to return the boundary nodes of the tree in Anti-Clockwise direction starting from the root node.

    Input:

    The first line ...
  • Ans. 

    Return the boundary nodes of a binary tree in Anti-Clockwise direction starting from the root node.

    • Traverse the left boundary nodes in a top-down manner

    • Traverse the leaf nodes from left to right

    • Traverse the right boundary nodes in a bottom-up manner

    • Handle cases where duplicates occur in the boundary nodes

    • Implement the function without printing as printing is already managed

  • Answered by AI

Interview Preparation Tips

Eligibility criteriaGood knowledge of Data Structures, Some great projects which are used by the usersAmazon interview preparation:Topics to prepare for the interview - Data Structures, Web development, System Design, Algorithms, Dynamic Programming, Database, OS, Networking, OOPS, DevOpsTime required to prepare for the interview - 8 monthsInterview preparation tips for other job seekers

Tip 1 : For Data Structures number of questions doesn't matter. Try to understand the logic behind them and try to apply them in creating multiple scenario's. Learn them by heart. 
Tip 2 : For Web.Development Try to learn full stack development. See which part interests you more, Increase your knowledge horizon, Always try to build a system a system considering It will be served to millions of customers. By doing this 1-2 projects will increase and cover all the major things which one should learn in their career/college.

Application resume tips for other job seekers

Tip 1 : Always try to make it a single page 
Tip 2 : Always make resume company specific. eg. Data Structures part more if you are applying for MNC's eg. Amazon, Google, DE Shaw, browserstack.

Final outcome of the interviewSelected

Skills evaluated in this interview

I was interviewed before Sep 2020.

Round 1 - Coding Test 

Round duration - 60 minutes
Round difficulty - Easy

Round 2 - Face to Face 

Round duration - 50 minutes
Round difficulty - Easy

Round 3 - Face to Face 

Round duration - 60 minutes
Round difficulty - Easy

At the beginning of this round, the interviewer asked me about the data structures I knew. Linked lists, trees, graphs, arrays etc. was my answer. He asked me how well I knew Dynamic Programming. I said I wasn’t strong in that and he said that he would ask me a question on dynamic programming for sure.

Round 4 - Face to Face 

Round duration - 40 minutes
Round difficulty - Easy

 

The interviewer asked me if I was comfortable with the interview process so far and how the previous interviews were. I said it was good and he gave me the first problem to solve.

Round 5 - Face to Face 

(1 Question)

Round duration - 60 minutes
Round difficulty - Easy

The interviewer asked me some Com­puter Sci­ence‍ fundamentals in this round as well as some behavioural questions.

  • Q1. Implement a Trie data structure and write functions to insert and search for a few words in it.
  • Ans. 

    Implement a Trie data structure with insert and search functions.

    • Create a TrieNode class with children and isEndOfWord attributes.

    • Implement insert function to add words by iterating through characters.

    • Implement search function to check if a word exists by traversing the Trie.

    • Example: Insert 'apple', 'banana', 'orange' and search for 'apple' and 'grape'.

  • Answered by AI

Interview Preparation Tips

Professional and academic backgroundI applied for the job as SDE - 1 in HyderabadEligibility criteria 7 CGPA Amazon interview preparation:Topics to prepare for the interview - Data Structures and Algorithms, Operating System, Database Management System, Object-Oriented Programming SystemTime required to prepare for the interview - 8 monthsInterview preparation tips for other job seekers

Do lot of hard work and practice of  Data Structures and Algorithms based questions. I personally recommend you Coding Ninjas and Geeks For Geeks for interview preparation.

Application resume tips for other job seekers

Make your resume short and try to make it of one page only and do mention all your skills which you are confident of in your resume.

Final outcome of the interviewSelected

Skills evaluated in this interview

I was interviewed before May 2021.

Round 1 - Coding Test 

Round duration - 90 minutes
Round difficulty - Medium

 Around 65-70 people sat for the test. 15 people were shortlisted. It consisted of the following to be done in 90 minutes.

- 28 MCQs based on core CS 

- 2 Coding questions – everyone had different and random questions. Most questions were custom logic based (easy level) including some standard questions – LCS, LIS, topological sort.

Round 2 - Face to Face 

(2 Questions)

Round duration - 60 minutes
Round difficulty - Easy

Interviewer was very friendly. It started with the standard – tell me about yourself / introduce yourself type of question. Then he proceeded and asked two coding questions

  • Q1. 

    Remove Duplicates from a Sorted Linked List

    Your friend has homework to complete. Help him by removing duplicates from a sorted linked list.

    You are given the 'Head' of a sorted linked list. Modify the l...

  • Ans. 

    Remove duplicates from a sorted linked list without adjacent duplicates.

    • Traverse the linked list while comparing current and next nodes.

    • If they are equal, skip the next node by updating the current node's next pointer.

    • Repeat until the end of the list is reached.

  • Answered by AI
  • Q2. 

    Course Schedule Problem Statement

    You are enrolled as a student and must complete N courses, numbered from 1 to N, to earn your degree.

    Some courses have prerequisites, which means that to take course i,...

  • Ans. 

    Check if it is feasible to complete all courses with prerequisites.

    • Create a graph representing the prerequisites with courses as nodes and edges as prerequisites.

    • Perform a topological sort on the graph to check if there is a cycle (if there is, then it's not feasible to complete all courses).

    • If there is no cycle, then it is feasible to complete all courses.

  • Answered by AI
Round 3 - Face to Face 

(1 Question)

Round duration - 60 minutes
Round difficulty - Medium

This round had only 1 question. The interviewer introduced himself. And he advised me to clearly understand the problem before proceeding.

  • Q1. 

    LCA of Binary Tree Problem Statement

    You are given a binary tree of distinct integers, along with two nodes, ‘X’ and ‘Y’. Your task is to determine the Lowest Common Ancestor (LCA) of ‘X’ and ‘Y’.

    The LC...

  • Ans. 

    Find the Lowest Common Ancestor of two nodes in a binary tree.

    • Traverse the binary tree to find the paths from the root to nodes X and Y.

    • Compare the paths to find the last common node, which is the Lowest Common Ancestor.

    • Implement a recursive function to efficiently find the LCA.

    • Handle cases where one node is an ancestor of the other.

    • Consider edge cases like when X or Y is the root node.

  • Answered by AI
Round 4 - Face to Face 

(4 Questions)

Round duration - 60 minutes
Round difficulty - Medium

Pretty Good Round. Fast Paced. We covered a lot of ground.

  • Q1. 

    Binary Search Tree Iterator Problem Statement

    Design and implement a class BSTIterator to perform an in-order traversal over a Binary Search Tree (BST). Your implementation should include the following me...

  • Ans. 

    Design and implement a class BSTIterator to perform in-order traversal over a Binary Search Tree (BST).

    • Implement a parameterized constructor to initialize the iterator with the root of the BST.

    • Implement a method 'next()' to return the next smallest element in in-order traversal.

    • Implement a method 'hasNext()' to check if there exists a next smallest element in traversal.

    • Ensure the output is the in-order traversal of the

  • Answered by AI
  • Q2. 

    Maximum Consecutive Ones Problem Statement

    Given a binary array 'ARR' of size 'N', your task is to determine the maximum length of a sequence consisting solely of 1’s that can be obtained by converting at...

  • Ans. 

    Find the maximum length of a sequence of 1's by converting at most K zeroes into ones in a binary array.

    • Iterate through the array and keep track of the current window of 1's and zeroes.

    • Use a sliding window approach to find the maximum length of consecutive 1's by flipping at most K zeroes.

    • Update the window based on the number of zeroes flipped and keep track of the maximum length found so far.

    • Return the maximum length ...

  • Answered by AI
  • Q3. 

    BFS in Graph Problem Statement

    You are given an undirected and disconnected graph G(V, E) having V vertices numbered from 0 to V-1 and E edges. Your task is to print its BFS traversal starting from the 0t...

  • Ans. 

    BFS traversal of an undirected and disconnected graph starting from vertex 0.

    • Start BFS traversal from vertex 0 and visit all connected nodes in sorted order.

    • Use a queue to keep track of nodes to visit next.

    • Keep a visited array to avoid revisiting nodes.

    • Print the BFS traversal path as the nodes are visited.

    • Example: For input V=5, E=4 and edges 0-1, 0-2, 1-3, 2-4, the BFS traversal will be [0, 1, 2, 3, 4].

  • Answered by AI
  • Q4. 

    Dijkstra's Shortest Path Problem Statement

    Given an undirected graph with V vertices (labeled 0, 1, ..., V-1) and E edges, each edge connects two nodes X and Y with a specified weight representing the dis...

  • Ans. 

    Dijkstra's algorithm is used to find the shortest path distance from a source node to all other nodes in an undirected graph.

    • Implement Dijkstra's algorithm to find the shortest path distance from node 0 to all other nodes in the graph.

    • Use a priority queue to efficiently select the next node with the shortest distance.

    • Initialize distances to all nodes as infinity, except for the source node which is 0.

    • Update distances t...

  • Answered by AI
Round 5 - Face to Face 

(1 Question)

Round duration - 60 minutes
Round difficulty - Hard

Bar Raised Round. Definitely felt the difficulty.

  • Q1. 

    First Non-Repeating Character Problem Statement

    You are given a string consisting of English alphabet characters. Your task is to identify and return the first character in the string that does not repeat...

  • Ans. 

    Identify and return the first non-repeating character in a string, or the first character if all characters repeat.

    • Iterate through the string to count the frequency of each character

    • Iterate through the string again to find the first character with frequency 1

    • If no such character is found, return the first character of the string

  • Answered by AI

Interview Preparation Tips

Professional and academic backgroundI applied for the job as SDE - 1 in BangaloreEligibility criteriaNo criteriaAmazon interview preparation:Topics to prepare for the interview - Linked Lists, Trees, BFS, DFS, Backtracking, Graphs.Time required to prepare for the interview - 3 monthsInterview preparation tips for other job seekers

Tip 1 : Practice at least 250 Questions, Give yourself enough time for preparation. Cramming won't take you very far. In books, I really liked Elements of Programming Interviews. 
Tip 2 : Make sure to brush up your basics - coding style, OOPs, Language features. They help in making an impression.
Tip 3 : Don't worry about solving the question in the interview. Learn to tackle any random problem with the best of your ability. More often than not, that'd be enough.

Application resume tips for other job seekers

Tip 1 : Keep your resume clean - no graphics, no multiple fonts. Keep it one page.
Tip 2 : Don't go over board in mentioning skills, only mention the things you are truly confident about.

Final outcome of the interviewSelected

Skills evaluated in this interview

I was interviewed in Aug 2017.

Interview Questionnaire 

7 Questions

  • Q1. Implement Merge Sort.
  • Ans. 

    Merge Sort is a divide and conquer algorithm that sorts an array by dividing it into two halves, sorting them separately, and then merging the sorted halves.

    • Divide the array into two halves

    • Recursively sort the two halves

    • Merge the sorted halves

  • Answered by AI
  • Q2. Given a BST containing distinct integers, and a number ‘X’, find all pairs of integers in the BST whose sum is equal to ‘X’.
  • Ans. 

    Find pairs of integers in a BST whose sum is equal to a given number.

    • Traverse the BST and store the values in a hash set.

    • For each node, check if (X - node.value) exists in the hash set.

    • If yes, add the pair (node.value, X - node.value) to the result.

    • Continue traversal until all nodes are processed.

  • Answered by AI
  • Q3. Given a set of time intervals in any order, merge all overlapping intervals into one and output the result which should have only mutually exclusive intervals.
  • Ans. 

    Merge overlapping time intervals into mutually exclusive intervals.

    • Sort the intervals based on their start time.

    • Iterate through the intervals and merge overlapping intervals.

    • Output the mutually exclusive intervals.

    • Example: [(1,3), (2,6), (8,10), (15,18)] -> [(1,6), (8,10), (15,18)]

  • Answered by AI
  • Q4. What are the different types of hashing? Suggest an alternative and a better way for Linear Chaining.
  • Ans. 

    Different types of hashing and alternative for Linear Chaining

    • Different types of hashing include division, multiplication, and universal hashing

    • Alternative for Linear Chaining is Open Addressing

    • Open Addressing includes Linear Probing, Quadratic Probing, and Double Hashing

  • Answered by AI
  • Q5. Implement AVL Tree.
  • Ans. 

    An AVL tree is a self-balancing binary search tree where the heights of the left and right subtrees differ by at most one.

    • AVL tree is a binary search tree with additional balance factor for each node.

    • The balance factor is the difference between the heights of the left and right subtrees.

    • Insertion and deletion operations in AVL tree maintain the balance factor to ensure the tree remains balanced.

    • Rotations are performed ...

  • Answered by AI
  • Q6. Minimum number of squares whose sum equals to given number n.
  • Ans. 

    Find the minimum number of squares whose sum equals to a given number n.

    • Use dynamic programming to solve the problem efficiently.

    • Start with finding the square root of n and check if it is a perfect square.

    • If not, then try to find the minimum number of squares required for the remaining number.

    • Repeat the process until the remaining number becomes 0.

    • Return the minimum number of squares required for the given number n.

  • Answered by AI
  • Q7. Insertion sort for a singly linked list.
  • Ans. 

    Insertion sort for a singly linked list.

    • Traverse the list and compare each node with the previous nodes

    • If the current node is smaller, swap it with the previous node

    • Repeat until the end of the list is reached

    • Time complexity is O(n^2)

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: There were 2 coding questions (no penalty for wrong submission) and 20 Multiple Choice Questions(with negative marking). We were given 90 minutes to solve them. MCQs were based on Data Structures, OS, CN, C outputs, OOP etc.
Tips: Experience in Competitive Programming might help in solving coding questions. No constraints were mentioned and detailed Instructions related to problem were stated vaguely. So code carefully.
Duration: 1 hour 30 minutes
Total Questions: 22

Round: Technical Interview
Experience: The interviewer asked me to introduce myself and a brief introduction of the projects that I have done. She first asked me questions related to my project. After that she moved on to the data structures part.
Tips: Take your time to approach the problems and if the question is not clear ask the interviewer to explain it again.

Round: Technical Interview
Experience: The interviewer asked me about how my previous round went. After that, he asked me to introduce myself and a brief introduction of the projects that I have done. He first asked me a few questions related to my project. Then he moved on to the data structures part. In this round the interviewer gave me strict time limit for coding the solution on paper for each problem and as soon as I was done coding he gave me 2-3 minutes every time to find errors and debug my code.
Tips: Do not panic even if the interviewer sets time limit while solving problems. If the question is not clear ask the interviewer to explain it again.

College Name: The LNM Institute Of Information Technology, Jaipur

Skills evaluated in this interview

I applied via Referral

Interview Questionnaire 

6 Questions

  • Q1. Design the most optimal data structures for an LRU cache
  • Ans. 

    Design optimal data structures for LRU cache

    • Use a doubly linked list to keep track of recently used items

    • Use a hash table to store key-value pairs for quick access

    • When an item is accessed, move it to the front of the linked list

    • When the cache is full, remove the least recently used item from the back of the linked list and hash table

  • Answered by AI
  • Q2. Convert a sorted array to balanced binary search tree
  • Ans. 

    Convert a sorted array to balanced binary search tree

    • Find the middle element of the array and make it the root of the tree

    • Recursively construct the left subtree using the left half of the array

    • Recursively construct the right subtree using the right half of the array

    • Repeat until all elements are added to the tree

  • Answered by AI
  • Q3. Reverse a singly linked list in groups of k in­place
  • Ans. 

    Reverse a singly linked list in groups of k in­place

    • Divide the linked list into groups of k nodes

    • Reverse each group of k nodes

    • Connect the reversed groups to form the final linked list

  • Answered by AI
  • Q4. Design the most optimal data structure for storing a word and its meaning. Note that a word could have multiple meanings
  • Ans. 

    Optimal data structure for storing words and their meanings

    • Use a hash table with the word as the key and a list of meanings as the value

    • Each meaning can be stored as a string or an object with additional information

    • Consider using a trie data structure for efficient prefix search

    • Implement a search function that can handle partial matches and synonyms

  • Answered by AI
  • Q5. Write a recursive routine to calculate a ^ n
  • Ans. 

    A recursive routine to calculate a ^ n

    • The base case is when n is 0, in which case the result is 1

    • For any other value of n, the result is a multiplied by the result of a^(n-1)

    • The recursive function should call itself with a^(n-1) as the new input

  • Answered by AI
  • Q6. Design the most optimal data structure for a never ending stream of numbers. It should be optimized for insertion, deletion, searching, finding kth largest and kth smallest
  • Ans. 

    Design optimal data structure for never-ending stream of numbers for insertion, deletion, searching, kth largest and kth smallest.

    • Use a balanced binary search tree like AVL or Red-Black tree for efficient insertion, deletion, and searching.

    • Maintain two heaps, one for kth largest and one for kth smallest.

    • For finding kth largest, use a min heap of size k and for kth smallest, use a max heap of size k.

    • Alternatively, use a...

  • Answered by AI

Interview Preparation Tips

Skills:
College Name: NA

Skills evaluated in this interview

Interview Preparation Tips

Round: Test
Duration: 2 hours
Total Questions: 22

College Name: Jaypee University Of Information Technology, Solan

I was interviewed before Sep 2016.

Interview Questionnaire 

5 Questions

  • Q1. Search an element in sorted rotated array.
  • Ans. 

    Search an element in sorted rotated array.

    • Use binary search to find the pivot point where the array is rotated.

    • Divide the array into two subarrays and perform binary search on the appropriate subarray.

    • Handle the cases where the target element is at the pivot point or not present in the array.

  • Answered by AI
  • Q2. Kth largest element in an array.
  • Ans. 

    Find the Kth largest element in an array.

    • Sort the array in descending order and return the element at index K-1.

    • Use a max heap to find the Kth largest element efficiently.

    • Implement a quickselect algorithm to find the Kth largest element in linear time.

  • Answered by AI
  • Q3. Reverse a linked list in group of n element.
  • Ans. 

    Reverse a linked list in groups of n elements.

    • Divide the linked list into groups of n elements.

    • Reverse each group individually.

    • Connect the reversed groups to form the final linked list.

    • Handle cases where the number of elements is not a multiple of n.

    • Example: 1->2->3->4->5->6->7->8, n=3 -> 3->2->1->6->5->4->8->7

  • Answered by AI
  • Q4. Median of two sorted array.
  • Ans. 

    Find the median of two sorted arrays.

    • Merge the two arrays into one sorted array and find the median.

    • Use binary search to find the median in O(log(min(m, n))) time complexity.

    • Handle edge cases like empty arrays or arrays of different lengths.

  • Answered by AI
  • Q5. It was a DP question. In a matrix, I have to count number of paths from (0, 0) to (m, n) while crossing through some indexes were not allowed.
  • Ans. 

    Count number of paths from (0, 0) to (m, n) in a matrix while crossing through some indexes were not allowed.

    • Use dynamic programming to solve the problem

    • Create a 2D array to store the number of paths

    • Traverse the matrix and update the array based on the allowed paths

    • Return the value at the last index of the array

  • Answered by AI

Interview Preparation Tips

Round: Technical Interview
Experience: Interviewer was mainly focused on problem solving skill.

College Name: KIIT University

Skills evaluated in this interview

Contribute & help others!
anonymous
You can choose to be anonymous

PolicyBazaar Interview FAQs

What are the top questions asked in PolicyBazaar Senior Database Developer interview?

Some of the top questions asked at the PolicyBazaar Senior Database Developer interview -

  1. 8.Star Flake and Snow Flake Schema which one's performance is bett...read more
  2. 2. What is Bookmarking, Row id, Key Index, covering ind...read more
  3. 9.What is Temp Variables, Temp Tables, ...read more

Recently Viewed

PHOTOS

InsuranceDekho

3 office photos

LIST OF COMPANIES

Credit Bajaar

Overview

SALARIES

Info Edge

JOBS

Info Edge

No Jobs

SALARIES

Info Edge

SALARIES

Ola Cabs

JOBS

Info Edge

No Jobs

JOBS

Square Yards

No Jobs

SALARIES

Info Edge

SALARIES

Info Edge

Tell us how to improve this page.

Anonymously discuss salaries, work culture, and many more

Get Ambitionbox App

Join PolicyBazaar Let's find you the Best Insurance

Interview Questions from Similar Companies

Amazon Interview Questions
4.1
 • 5.1k Interviews
Flipkart Interview Questions
4.0
 • 1.4k Interviews
BigBasket Interview Questions
3.9
 • 357 Interviews
JustDial Interview Questions
3.5
 • 329 Interviews
CARS24 Interview Questions
3.6
 • 327 Interviews
Zomato Interview Questions
3.7
 • 322 Interviews
Info Edge Interview Questions
3.9
 • 320 Interviews
Lenskart Interview Questions
3.2
 • 302 Interviews
Square Yards Interview Questions
4.0
 • 199 Interviews
View all

PolicyBazaar Senior Database Developer Reviews and Ratings

based on 1 review

5.0/5

Rating in categories

4.0

Skill development

5.0

Work-life balance

4.0

Salary

5.0

Job security

5.0

Company culture

5.0

Promotions

4.0

Work satisfaction

Explore 1 Review and Rating
Sales Executive
1.2k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Sales Consultant
1.1k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Relationship Manager
608 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Sales Associate
381 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Team Lead
380 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare PolicyBazaar with

Coverfox

4.2
Compare

BankBazaar

3.4
Compare

Paytm Money

3.2
Compare

Easypolicy.com

3.4
Compare
Did you find this page helpful?
Yes No
write
Share an Interview