>
SQL
Programming
Knowledge of PostgreSQL
Verifies knowledge of the PostgreSQL relational database in 30 minutes. Questions cover administration commands, roles and permissions, transactions, triggers, schemas and indexes.
Difficulty
Intermediate
20
questions
Time limit of
30
mins
English
About this test
Twenty multiple-choice questions at an intermediate level. The candidate does not write queries; the test asks about commands, configuration and behavior of the database.
It leans toward administration and database features rather than general SQL. For Oracle environments, the catalog has the Oracle Database Administration Test.
What it measures
Commands to create, stop, check and back up a database
Creating users and login roles with MD5-encrypted passwords, and inheriting permissions through roles
Transactions and the commands that close them
Triggers, including ignoring inserts, and PL/pgSQL
Querying across multiple databases and using schemas
Vacuum Full, indexes, replicas, CTID and the postgresql.conf file
Ideal for
Database administrators
Back-end developers who work with PostgreSQL
Candidates for roles that operate or maintain PostgreSQL databases
Details
Programming
Difficulty
Intermediate
Time limit of
30
mins
SQL
English
20
questions
Average duration:
0
min
2
times completed