>
SQL
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