i
NoBroker
Filter interviews by
I was interviewed in Dec 2021.
Round duration - 60 minutes
Round difficulty - Easy
This was a technical interview round with questions on DSA, OOPS and Low Level design.
Level Order Traversal can be used here.
Algorithm :
1. Maintain a hash map for the branch of each node.
2. Traverse the tree in level order fashion.
3. In level order traversal, maintain a queue which holds, node and its vertical branch.
* pop from queue.
* add this node's data in vector corresponding to its branch in the hash.
* if this node hash left child, insert in the queue, left with branch - 1.
* if this node hash...
Why is Java called an Object Oriented Programming Language?
Java is purely an object oriented language due to the absence of global scope, Everything in java is an object, all the program codes and data resides within classes and objects. It comes with an extensive set of classes, arranged in packages, object model in java in sample and easy to extend.
What is indexing and partitioning in DBMS?
Indexing is used to optimize the performance of a database by minimizing the number of disk accesses required when a query is processed. The index is a type of data structure. It is used to locate and access the data in a database table quickly.
Index structure:
Indexes can be created using some database columns.
The first column of the database is the search key that contains a copy of the primary key or candidate key of...
Design a movie site booking portal using objects and classes. Design the table diagram and the ways different tables will be linked for a movie booking website like bookmyshow.
Tip 1 : Firstly, remember that the system design round is extremely open-ended and there’s no such thing as a standard answer. Even for the same question, you’ll have a totally different discussion with different interviewers.
Tip 2 : Before you jump into the solution always clarify all the assumptions you’re making at the beginning of the interview. Ask questions to identify the scope of the system. This will clear the...
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.
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.
I applied via Naukri.com and was interviewed in Dec 2021. There was 1 interview round.
OOPs stands for Object Oriented Programming. Java is called an OOP language because it follows the principles of OOP.
OOPs is a programming paradigm that focuses on objects and their interactions.
Java supports the four main principles of OOP: encapsulation, inheritance, polymorphism, and abstraction.
Encapsulation allows bundling of data and methods into a single unit, providing data hiding and security.
Inheritance enabl...
Indexing and partitioning are techniques used in DBMS to improve performance and manage large amounts of data.
Indexing is the process of creating a data structure that allows for faster retrieval of data based on certain columns or fields.
Partitioning involves dividing a large table into smaller, more manageable parts called partitions, which can be stored on different disks or servers.
Both techniques can improve query...
Print the vertical level traversal of a binary tree.
Traverse the tree and assign horizontal distance to each node.
Store nodes in a map with their horizontal distance as key.
Print nodes in each horizontal distance in vertical order.
Design table diagram and link tables for a movie booking website like bookmyshow.
Create tables for movies, theaters, users, bookings, payments, and reviews
Link movies and theaters through a many-to-many relationship
Link users and bookings through a one-to-many relationship
Link bookings and payments through a one-to-one relationship
Link movies and reviews through a one-to-many relationship
Design a movie booking portal using objects and classes.
Create a Movie class with attributes like title, genre, duration, etc.
Create a Theater class with attributes like name, location, capacity, etc.
Create a Show class with attributes like movie, theater, showtime, price, etc.
Create a Booking class with attributes like show, seats, user, etc.
Implement methods for booking tickets, canceling tickets, etc.
Use database to...
Top trending discussions
based on 1 review
Rating in categories
Relationship Manager
777
salaries
| ₹1.7 L/yr - ₹7.5 L/yr |
Territory Sales Manager
463
salaries
| ₹4 L/yr - ₹10.2 L/yr |
Sales Executive
320
salaries
| ₹1.1 L/yr - ₹6.7 L/yr |
Unit Head
291
salaries
| ₹2.5 L/yr - ₹6.5 L/yr |
Key Account Manager
256
salaries
| ₹2.8 L/yr - ₹9.5 L/yr |
MagicBricks
Nestaway
99acres
CommonFloor