Oracle Interview Questions and Answers for SDE Roles
Last updated 2026-11-19
Oracle interviews pair coding rounds with deep fundamentals, especially databases and Java, followed by a techno-managerial conversation about your projects. This page works through that mix with model answers.
The questions are practice in the style of the topics Oracle's own recruiters list, not a record of past interviews.
| Described rounds | Pre-screen, two coding rounds, techno-managerial |
|---|---|
| Topics listed | Arrays, strings, lists, trees, hash maps, graphs, big-O |
| Also expect | SQL, DBMS and Java fundamentals |
| Role titles | Software Developer, Member of Technical Staff |
How the rounds are described
An Oracle engineering recruiter, writing on Oracle's jobs blog, describes roughly four rounds: a recruiter pre-screen, two coding rounds described as knockout rounds, and a techno-managerial round with the hiring manager that mixes technical depth with fit. These are older blog posts, so round counts may have changed. The same sources say to prepare two or three past projects to discuss in depth, and list arrays, strings, linked lists, trees, hash maps, graphs, core algorithms, big-O analysis and behavioural questions using STAR as the topics to practise.
Oracle also builds databases, so candidates for many teams should expect SQL and database fundamentals alongside coding. Roles are titled Software Developer or Member of Technical Staff in postings.
- Treat the two coding rounds as pass or fail: practise until medium array, string and tree problems are routine.
- Prepare database fundamentals even if your role is not database-specific.
- Keep two or three projects ready for a deep dive.
Related practice
Coding problems in the style of these rounds are in Oracle coding round questions. For the process see how to crack the Oracle interview.
Hiring status
Oracle reportedly laid off about 10,000 to 12,000 people in India from 31 March 2026, according to reports, and Oracle did not confirm those numbers. The reports describe it as part of a global cut estimated at 20,000 to 30,000, and a March 2026 SEC filing said restructuring costs could reach up to US$2.1 billion. See Oracle hiring for the sourced summary and Oracle's own careers site, oracle.com/in/careers, for current openings.
Oracle Interview Questions and Answers for SDE Roles: questions with worked answers
1 Explain the ACID properties of a database transaction.
easyAtomicity: all operations in a transaction happen or none do, so a failure midway rolls everything back. Consistency: a transaction moves the database from one valid state to another, respecting constraints. Isolation: concurrent transactions do not see each other's partial work, to a degree set by the isolation level. Durability: once committed, data survives a crash, normally through a write-ahead log. Use a bank transfer as the example: debit and credit must both happen or neither.
2 What are the transaction isolation levels and what anomalies does each allow?
mediumRead uncommitted allows dirty reads (seeing uncommitted data). Read committed prevents dirty reads but allows non-repeatable reads (the same row read twice gives different values). Repeatable read prevents that, though phantom rows can still appear in some databases. Serializable prevents all of these, at the cost of concurrency. Oracle's default is read committed, implemented with multi-version consistency so readers do not block writers. Name the anomaly each level removes.
3 How does a B-tree index differ from a bitmap index, and when would you use each?
mediumA B-tree index keeps sorted keys in a balanced tree, giving fast equality and range lookups on columns with many distinct values, and handles frequent updates reasonably. A bitmap index stores one bit vector per distinct value, which is compact and fast for low-cardinality columns such as status or gender and for combining many conditions with AND and OR, but it locks heavily on updates, so it suits read-mostly warehouse tables, not busy transactional ones.
4 Explain normalisation up to third normal form.
mediumFirst normal form: each column holds atomic values and there are no repeating groups. Second normal form: in addition, every non-key attribute depends on the whole key, which matters for composite keys. Third normal form: in addition, non-key attributes depend only on the key and not on other non-key attributes, removing transitive dependencies such as storing a city and its state in a customer row. Normalisation reduces redundancy and update anomalies; denormalise deliberately for read performance.
5 Write a query for employees who earn more than their manager.
mediumJoin the employee table to itself, linking each employee's manager id to the manager's employee id, then compare salaries. In SQL: SELECT e.name FROM employee e JOIN employee m ON e.manager_id = m.id WHERE e.salary > m.salary. An inner join is correct because employees without a manager cannot satisfy the comparison. Explain that a self-join treats one table as two aliases.
6 How does a Java HashMap work internally?
mediumIt stores entries in an array of buckets; the key's hashCode is spread and masked to pick a bucket. Collisions are chained in a linked list, which converts to a balanced tree when a bucket grows past a threshold, so worst case lookup is O(log n). When the load factor (default 0.75) is exceeded the table doubles and entries are redistributed. Keys must have consistent hashCode and equals, and mutable keys changed after insertion are lost.
7 What is the difference between == and equals, and why is String immutable in Java?
easyFor objects, == compares references (same object) while equals compares logical content, if overridden. Strings with the same literal may share one instance from the string pool, so == can appear to work but should not be relied on. Strings are immutable so they can be safely shared and pooled, cached for hashCode, used as map keys and passed between threads and security checks without being altered.
8 What is the difference between synchronized and ReentrantLock?
mediumsynchronized is built into the language and releases the lock automatically on exit, including on exceptions, which makes it hard to misuse. ReentrantLock is more flexible: it supports tryLock with timeout, interruptible waits, fairness and multiple Condition objects, but you must release it in a finally block. Both are reentrant. Use synchronized by default and ReentrantLock when you need those extra features.
9 A SQL query is running slowly. How do you investigate?
mediumLook at the execution plan to see whether it uses an index or scans the whole table, how joins are ordered, and where the estimated and real row counts diverge. Check missing or unusable indexes (a function applied to an indexed column prevents its use), stale statistics, selecting unneeded columns, and joins that multiply rows. Fix the biggest cost first, re-measure, and consider rewriting subqueries or adding a composite index that matches the filter order.
10 Walk me through a project on your resume in depth.
mediumOracle's engineering recruiter advice says to prepare two or three past projects to discuss in depth for the techno-managerial round. For each, know the problem, your exact role, the architecture, a hard bug or design choice, what you would improve and how you measured success. Expect follow-ups on why you chose a technology and what happens under failure. Honest, specific answers beat polished vague ones.
11 Tell me about a conflict with a teammate and how you resolved it (STAR).
mediumOracle's guidance lists behavioural questions answered with STAR. Situation: a disagreement over approach or workload. Task: what you were responsible for. Action: you listened, found the underlying concern, proposed a way to decide such as a short prototype, and agreed next steps. Result: the project moved and the working relationship improved. See the behavioural interview guide.
12 Describe a time you had to learn a new technology under pressure.
easyState why the learning was urgent, how you prioritised what to learn (just enough to deliver the feature), the resources and people you used, how you checked your work, and what you delivered. Close with how your approach to learning changed. A concrete deliverable and a date make the story credible.
Frequently asked questions
How many rounds does Oracle have?
An Oracle recruiter's older blog posts describe roughly four rounds. Round counts may have changed, so confirm with your recruiter.
Are the Oracle coding rounds elimination rounds?
The recruiter sources describe the two coding rounds as knockout rounds, so prepare for them seriously.
Does Oracle ask SQL questions for non-database roles?
Often database fundamentals are included because of Oracle's products. Prepare joins, indexes and transactions.
Where can I check Oracle's openings?
See Oracle hiring and Oracle's careers site.
Sources
Related guides
- Oracle Coding Round Questions with Solutions in Python and Java
- DBMS Interview Questions and Answers
- SQL Interview Questions and Answers
- Java Interview Questions and Answers
- Salesforce Interview Questions and Answers for MTS and AMTS Roles
- SAP Labs Interview Questions and Answers for Freshers and SDE Roles
More in Company Interview Questions
- PayPal coding round questions with solutions
- PayPal interview questions with answers (software engineer, India)
- Paytm Coding Round Questions with Solutions
- Paytm Interview Questions and Answers
- Persistent Systems Coding Round Questions with Solutions
- Persistent Systems Interview Questions for Freshers
- PhonePe Coding Round Questions with Solutions
- PhonePe Interview Questions and Answers
- Postman Coding Round Questions With Solutions
- Postman Interview Questions and Answers
- Publicis Sapient Coding Round Questions
- Publicis Sapient Interview Questions with Answers