System designLast seen Oct 2026
Design a Time Series Metrics Database
Design a high-cardinality metrics database for durable ingestion, range queries, rollups, late data, and retention.
Open practiceOracle interview practice
Oracle Software Engineer Interview: Coding and Design Start with verified evidence.
Practice from 53 Oracle-tagged public coding problems, organized only by the stage, topic, difficulty, and recency metadata FastPrep can verify. The broader public catalog also includes 18 system-design exercises, 3 low-level-design exercises.
- Catalog
- 74 public practice assets (53 coding)
- Start here
- Use the stage named in your invitation
- Evidence
- OA · Phone · Onsite metadata, shown in context
OA practice path
Online Assessment
Build a timed implementation rhythm from prompt to edge cases. Problems are ranked by repeated public catalog sightings.
| Company | Problem | Difficulty | Public evidence | Action |
|---|---|---|---|---|
OROracle | First Balanced Removal Index | Unrated | 1 public reportLast reported Dec 2025 | Practice |
OROracle | Find Circle NumberUnion Find | Medium | 1 public reportLast reported Oct 2024 | Practice |
OROracle | Create Lexicographically Largest PermutationGraphDepth-First Search | Hard | 1 public reportLast reported Sep 2024 | Practice |
OROracle | Array Reduction 1HeapGreedy | Easy | 1 public reportLast reported Feb 2024 | Practice |
OROracle | Balancing ParenthesesStringStack | Easy | 1 public reportLast reported Feb 2024 | Practice |
OROracle | Last and Second-LastString | Easy | 1 public reportLast reported Feb 2024 | Practice |
OROracle | Merge 2 ArraysArrayTwo Pointers | Easy | 1 public reportLast reported Feb 2024 | Practice |
OROracle | Minimum Difference SumSortingGreedy | Easy | 1 public reportLast reported Feb 2024 | Practice |
OROracle | Powers of 2Bit ManipulationMath | Easy | 1 public reportLast reported Feb 2024 | Practice |
OROracle | Adding Two NumbersMath | Easy | 1 public reportLast reported Feb 2024 | Practice |
OROracle | Cardinality SortingSortingBit Manipulation | Easy | 1 public reportLast reported Feb 2024 | Practice |
OROracle | REST API: Discounted PriceDesignMath | Easy | 1 public reportLast reported Feb 2024 | Practice |
Phone practice path
Phone Screen
Practice solving while explaining assumptions, tradeoffs, and complexity. Problems are ranked by repeated public catalog sightings.
| Company | Problem | Difficulty | Public evidence | Action |
|---|---|---|---|---|
OROracle | Time-Based Key-Value StoreHash TableBinary Search | Medium | 4 public reportsLast reported Oct 2026 | Practice |
OROracle | Best Time to Buy and Sell StockArrayDynamic Programming | Easy | 4 public reportsLast reported Aug 2026 | Practice |
OROracle | Remove Adjacent Duplicates in String IIStringStack | Medium | 2 public reportsLast reported Oct 2026 | Practice |
OROracle | Next PermutationArrayTwo Pointers | Medium | 2 public reportsLast reported Sep 2026 | Practice |
OROracle | Maximum of Window MinimumsArraySliding Window | Medium | 2 public reportsLast reported Sep 2026 | Practice |
OROracle | Top-K URLs Overall and in the Last 24 HoursArrayHash Table | Medium | 2 public reportsLast reported Sep 2026 | Practice |
OROracle | Alphabetically Maximum SubstringStringTwo Pointers | Hard | 2 public reportsLast reported Aug 2026 | Practice |
OROracle | Bottom View of a Binary TreeTreeBreadth-First Search | Medium | 2 public reportsLast reported Aug 2026 | Practice |
OROracle | Detect a Cycle in a Directed GraphGraphTopological Sort | Medium | 1 public reportLast reported Oct 2026 | Practice |
OROracle | Sum Root-to-Leaf Binary NumbersTreeDepth-First Search | Easy | 1 public reportLast reported Oct 2026 | Practice |
OROracle | Longest All-Present Attendance StreakArrayString | Easy | 1 public reportLast reported Oct 2026 | Practice |
OROracle | Valid ParenthesesStringStack | Easy | 1 public reportLast reported Sep 2026 | Practice |
OROracle | Valid Parenthesis StringStringGreedy | Medium | 1 public reportLast reported Sep 2026 | Practice |
OROracle | Longest Continuous Subarray Within an Absolute-Difference LimitArraySliding Window | Medium | 1 public reportLast reported Sep 2026 | Practice |
OROracle | Classify Tree Nodes with SQLDatabase | Easy | 1 public reportLast reported Sep 2026 | Practice |
OROracle | Remove Even-Positioned Linked-List NodesLinked List | Easy | 1 public reportLast reported Aug 2026 | Practice |
OROracle | Sort Departments by EnrollmentArrayHash Table | Medium | 1 public reportLast reported Aug 2026 | Practice |
OROracle | Merge k Sorted ListsLinked ListHeap | Hard | 1 public reportLast reported Jul 2026 | Practice |
OROracle | Implement a Queue Using Two StacksStackQueue | Easy | 1 public reportLast reported Jul 2026 | Practice |
Onsite practice path
Onsite
Practice complete solutions and defend the choices behind them. Problems are ranked by repeated public catalog sightings.
26 Oracle-tagged Onsite problems available.
| Company | Problem | Difficulty | Public evidence | Action |
|---|---|---|---|---|
OROracle | Time-Based Key-Value StoreHash TableBinary Search | Medium | 4 public reportsLast reported Oct 2026 | Practice |
OROracle | Best Time to Buy and Sell StockArrayDynamic Programming | Easy | 4 public reportsLast reported Aug 2026 | Practice |
OROracle | Maximum Subarray Sum with Length at Most KArrayPrefix Sum | Hard | 2 public reportsLast reported Sep 2026 | Practice |
OROracle | Top-K URLs Overall and in the Last 24 HoursArrayHash Table | Medium | 2 public reportsLast reported Sep 2026 | Practice |
OROracle | Add One to a Number Represented as DigitsArrayMath | Easy | 2 public reportsLast reported Aug 2026 | Practice |
OROracle | Top K Frequent Elements with Larger-Value Tie BreakArrayHash Table | Medium | 2 public reportsLast reported Aug 2026 | Practice |
OROracle | Enumerate Right-and-Down Matrix PathsMatrixBacktracking | Medium | 2 public reportsLast reported Aug 2026 | Practice |
OROracle | Maximize Movie Ratings Without Consecutive SkipsArrayDynamic Programming | Medium | 2 public reportsLast reported Aug 2026 | Practice |
OROracle | Bottom View of a Binary TreeTreeBreadth-First Search | Medium | 2 public reportsLast reported Aug 2026 | Practice |
OROracle | Count Dropped Rate-Limited RequestsArraySliding Window | Medium | 2 public reportsLast reported Aug 2026 | Practice |
OROracle | Keep at Most K Occurrences in a Sorted ArrayArrayTwo Pointers | Medium | 2 public reportsLast reported Aug 2026 | Practice |
OROracle | Swap Two Integers Without a Temporary VariableBit ManipulationMath | Easy | 2 public reportsLast reported Aug 2026 | Practice |
OROracle | Minimum Meeting RoomsHeapSorting | Medium | 1 public reportLast reported Oct 2026 | Practice |
OROracle | Merge One List Between Two PositionsLinked ListArray | Medium | 1 public reportLast reported Sep 2026 | Practice |
OROracle | TTL Cache OperationsHash TableDesign | Medium | 1 public reportLast reported Sep 2026 | Practice |
OROracle | Island Count and Maximum AreaArrayMatrix | Medium | 1 public reportLast reported Sep 2026 | Practice |
OROracle | Retry with an Attempt LimitArrayString | Easy | 1 public reportLast reported Sep 2026 | Practice |
OROracle | Detect Cross-Doctor Prescription Pairs Within 30 DaysArrayHash Table | Medium | 1 public reportLast reported Sep 2026 | Practice |
OROracle | Design Authentication ManagerDesignHash Table | Medium | 1 public reportLast reported Sep 2026 | Practice |
OROracle | Jump Game IIArrayDynamic Programming | Medium | 1 public reportLast reported Sep 2026 | Practice |
01 · Preparation plan
Connect data identity, history, and query cost.
Oracle's mixed coding and design catalog supports a storage-oriented study path. First resolve identity across records, then preserve values over time, then reason about a query whose answer changes as events age. This is engineering practice, not an Oracle Database certification syllabus. This is a suggested practice sequence, not the employer's interview process. Your invitation and recruiter guidance remain the source of truth.
- 01
Merge identities transitively
Use account merging to distinguish shared identifiers from identical display names. A chain of overlapping records must produce the same grouping regardless of input order.
- Choose a stable identity key.
- Test indirect connections and isolated accounts.
- Sort only where the output contract requires it.
- 02
Query a value as of a timestamp
The time-based store makes historical lookup concrete. Specify which prior version is visible and what a query before the first write should return.
- Separate exact matches from predecessor lookup.
- Test repeated and out-of-order timestamps if permitted.
- Compare write cost with historical read cost.
- 03
Separate lifetime and rolling rankings
Use the URL-ranking exercise to maintain two different aggregates over the same event stream. Expiration must affect the recent ranking without erasing lifetime evidence.
- Define the rolling-window boundary.
- Explain frequency ties and deterministic output.
- Account for both event storage and ranking updates.
02 · Broader technical practice
Practice beyond standalone coding questions.
These public Oracle-tagged exercises cover additional technical formats. They are included only when a verified catalog record and a crawlable practice page both exist.
System designLast seen Oct 2026
Design a Centralized Log Ingestion and Search Platform
Design a multi-tenant platform that durably ingests structured logs and provides coherent recent-event search and exact keyword occurrence counts.
Open practiceSystem designLast seen Oct 2026
Design a URL Shortening Service
Design a deliberately small URL-shortening core, then evolve it into a highly available service whose fixed logical shards can move safely as physical storage capacity grows.
Open practiceLow-level designLast seen Oct 2026
Design an LRU Cache Object Model
Model a bounded key/value cache with exact access-based eviction, focused contracts and a capacity-resize follow-up.
Open practiceSystem designLast seen Oct 2026
Design a Distributed Rate Limiter
Design a multi-tenant distributed limiter that smooths priority and regular traffic under versioned quotas, retries, and partial failure.
Open practiceSystem designLast seen Oct 2026
Design a Personalized Recommendation System
Design event ingestion, candidate retrieval, ranking, and serving for a bounded personalized user-item catalog.
Open practiceSystem designLast seen Oct 2026
Design a Ticket Booking System
Design the catalog, availability, pricing, reservation, and payment path for a high-demand movie and event ticketing platform.
Open practiceSystem designLast seen Sep 2026
Design a Video Storage and Streaming Platform
Design video upload, processing, storage, search, download, and adaptive playback at scale.
Open practiceLow-level designLast seen Sep 2026
Design a Configurable Logging Framework
Design a thread-safe, extensible in-process logging framework with levels, formatting, console and file output, runtime configuration, and optional asynchronous delivery.
Open practiceSystem designLast seen Sep 2026
Design a Durable Disposable Email Service
Design a five-hour disposable-mail product at 100-million-user scale while guaranteeing human-looking address uniqueness and permanent non-reuse.
Open practiceSystem designLast seen Sep 2026
Design Data-Loss Prevention and Recovery for a Distributed Store
Protect acknowledged records through replication, backups, corruption detection, and rehearsed recovery.
Open practiceSystem designLast seen Sep 2026
Design Stable API and Database Pagination
Page through a large, changing dataset without duplicates, gaps, or unstable query plans.
Open practiceSystem designLast seen Sep 2026
Design a Rolling Top Error-Services Monitor
Ingest high-volume service logs and return the top error-producing services in the trailing five minutes.
Open practiceSystem designLast seen Sep 2026
Design a Rolling Top-Users Event Leaderboard
Maintain the top one hundred users by event count over a continuously moving one-hour window.
Open practiceSystem designLast seen Sep 2026
Design GPU Host Health Monitoring and Repair
Design a platform that combines GPU-host signals, metrics, and logs to detect unhealthy hosts and safely trigger repair workflows across a 100,000-host fleet.
Open practiceSystem designLast seen Aug 2026
Design a Software Load Balancer
Design a regional software load balancer with a chosen L4 or L7 data path, versioned policies, backend health, and graceful draining. Audit round robin for a bounded opaque request profile.
Open practiceLow-level designLast seen Aug 2026
Design and Implement an Active-Passive Key-Value Store
Model and implement an in-memory key-value store whose writes commit to active and passive replicas together or fail without changing either.
Open practiceSystem designLast seen Aug 2026
Design a Scheduled Fan-Out Delivery Platform
Deliver a scheduled message to between one and ten thousand recipients within one second of its due time.
Open practiceSystem designLast seen Aug 2026
Design a Healthcare Data Ingestion Pipeline
Design a secure, replayable pipeline that turns millions of healthcare records into trustworthy curated datasets.
Open practiceSystem designLast seen Aug 2026
Design a Netflix-Style Streaming Platform
Design an on-demand video platform that ingests, publishes, authorizes, and streams adaptive media to viewers at global scale.
Open practiceSystem designLast seen Aug 2026
Design a Remote Browser Isolation Service
Design a service that opens untrusted web pages inside disposable remote browser sessions and streams a safe interactive view to users.
Open practice03 · Evidence boundary
What “Oracle interview questions” means here.
It means practicing transferable implementation, testing, and technical reasoning with public catalog assets FastPrep tags to Oracle. It does not mean FastPrep has access to the company's assessments or any private interview bank.
Repeated public sightings and last-reported dates can help you prioritize practice, but they cannot predict the questions, format, or platform in a specific interview.
- Only Oracle-tagged FastPrep catalog problems appear above.
- Stage labels and report dates remain visible as context.
- No official, private, leaked, or proprietary questions are claimed.
04 · Plain answers
Oracle interview practice questions, answered plainly.
This page owns technical-practice intent for Oracle. Hiring activity, timelines, and market signals remain on the separate hiring-insights page.
01Does this page cover Oracle DBA or SQL certification interviews?
Not as a complete course. The verified assets support coding and system-design practice. Storage-related exercises are useful for discussing data structures and query tradeoffs, but they do not establish a SQL question bank, DBA role curriculum, or the current requirements of a particular Oracle team.
02Is FastPrep affiliated with Oracle?
No. FastPrep is an independent interview-preparation product and is not affiliated with Oracle. The page uses FastPrep's public practice catalog and does not claim official, private, leaked, or proprietary employer questions.
03How are Oracle problems assigned to interview stages?
Stage labels come from FastPrep's public problem metadata. A problem can carry more than one reported stage, and hiring processes can change by role, level, location, and date. Treat the labels as preparation context, not a guarantee.
04Which Oracle interview stage should I practice first?
Start with the stage named in your invitation or recruiter message. If no stage is known, use the largest available set to build general problem-solving fluency, then rehearse explanation and testing separately.
05Does this page predict the Oracle interview process?
No. Public catalog counts, stage tags, and last-reported dates can help prioritize practice, but they cannot predict a specific interview's questions, sequence, timing, or platform.
Your next stage, made concrete
Pick a problem. Solve it end to end.
Start with the stage named in your invitation, then use public evidence as context—not as a promise of what you will be asked.
Open the practice set