Oracle DBA Practice Questions

These aren’t certification questions. There’s no OCP exam mapping and no memorising version-specific trivia. They’re written for people who already run Oracle databases and want to check whether their knowledge has gaps — the kind that stay hidden until a restore fails at 2am or a query plan flips after a stats gather.

The topics track what Oracle DBAs actually spend time on: backup and recovery with RMAN, performance diagnosis, the optimizer and statistics, undo and redo, storage and tablespace management, and high availability.

Where to start

Newer to the role? Architecture and storage first. Almost every other topic assumes them.

Interviewing? Backup and recovery, plus performance tuning. Those two dominate senior Oracle interviews.

Thinking about migrating to Postgres? Try these first, then the PostgreSQL set — the contrast is the fastest way to see what transfers and what doesn’t.

Every question includes an explanation. Free, no signup, roughly 15 minutes each.