PostgreSQL-Essentials PostgreSQL Essentials Certification v13 Questions and Answers

Which of the following statements is true about PostgreSQL 13?

You want to export query results to a CSV file from psql. Which command should you use?

In PostgreSQL, which system catalog stores information about databases?

While connected to a PostgreSQL database using psql, you want to toggle the timing information of some queries. Which of the following options can be used to achieve this?

Which of the following commands in psql will execute SQL commands from a file?

Which pg_restore option allows you to drop database objects before recreating them?

You want to gracefully terminate a user ' s connection to the database. Which function should you use?

You are writing an initialization script to help your team in creating a new database cluster. You want to ensure that a new database cluster is initialized with md5 as the default authentication method. Which of the following options of the initdb command can be used to specify the default authentication method?

Which parameter controls the amount of memory allocated for maintenance operations like VACUUM and CREATE INDEX?

Which of the following system functions can be used to track the status of the vacuum process?

In PostgreSQL 13, which command is used to switch your connection to a different database in psql?

In PostgreSQL, archiving can be enabled for hot backups. During recovery, all the archive logs can be played on the restored backup and Point-in-Time Recovery can be performed. Which of the following parameters directly influences Mean Time to Recovery and is also used to control the size of the WAL area?

Which of the following options can be used to view a Query Plan in pgAdmin4?

What is the purpose of the checkpoint_timeout configuration parameter in PostgreSQL?

You want to export the emp table to a CSV file with column headers using the COPY command. Which command should you use?

While connected to a PostgreSQL database using psql, you want to toggle the timing information of some queries. Which of the following options can be used to achieve this?

Which command in psql toggles between aligned and unaligned output mode?

You are connected to a PostgreSQL database. After executing a complex query an error message is displayed. You want to edit and rerun the previously executed query. Which command can be used to edit the query buffer?

In PostgreSQL, what does VACUUM do?

Which configuration parameter controls the amount of memory allocated for shared buffers?

Which configuration parameter limits the total number of connections available for your database cluster?

You want to configure your cluster to run in archive mode for Point-in-Time Recovery. Which parameter must you set in postgresql.conf?

In PostgreSQL, archiving can be enabled for hot backups. During recovery, all the archive logs can be played on the restored backup and Point-in-Time Recovery can be performed. Which of the following parameters directly influences Mean Time to Recovery and is also used to control the size of the WAL area?

You want to set the effective cache size for indexes to 512MB. Which parameter should you configure?

You need to determine the names and definitions of all views in the edbuser schema. Which query should you use?

You want to list all schemas in the current database using psql. Which command should you use?

You are working as a Postgres DBA. You want to configure logging for slow running queries on your database cluster. Which setting needs to be modified to log all the queries which take more than 5 seconds?

You are connected to a PostgreSQL database. After executing a complex query an error message is displayed. You want to edit and rerun the previously executed query. Which command can be used to edit the query buffer?

Which of the following statements is true about PostgreSQL 13?

You want to set temporary memory to 8MB. Which parameter should you configure?

Which utility is used to take a backup of all databases in a PostgreSQL cluster including roles and tablespaces?