Add office photos
Engaged Employer

Oracle

3.7
based on 5k Reviews
Filter interviews by

50+ Interview Questions and Answers

Updated 30 Nov 2024
Popular Designations
Q1. Triplets with Given Sum

You are given an array/list ARR consisting of N integers. Your task is to find all the distinct triplets present in the array which adds up to a given number K.

An array is said to have a...read more

View 3 more answers
Q2. Square Root (Integral)

Given a number N, find its square root. You need to find and print only the integral part of square root of N.

For eg. if number given is 18, answer is 4.

Input format :
Integer N 
Output ...read more
View 3 more answers
Q3. Partition Equal Subset Sum

You are given an array 'ARR' of 'N' positive integers. Your task is to find if we can partition the given array into two subsets such that the sum of elements in both subsets is equal....read more

View 4 more answers
Q4. Search in a row wise and column wise sorted matrix

You are given an N * N matrix of integers where each row and each column is sorted in increasing order. You are given a target integer 'X'. Find the position of...read more

View 3 more answers
Discover null interview dos and don'ts from real experiences
Q5. Delete Kth node From End

You have been given a singly Linked List of 'N' nodes with integer data and an integer 'K'. Your task is to remove the Kth node from the end of the given Linked List.

For example:
The gi...read more
View 3 more answers
Q6. Largest subarray with equal number of 0s and 1s

You are given an array consisting of 0s and 1s. You need to find the length of the largest subarray with an equal number of 0s and 1s.

For example:

If the given ar...read more
View 3 more answers
Are these interview questions helpful?
Q7. Count Inversions

For a given integer array/list 'ARR' of size 'N', find the total number of 'Inversions' that may exist.

An inversion is defined for a pair of integers in the array/list when the following two co...read more

View 3 more answers
Q8. Pascal case of a given sentence

Given a string “STR”, you need to remove spaces from the string “STR” and rewrite in the Pascal case. Your task is to return the string “STR”.

In the Pascal case writing style we ...read more

Add your answer
Share interview questions and help millions of jobseekers 🌟
Q9. Valid Parenthesis

You're given string ‘STR’ consisting solely of “{“, “}”, “(“, “)”, “[“ and “]” . Determine whether the parentheses are balanced.

Input Format:
The first line contains an Integer 'T' which denot...read more
Add your answer
Q10. Vertical Sum in a Binary Tree

Given a binary tree having a positive integer written on each of its nodes. Your task is to find the vertical sum of node values i.e. the sum of nodes that can be connected by a ver...read more

View 2 more answers
Q11. Sum Tree

For a given binary tree, convert it to its sum tree. That is, replace every node data with sum of its immediate children, keeping leaf nodes 0. Finally, return its preorder.

For example:
The input for t...read more
Add your answer
Q12. Inplace rotate matrix 90 degree

You are given a square matrix of non-negative integers of size 'N x N'. Your task is to rotate that array by 90 degrees in an anti-clockwise direction without using any extra spac...read more

View 2 more answers
Q13. Colour the Graph

You are given a graph with 'N' vertices numbered from '1' to 'N' and 'M' edges. You have to colour this graph in two different colours, say blue and red such that no two vertices connected by an...read more

Add your answer
Q14. Convert a given number to words

Given an integer number ‘num’. Your task is to convert ‘num’ into a word.

Suppose the given number ‘num’ is ‘9823’ then you have to return a string “nine thousand eight hundred tw...read more

View 2 more answers

Q15. Spring Collections Difference between list and set What is sorted mean in hashed set java Serialization Exceptions How can you give an exception to caller method Unix- how to move a folder without giving yes/no...

read more
Ans.

Interview questions for Software Developer related to Spring, Collections, Serialization, Exceptions, Unix, Annotations, Json, Build tools, Restful services, and more.

  • List and Set are both collection interfaces in Java. List allows duplicates and maintains insertion order while Set doesn't allow duplicates and doesn't maintain any order.

  • Sorted in Hashed Set means that the elements are stored in a sorted order based on their hash code.

  • Serialization is the process of converting...read more

Add your answer
Q16. Convert Into Words

Let's say I give you a number 1,53,345 (I don't remember exactly). Write a program that will take the above number as input array and give output as "One Lakh Fifty-Three Thousand Three Hundre...read more

View 3 more answers
Q17. OOPS Questions

What is a virtual function? Give an example.

What is encapsulation? What is polymorphism?

Add your answer
Q18. SQL Queries

SQL query - Top 2 users in a table - do it using subquery, views, and joins.
SQL query - Nested query using joins.

Add your answer

Q19. What is rotational shifts. What is web service flow. How will you check ports on Unix or Solaris machine.

Ans.

Rotational shifts refer to working in different shifts at different times. Web service flow is the sequence of steps involved in a web service request. Checking ports on Unix or Solaris machine involves using the netstat command.

  • Rotational shifts involve working in different shifts at different times, such as day shift, night shift, and swing shift.

  • Web service flow involves a sequence of steps, such as sending a request, receiving a response, and processing the data.

  • To check ...read more

Add your answer
Q20. Stack basics

If I want to implement a stack then what should the value of the pointer (top of stack) in case of an empty stack? 0 or -1?

Add your answer
Q21. Excel Column Number

You have been given a column title as appears in an Excel sheet, return its corresponding column number.

View 3 more answers
Q22. Degree between an hour hand and a minute hand

Find the degree between an hour hand and a minute hand? Gave me a pen and paper to come up with the answer (it was an equation).

Add your answer
Q23. DBMS Question

1. What is Primary key and foreign key?

2. What are ACID properties?

Add your answer

Q24. Which database are you going to use for Parking lot and Why ?

Ans.

I would use a relational database like MySQL for the Parking lot as it provides structured data storage and supports complex queries.

  • Relational databases like MySQL offer structured data storage for parking lot information

  • Supports complex queries for managing parking lot data efficiently

  • Ability to handle large amounts of data and transactions

  • Provides data integrity and security features

  • Can easily integrate with other systems and applications

Add your answer

Q25. Program Based on Java String Operations. Print concatenation of Zig Zag string from a row

Ans.

Program to concatenate Zig Zag string from a row using Java String Operations.

  • Use StringBuilder to efficiently concatenate strings

  • Use loops to traverse the rows and columns of the zig zag pattern

  • Use conditional statements to determine the direction of traversal

Add your answer
Q26. What is encapsulation? What is polymorphism?
Add your answer
Q27. SQL Question

Write SQL query to get Nth highest salary

Add your answer
Q28. What is a virtual function? Give an example.
Add your answer

Q29. Tell us about Coalnet Architecture of MMS Module?

Ans.

Coalnet Architecture of MMS Module is a system for managing and monitoring coal mines.

  • Coalnet Architecture is designed to manage and monitor coal mines.

  • It includes modules for tracking production, equipment maintenance, and safety.

  • The MMS Module specifically focuses on maintenance management.

  • It allows for scheduling and tracking of maintenance tasks, as well as inventory management.

  • The architecture is scalable and can be customized to fit the needs of different mines.

  • It is bu...read more

View 1 answer

Q30. How to check ports in Solaris or linux machine

Ans.

To check ports in Solaris or Linux machine, use the netstat command.

  • Open the terminal and type 'netstat -an' to display all open ports.

  • Use 'netstat -an | grep ' to check if a specific port is open.

  • To check listening ports, use 'netstat -an | grep LISTEN'.

  • For Solaris, use 'netstat -an | grep .' instead of '| grep '.

Add your answer

Q31. Given array contain duplicate elements need to remove duplicates and after deletion oreder of remaining element should remain same..

Ans.

Remove duplicates from array of strings while maintaining original order.

  • Iterate through the array and use a Set to keep track of unique elements.

  • Add elements to a new array only if they are not already in the Set.

Add your answer

Q32. What is the difference between iterator and geneator

Ans.

Iterator is a design pattern that allows sequential access to elements, while generator is a function that can pause and resume execution.

  • Iterator is an object that provides a way to access elements of a collection sequentially.

  • Generator is a function that can yield multiple values one at a time, allowing it to pause and resume execution.

  • Iterators are used in loops to iterate over collections like arrays, while generators are used to create iterable sequences.

Add your answer

Q33. What is java and explain oopes concept

Ans.

Java is a popular programming language used for developing various applications. OOPs (Object-Oriented Programming) is a programming paradigm based on the concept of objects.

  • Java is a class-based, object-oriented programming language.

  • OOPs concepts include encapsulation, inheritance, polymorphism, and abstraction.

  • Encapsulation is the bundling of data and methods that operate on the data into a single unit.

  • Inheritance allows a class to inherit properties and behavior from anoth...read more

Add your answer

Q34. a robot that cleans the whole room

Ans.

A robot that cleans the whole room is a useful tool for maintaining cleanliness and saving time.

  • Efficiently cleans all surfaces in the room

  • Can reach tight spaces and corners easily

  • Saves time and effort for the user

  • Examples: Roomba vacuum cleaner, iRobot Braava mopping robot

Add your answer

Q35. Longest string with no repeating character

Ans.

Find the longest string in an array with no repeating characters.

  • Iterate through each string in the array

  • Use a set to keep track of characters seen so far

  • Update the longest string found without repeating characters

Add your answer

Q36. How do you create thread locks

Ans.

Thread locks are created using synchronization mechanisms to prevent multiple threads from accessing shared resources simultaneously.

  • Use synchronized keyword in Java to create a synchronized block or method

  • Use locks from java.util.concurrent.locks package like ReentrantLock

  • Use synchronized collections like ConcurrentHashMap to handle thread safety

  • Implement thread-safe data structures like BlockingQueue for producer-consumer scenarios

Add your answer

Q37. What is web service flow

Ans.

Web service flow is the sequence of steps involved in the communication between a client and a server over the internet.

  • Web service flow involves a client sending a request to a server

  • The server processes the request and sends a response back to the client

  • The response can be in various formats such as XML, JSON, or plain text

  • Web service flow can be synchronous or asynchronous

  • Examples of web services include RESTful APIs and SOAP web services

Add your answer

Q38. What is testing explain types

Ans.

Testing is the process of evaluating a software application to identify defects or bugs.

  • Types of testing include unit testing, integration testing, system testing, acceptance testing, and regression testing.

  • Unit testing involves testing individual components or modules of the software.

  • Integration testing checks if different modules work together correctly.

  • System testing evaluates the entire system's functionality.

  • Acceptance testing ensures that the software meets the user's r...read more

Add your answer

Q39. What is exceptions handling

Ans.

Exceptions handling is a mechanism to handle errors or exceptional situations in a program.

  • Exceptions allow for graceful handling of errors without crashing the program

  • Try-catch blocks are commonly used to catch and handle exceptions

  • Exceptions can be thrown manually using 'throw' keyword

  • Common exceptions include NullPointerException, ArrayIndexOutOfBoundsException, etc.

Add your answer

Q40. What is auto event wireup

Ans.

Auto event wireup is a feature in ASP.NET that automatically connects events to event handlers based on naming conventions.

  • Auto event wireup simplifies event handling by automatically connecting events to event handlers without needing to manually wire them up in code.

  • In ASP.NET Web Forms, auto event wireup is enabled by default, but can be disabled by setting the AutoEventWireup attribute to false in the Page directive.

  • Event handlers are expected to follow a specific naming ...read more

Add your answer

Q41. Locators in automation selenium

Ans.

Locators in automation selenium are used to identify web elements on a webpage for testing purposes.

  • Locators include ID, class name, name, tag name, link text, partial link text, and xpath.

  • ID is the most efficient locator as it is unique for each element.

  • Xpath is powerful but can be slow and brittle if not used correctly.

  • Using CSS selectors can also be a good alternative to xpath.

  • It is important to choose the right locator strategy based on the specific element and context.

Add your answer

Q42. What are Decorators in Python

Ans.

Decorators in Python are functions that modify the behavior of other functions or methods.

  • Decorators are denoted by the @ symbol followed by the decorator name.

  • They allow you to add functionality to an existing function without modifying its code.

  • Common use cases include logging, authentication, and memoization.

  • Example: @staticmethod decorator in Python is used to define a method that is not bound to the class instance.

Add your answer

Q43. Implement your own search functionality

Ans.

Implement a custom search functionality using algorithms like binary search or linear search.

  • Understand the requirements for the search functionality

  • Choose an appropriate search algorithm based on the data size and type

  • Implement the chosen algorithm in the programming language of choice

  • Test the search functionality with different input data to ensure accuracy

Add your answer

Q44. Trapping rain water problem

Ans.

Trapping rain water problem involves calculating the amount of water that can be trapped between buildings given their heights.

  • Calculate the maximum height of buildings to the left and right of each building

  • Find the minimum of the two heights

  • Subtract the height of the current building to get the amount of water that can be trapped at that building

Add your answer

Q45. writte code for fibonacci

Ans.

Fibonacci code generates a series of numbers where each number is the sum of the two preceding ones.

  • Start with two variables initialized to 0 and 1

  • Use a loop to calculate the next number by adding the previous two

  • Repeat the process until reaching the desired length or value

Add your answer

Q46. Design Toll system

Ans.

Design a toll system for collecting fees from vehicles using RFID technology.

  • Implement RFID technology for automatic vehicle identification

  • Set up toll booths with RFID readers to detect vehicles

  • Calculate toll fees based on vehicle type, distance traveled, and time of day

  • Provide payment options such as prepaid accounts or credit card payments

Add your answer

Q47. Generate paranthesis

Ans.

Generate all valid combinations of parentheses for a given number n

  • Use backtracking to generate all possible combinations of opening and closing parentheses

  • Keep track of the number of opening and closing parentheses used

  • Add opening parentheses if there are remaining to be used, and add closing parentheses if it won't create an invalid combination

Add your answer

Q48. Dense rank in sql

Ans.

Dense rank in SQL is a function that assigns a rank to each row in a result set with no gaps between the ranks.

  • Dense rank is used to assign unique ranks to each row in a result set, with no gaps between the ranks.

  • It is similar to the RANK function, but does not leave gaps in the ranking sequence.

  • For example, if two rows have the same value and are ranked 1 and 2, the next row will be ranked 3, not 2.

Add your answer

Q49. Sort using frequency

Ans.

Sort an array of strings based on their frequency of occurrence.

  • Create a frequency map to count the occurrences of each string

  • Sort the strings based on their frequency in descending order

  • If two strings have the same frequency, sort them lexicographically

  • Return the sorted array

Add your answer

Q50. Camel banana problem

Ans.

The Camel Banana problem is a puzzle that involves calculating the number of bananas a camel can eat.

  • The problem involves a camel that can carry a certain weight and a number of bananas with different weights.

  • The camel can only carry a maximum weight and can only eat a certain number of bananas.

  • The goal is to determine the maximum number of bananas the camel can eat without exceeding its weight limit.

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 null

based on 33 interviews in the last 1 year
3 Interview rounds
Coding Test Round
Technical Round
HR Round
View more
Interview Tips & Stories
Ace your next interview with expert advice and inspiring stories

Top Software Developer Interview Questions from Similar Companies

3.8
 • 119 Interview Questions
3.6
 • 64 Interview Questions
3.9
 • 40 Interview Questions
3.2
 • 36 Interview Questions
3.1
 • 12 Interview Questions
4.0
 • 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
70 Lakh+

Reviews

5 Lakh+

Interviews

4 Crore+

Salaries

1 Cr+

Users/Month

Contribute to help millions
Get AmbitionBox app

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