Programming

Oracle Database Administration Test

Verifies knowledge of Oracle database administration in 30 questions and 30 minutes: storage structures, processes, backups, tablespaces and transactions.

Difficulty

Intermediate

30

questions

Time limit of

30

mins

English

About this test

Thirty questions, 27 with one correct answer and 3 where several answers apply. The candidate does not write code; the test checks how the database engine is organized and administered.

The focus is the database engine and its administration. For development tooling, the catalog has Knowledge of Oracle Forms and Reports and the PL/SQL Knowledge test.

What it measures

  • Physical and logical storage structures, data files and the smallest storage unit

  • Background processes and redo logs

  • Backup strategies and backup types

  • Tablespace classes and the types of PDBs

  • Types of failure, such as an instance failure caused by the operating system or hardware

  • Transactions, sequences, altering tables, creating a database and working with SQL*Plus

Ideal for

  • Database administrators (DBAs)

  • Developers who need to know Oracle database administration

  • Candidates for roles that operate

  • Back up Oracle databases

Details

Programming

Difficulty

Intermediate

Time limit of

30

mins

SQL

English

30

questions

Average duration:

0

min

1

times completed