Oracle
38 practice questions matched to the topics Oracle interviews focus on
How to use this company question set
Start with the highest-priority questions to build momentum, then move into category gaps where your confidence is lower. If you are early in prep, pair this page with the full Oracle interview guide for process expectations and timeline context.
For stronger retention, rotate through coding patterns and the interview roadmap while tracking recurring misses in this company-specific list.
Company question set summary
Total Questions
38
Start here
20
Categories
4
Coding problems
4
Ready to practice?
Start practicing Oracle questions with spaced repetition
Question Categories
Start here20
Closest match to this company's interview focus areas
Database: ACID vs BASE
Consistency Model for Messaging Systems
What does ROW_NUMBER() OVER (PARTITION BY dept ORDER BY salary DESC) do?
Debug a database deadlock issue
Twitter Tweet Storage: Database Choice
Database: Read Replicas
Month-over-Month Revenue Growth
Database Replication
ACID Properties
Explain database indexing to a new team member
Top 3 Products Per Category
Database: Indexing Strategy
CAP Theorem
Database Sharding: Choosing Shard Key
When is a database index NOT used?
Organization Hierarchy (Recursive CTE)
Employees Above Department Average
What is the N+1 query problem?
Spotify: Royalty Calculation
System Design: SQL vs NoSQL
Core practice18
Topics that come up across most software engineering loops
Event Sourcing
Cache Invalidation: Write-Through vs Write-Behind
Load Balancing Algorithms
Design a Key-Value Store
Spotify: Playlist Follow Notifications
Design a caching strategy for an e-commerce product catalog
Design a URL Shortener
Spotify: Real-time Lyrics Sync
Cache Invalidation Strategies
Blue-Green Deployment
CAP Theorem Trade-offs
Design a Web Crawler
Circuit Breaker Pattern
Design a Distributed Cache
Spotify: Discover Weekly Architecture
LRU Cache Eviction
Spotify: Cross-Device Handoff
Spotify: Concert Recommendations
Related company question banks
Use adjacent company sets to broaden coverage while keeping your prep focused on similar interview patterns.