Oracle DBA FAQs

This is a collection of FAQ and tips for Oracle DBA and developers. The clear answers and sample scripts provided can be used as learning tutorials or interview preparation guides.


It doesn't matter whether you are a beginner or an experienced Oracle DBA or developer, browse through our Oracle DBA FAQ and tips. They will always help you to improve your skills and find some good ideas to solve problems in your daily tasks.


So far, Our Oracle developers have written 249 questions and answers to share with you. Each one of them answers one commonly asked Oracle question with a short, but precise and clear SQL script. More questions will be available soon. Please come back to visit this page again.


Understanding Oracle Basic Concepts (19 questions)

Introduction to Oracle Database 10g Express Edition (21 questions)

Managing Oracle User Accounts (11 questions)

Managing Oracle Database Tables (17 questions)

Managing Oracle Table Indexes (14 questions)

Managing Oracle Tablespaces and Data Files (17 questions)

Creating New Database Instance Manually (15 questions)

Introduction to PL/SQL language (17 questions)

Introduction to Oracle SQL Developer (29 questions)

Understanding PL/SQL language basics (22 questions)

Creating your own PL/SQL procedures (26 questions)

Working with Database Objects in PL/SQL (23 questions)

Working with Cursors in PL/SQL (19 questions)



Please Enter here for Oracle DBA FAQs