Add office photos
Engaged Employer

Oracle

3.7
based on 5.3k Reviews
Video summary
Filter interviews by

10+ Holbrook Infra & Power Interview Questions and Answers

Updated 10 Sep 2024
Popular Designations

Q1. What is static and dynamic binding in java

Ans.

Static binding is resolved at compile time while dynamic binding is resolved at runtime in Java.

  • Static binding is also known as early binding.

  • Dynamic binding is also known as late binding.

  • Example of static binding: method overloading.

  • Example of dynamic binding: method overriding.

Add your answer

Q2. Design schema and draw ER diagram for Airport Management System

Ans.

Airport Management System schema and ER diagram design

  • Entities: Airport, Flight, Passenger, Employee, Schedule

  • Attributes: Airport (code, name, location), Flight (number, destination, departure time), Passenger (name, age, contact info), Employee (ID, name, role), Schedule (flight number, date, time)

  • Relationships: Airport has many Flights, Flight has many Passengers, Employee works at Airport, Flight has Schedule

Add your answer

Q3. Normalize a given table; I normalized it up to 3NF.

Ans.

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

  • Identify the functional dependencies in the table

  • Eliminate partial dependencies by breaking the table into multiple tables

  • Eliminate transitive dependencies by further breaking down the tables

  • Ensure each table has a primary key and all non-key attributes are fully functionally dependent on the primary key

Add your answer

Q4. Differences between PUT and POST, and write POST method

Ans.

PUT is used to update or replace an existing resource, while POST is used to create a new resource.

  • PUT is idempotent, meaning multiple identical requests will have the same effect as a single request

  • POST is not idempotent, meaning multiple identical requests may have different effects

  • PUT is used to update an existing resource at a specific URI

  • POST is used to create a new resource under a specific URI

  • Example: PUT /users/123 updates user with ID 123, POST /users creates a new u...read more

Add your answer
Discover Holbrook Infra & Power interview dos and don'ts from real experiences

Q5. What are JAR files?

Ans.

JAR files are Java Archive files that store multiple Java class files and related metadata.

  • JAR files are used to package Java classes, resources, and metadata into a single file.

  • They are commonly used for distributing Java libraries or applications.

  • JAR files can be created using the 'jar' command in Java.

  • They can also be executed using the 'java -jar' command.

  • Example: mylibrary.jar contains all the class files and resources needed for a Java library.

Add your answer

Q6. Explain wait() and signal()

Ans.

wait() and signal() are functions used for synchronization in multithreading.

  • wait() is used to make a thread wait until a certain condition is met

  • signal() is used to wake up a waiting thread when the condition is met

  • Example: Producer-consumer problem where producer signals consumer to consume when a new item is produced

Add your answer

Q7. Explain REST with examples

Ans.

REST is an architectural style for designing networked applications

  • REST stands for Representational State Transfer

  • It uses standard HTTP methods like GET, POST, PUT, DELETE

  • Resources are identified by URIs

  • Data is transferred in JSON or XML format

  • Example: GET request to 'https://api.example.com/users' to retrieve a list of users

Add your answer

Q8. Singleton Class example

Ans.

A Singleton class is a class that can only have one instance created at a time.

  • Singleton classes are often used for managing resources that should only have one instance, such as a database connection.

  • To implement a Singleton class, you typically make the constructor private and provide a static method to access the single instance.

  • Example: Singleton class for logging system where only one instance of the logger is needed.

Add your answer

Q9. CAP Theorem and its trade-offs

Ans.

CAP Theorem states that in a distributed system, it is impossible to simultaneously guarantee consistency, availability, and partition tolerance.

  • Consistency: All nodes in the system have the same data at the same time.

  • Availability: Every request gets a response, even if some nodes are down.

  • Partition Tolerance: The system continues to operate despite network partitions.

  • Trade-offs: In a distributed system, you can only have two out of the three - Consistency, Availability, and ...read more

Add your answer

Q10. Sort the linked list

Ans.

Sorting a linked list involves rearranging the nodes in a specific order.

  • Iterate through the linked list and compare each node with the next one

  • Use a sorting algorithm like bubble sort, merge sort, or quick sort to rearrange the nodes

  • Update the pointers to connect the nodes in the sorted order

Add your answer

More about working at Oracle

#22 Best Mega Company - 2022
#3 Best Internet/Product Company - 2022
Contribute & help others!
Write a review
Share interview
Contribute salary
Add office photos

Interview Process at Holbrook Infra & Power

based on 3 interviews
Interview experience
4.3
Good
View more
Interview Tips & Stories
Ace your next interview with expert advice and inspiring stories

Top Quality Analyst Interview Questions from Similar Companies

4.0
 • 20 Interview Questions
3.5
 • 10 Interview Questions
3.1
 • 10 Interview Questions
View all
Share an Interview
Stay ahead in your career. Get AmbitionBox app
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
75 Lakh+

Reviews

5 Lakh+

Interviews

4 Crore+

Salaries

1 Cr+

Users/Month

Contribute to help millions

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter