Bases de données
Quiz: Administer a relational database
Knowledge checks for the Administer a relational database training, in English: install, configure, secure, back up, monitor, maintain and replicate a relational database.
- 154 questions in the bank drawn at random at each attempt
- 19 topics to see the result topic by topic
- 19 linked guides to review after a wrong answer
Knowledge checks for the Administer a relational database training, in English: install, configure, secure, back up, monitor, maintain and replicate a relational database.
154 questions in the bank 19 topics 19 linked guides
How this exam works Questions drawn at random from the whole bank, shuffled answers, no time limit, explanations when graded.
An exam draws from the whole bank (154 questions, 19 topics) and gives a result per topic, whereas a lesson quiz only checks that lesson. The level sets the number of questions; the duration shown is an estimate, no timer stops the exam. Every draw is different: retaking the same level does not bring back the same questions.
Choose your level
Questions are drawn at random on every attempt: you can retake the same level without getting the same questions.
Related documentation
Read these pages to go deeper before or after the quiz:
- Transactions: what ACID and BASE promise
- Data modeling: from the requirement to the relational model
- History of databases: why they are the way they are
- How does a database server work?
- Partitioning and sharding a database: when and how to choose
See the 14 other pages
- Choose a relational engine: PostgreSQL, MySQL or SQLite
- Back up and restore MySQL: mysqldump, MySQL Shell and binlog PITR
- Configure MySQL: InnoDB, memory, connections and logging
- Install MySQL on Linux (Debian, Ubuntu, Rocky, RHEL)
- Getting started with the mysql client: administer MySQL from the command line
- MySQL replication: GTID, source-replica, Group Replication and InnoDB Cluster
- Secure MySQL: users, TLS, roles and least privilege
- Configure PostgreSQL: memory, connections, WAL and logging
- Discover PostgreSQL: architecture, vocabulary and components
- Install PostgreSQL 18 from the PGDG repository
- Monitor and maintain PostgreSQL: statistics, slow queries and VACUUM
- Administer a PostgreSQL instance with psql
- PostgreSQL replication: streaming, hot standby and failover
- Control access to PostgreSQL: pg_hba.conf, roles and enforced TLS