EnterpriseDB
PostgreSQL-Essentials
Q1:
Which system view provides real-time information about currently active sessions and running queries?
○
A
pg_stat_activity○
B
pg_current_queries○
C
pg_sessions○
D
pg_active_sessions
EnterpriseDB
PostgreSQL-Essentials
Q2:
Which query displays the name and size of all databases in your cluster using a meaningful unit?
○
A
SELECT datname, pg_database_size(datname) FROM pg_database;○
B
SELECT datname, pg_size_pretty(pg_database_size(datname)) AS size FROM pg_database;○
C
SELECT name, size FROM pg_database;○
D
SHOW DATABASE SIZE;
EnterpriseDB
PostgreSQL-Essentials
Q3:
Which configuration file controls client authentication in PostgreSQL?
○
A
postgresql.conf○
B
pg_hba.conf○
C
pg_ident.conf○
D
auth.conf
EnterpriseDB
PostgreSQL-Essentials
Q4:
In PostgreSQL, which view provides information about currently running queries?
○
A
pg_stat_activity○
B
pg_current_queries○
C
pg_running_queries○
D
pg_active_sessions
EnterpriseDB
PostgreSQL-Essentials
Q5:
You need to configure your server to accept TCP/IP connections from specific IP addresses. Which file should you modify?
○
A
postgresql.conf○
B
pg_hba.conf○
C
pg_ident.conf○
D
recovery.conf