[Q31-Q50] Use Real PostgreSQL-Essentials – 100% Cover Real Exam Questions [Mar-2026]

新问题 31
In PostgreSQL, which view provides information about currently running queries?

新问题 32
Which PostgreSQL configuration parameter controls the amount of memory used for sorting operations before writing to temporary disk files?

新问题 33
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?

新问题 34
Which psql command displays the command history?

新问题 35
You want to execute SQL commands from a file using psql. Which command should you use?

新问题 36
You want to gracefully terminate a user’s connection to the database. Which function should you use?

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

新问题 38
You want to set temporary memory to 8MB. Which parameter should you configure?

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

新问题 40
Which query displays the name and size of all databases in your cluster using a meaningful unit?

新问题 41
Which psql command quits the psql interface?

新问题 42
Which of the following directories store symbolic links for user-defined tablespaces in PostgreSQL?

新问题 43
What is the purpose of the autovacuum parameter in PostgreSQL?

新问题 44
Which system view provides real-time information about currently active sessions and running queries?

新问题 45
You want to create a backup of all databases in a PostgreSQL cluster. Which utility should you use?

新问题 46
Which parameter sets the number of autovacuum worker processes?

新问题 47
You need to take a full online base backup of your cluster using pg_basebackup. Which option specifies the output directory?

新问题 48
Which configuration parameter controls the amount of memory allocated for shared buffers?

新问题 49
In PostgreSQL, what is the default size of a WAL segment file?

新问题 50
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?