← All tutorials

Skill Zuno · skillzunos.com · Fullstack

Oracle Database tutorial

Learn Oracle Database on Skill Zuno. This Oracle Database tutorial covers New, Easy, Medium, Hard, and Diff levels so you can study practical Oracle Database problems on skillzunos.com.

Open Oracle Database on Skill Zuno

Also see the Oracle Database interview questions.

Oracle Database is a commercial relational database widely used in banking, telecoms and large enterprises. It is known for PL/SQL, multiversion read consistency, Real Application Clusters and extensive tuning tools. Oracle interviews cover SQL and PL/SQL, the architecture of instances and tablespaces, indexing, execution plans, transactions and backup.

Oracle Database topics covered

  • Instance versus database: SGA, PGA and background processes — The memory structures and processes that make up a running Oracle instance.
  • Tablespaces, data files, schemas and users — How Oracle organises storage, and how schemas relate to users.
  • SQL: joins, analytic functions and hierarchical queries — Analytic window functions and CONNECT BY for tree-shaped data.
  • PL/SQL procedures, functions, packages and triggers — Server-side programming with blocks, cursors, exceptions and packages.
  • B-tree and bitmap indexes — Choosing an index type for transactional and analytic workloads.
  • Execution plans and the cost-based optimiser — Reading plans with DBMS_XPLAN, and using statistics and hints.
  • Undo, redo, read consistency and isolation — How Oracle keeps queries consistent and recovers after a crash.
  • Backup and recovery with RMAN and Data Guard — Backing up, restoring and keeping a standby database in sync.

What you can learn

  • Oracle Database tutorial for beginners and experienced developers
  • Level-based practice: New, Easy, Medium, Hard, and Diff
  • Fullstack topics alongside Oracle Database on skillzunos.com

More Fullstack tutorials

All tutorials