i
Oracle
Filter interviews by
I applied via Campus Placement and was interviewed in Aug 2024. There were 4 interview rounds.
Round 1: HackerRank Test (100 Minutes)
1 DSA question (medium level, binary search on answers)
20 technical questions (OS, DBMS, CN, and other CS fundamentals)
15 general aptitude and communication questions
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.
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
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 reso
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 nee
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 h...
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
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
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
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
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...
I applied via Campus Placement and was interviewed in Aug 2023. There was 1 interview round.
I applied via Campus Placement and was interviewed in Jan 2024. There was 1 interview round.
90 mins, difficulty-moderate , 30 mcq's , 1 SQLquery question, 1 coding question
What people are saying about Oracle
Oracle interview questions for designations
posted on 29 Sep 2021
I applied via Recruitment Consultant and was interviewed in Mar 2021. There were 4 interview rounds.
posted on 29 Oct 2024
I applied via Job Portal and was interviewed before Oct 2023. There was 1 interview round.
Binary First Search is a search algorithm that explores the nodes in a binary tree in a level-order traversal.
Start at the root node and add it to a queue.
While the queue is not empty, dequeue a node and visit it. Then enqueue its children.
Repeat until all nodes have been visited.
posted on 20 Feb 2025
These are some tests they have copied from other organizations.
posted on 28 May 2021
I applied via Recruitment Consultant and was interviewed in Apr 2021. There were 3 interview rounds.
Printing reverse of string without inbuilt function and start printing from last index.
Iterate through the string from last index to first index and append each character to a new string.
Use a loop to iterate through the string and concatenate each character to the new string.
Print the new string in reverse order.
Printing reversed words in a string without using inbuilt functions
Split the string into words using space as delimiter
Iterate through each word and reverse it
Print the reversed words in the original order
posted on 15 May 2024
I applied via LinkedIn and was interviewed in Apr 2024. There was 1 interview round.
Custom reduce function in JavaScript
Create a function that takes an array, a callback function, and an initial value as parameters
Iterate through the array and apply the callback function to each element, updating the accumulator
Return the final accumulator value
Box sizing in CSS determines how the total width and height of an element is calculated.
Box-sizing property can have values of content-box (default) or border-box
content-box includes only the content, border, and padding in the width and height calculations
border-box includes the content, padding, and border in the width and height calculations
posted on 17 Jul 2024
based on 3 interviews
Interview experience
based on 11 reviews
Rating in categories
Senior Software Engineer
2.4k
salaries
| ₹10.2 L/yr - ₹40 L/yr |
Principal Consultant
2.1k
salaries
| ₹14.4 L/yr - ₹36 L/yr |
Senior Consultant
2.1k
salaries
| ₹8.7 L/yr - ₹28 L/yr |
Senior Member of Technical Staff
1.8k
salaries
| ₹12 L/yr - ₹45 L/yr |
Senior Application Engineer
1.4k
salaries
| ₹9.7 L/yr - ₹30 L/yr |
SAP
MongoDB
Salesforce
IBM