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