Postgresql DBA Test
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
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"}