PostgreSQL-Essentials Dumps 2026 – New EnterpriseDB PostgreSQL-Essentials Exam Questions [Q47-Q68]

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

QUESTION 48
Which system view provides real-time information about currently active sessions and running queries?

QUESTION 49
Which psql command quits the psql interface?

QUESTION 50
You are working as a Postgres DBA. Due to an increase in transactional load on your Postgres instance, the server is experiencing frequent checkpoints. You have decided to increase the WAL area size. You have also decided to upgrade your database instance to PostgreSQL 13. While initializing your database cluster in PostgreSQL 13, you have decided to increase the WAL segment size. Which of the following options can be used with the initdb command to set a custom WAL segment size?

QUESTION 51
Which psql meta-command is used to display all roles and their attributes?

QUESTION 52
You need to reload the PostgreSQL configuration without restarting the server. Which function should you use?

QUESTION 53
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?

QUESTION 54
You are connected to a database in PostgreSQL using the psql tool. Which of the following commands can be used to view the cluster data directory?

QUESTION 55
Which command can be used to display all roles and their attributes in PostgreSQL using psql?

QUESTION 56
Autocommit occurs in which of the following situations?

QUESTION 57
You need to take a full online base backup of your cluster using pg_basebackup. Which option specifies the output directory?

QUESTION 58
You need to reclaim storage occupied by dead tuples in the customers table. Which command should you use?

QUESTION 59
Which psql meta-command is used to describe a table including its structure, columns, and constraints?

QUESTION 60
Which PostgreSQL configuration parameter controls the amount of memory used for sorting operations before writing to temporary disk files?

QUESTION 61
Which command displays the current search path in PostgreSQL?

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

QUESTION 63
You want to view all available functions in the current database using psql. Which command should you use?

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

QUESTION 65
You want to update statistics for the emp and dept tables to help the query planner. Which command should you use?

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

QUESTION 67
You want to list all available databases in your PostgreSQL cluster using psql. Which command should you use?

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