Survey Maker Survey Templates Contact Privacy & Security

Postgresql DBA Test

A highly detailed and informative image depicting a PostgreSQL database setup, featuring database tables, logs, and a professional working environment, in a modern tech style.

PostgreSQL DBA Mastery Quiz

Test your knowledge of PostgreSQL with this comprehensive quiz designed for database administrators! Whether you're a novice or an experienced DBA, this quiz will challenge your understanding of key PostgreSQL concepts and practices.

Multiple choice questions covering a range of PostgreSQL features
Assess your understanding of database operations and configurations
Ideal for those looking to reinforce their PostgreSQL skills or prepare for certification

15 Questions4 MinutesCreated by OptimizingDatabase42

Which of the following is true regarding PostgreSQL?

PostgreSQL is a powerful

PostgreSQL is open source

PostgreSQL is object-relational database system

All of the above

Using psql, you can generate a complete list of commands by using the ________ command

Help

/help

$help

&help

A tablespace is a place where database objects are stored on disk.

True

False

Only the administrator can make use of tablespaces.

True

False

Which of the following best describes a role:

A server’s purpose within a cluster.

The purpose of a particular database.

A cluster’s purpose.

A template for authorization to various database objects.

WAL stands for:

Write Ahead Log

Write Ahead List

Write Anywhere List

Write Anywhere Logging

VACUUM operation is used:

To recover or reuse disk space occupied by updated or deleted rows.

To protect against loss of very old data due to transaction ID wraparound.

To update data statistics used by the PostgreSQL query planner.

All of these

When looking at ‘ps’ output on a Unix system, you see the following: Postgres 1016 0.1 2.4 6532 3080 pts/1 SN 13:19 0:00 postgres: tgl regression [local] idle in transaction What does “idle in transaction” mean?

The server is idle, awaiting a client connection.

A transaction is possibly hung.

A user issued an IDLE statement to the database.

A client is connected, and the server is awaiting input.

Bob works for StataCorp. His workstation’s IP address is 10.5.34.8. He needs access to a database called “partners” directly from his workstation. Which of the following is the correct entry in pg_hba.conf?

Host partners bob 10.5.34.8/24 krb5

Host partners bob 10.5.34.8/32 kerb5

Host partners bob 10.5.34.8 kerb5

Host partners bob 10.5.34.8/32 krb5

Default, in what subdirectory of the database data directory are WAL logs contained(for version 10 and above)?

Pg-xlog

Pg-log

Pg_log

Pg_wal

True or False? To enable continuous archiving, all you have to do is set archive_mode to ‘on’ in postgresql.conf

True

False

Locks are recorded in:

Pg_lock system logs

Pg_locks system view

Pg_locks system logs

Pg_lock system table

What does the following statement do? CREATE INDEX lower_title_idx ON books ((lower(title)));

Modifies an index in place to be lowercase

Creates a new index with a special operator class ‘lower’ for case insensitive comparisons.

Creates an index for efficient case-insensitive searches on the titles column within the books table

Nothing, it’s invalid SQL

Which one is the highest logging level in postgresql?

DEBUG4

Info

Warning

DEBUG5

A VACUUM operation is used:

To recover or reuse disk space occupied by updated or deleted rows

To protect against loss of very old data due to transaction ID wraparound.

To update data statistics used by the PostgreSQL query planner.

All of these

{"name":"Postgresql DBA Test", "url":"https://www.supersurvey.com/QPREVIEW","txt":"Test your knowledge of PostgreSQL with this comprehensive quiz designed for database administrators! Whether you're a novice or an experienced DBA, this quiz will challenge your understanding of key PostgreSQL concepts and practices.Multiple choice questions covering a range of PostgreSQL featuresAssess your understanding of database operations and configurationsIdeal for those looking to reinforce their PostgreSQL skills or prepare for certification","img":"https:/images/course8.png"}