[Mar-2026] PostgreSQL-Essentials Free Sample Questions to Practice One Year Update
Download PostgreSQL-Essentials exam with EnterpriseDB PostgreSQL-Essentials Real Exam Questions
NEW QUESTION # 51
PostgreSQL supports SQL dump backup. You have configured a nightly backup of a database in plain SQL dump format. Due to database corruption, you need to restore your database using the SQL dump backup.
Which of the following commands can be used to restore a SQL dump?
- A. psql -f sqldumpfilename --all -d databasename -U username
- B. psql -f sqldumpfilename --tuples -d databasename -U username
- C. psql -f sqldumpfilename -1 -d databasename -U username
- D. psql -f sqldumpfilename -quiet -d databasename -U username
Answer: C
NEW QUESTION # 52
Which parameter sets the number of autovacuum worker processes?
- A. autovacuum_workers
- B. vacuum_workers
- C. max_autovacuum_workers
- D. autovacuum_max_workers
Answer: D
NEW QUESTION # 53
What is the purpose of shared_buffers configuration parameter in PostgreSQL?
- A. To determine memory for caching data from disk
- B. To set the amount of memory for sorting
- C. To set connection pool size
- D. To control WAL buffer size
Answer: A
NEW QUESTION # 54
Which command in psql toggles between aligned and unaligned output mode?
- A. \align
- B. \format
- C. \t
- D. \a
Answer: D
NEW QUESTION # 55
Which of the following directories store symbolic links for user-defined tablespaces in PostgreSQL?
- A. pg_tblspc
- B. pg_wal
- C. global
- D. base
Answer: A
NEW QUESTION # 56
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?
- A. SHOW DATA_DIRECTORY;
- B. SHOW DIRECTORY;
- C. SELECT server_dir FROM pg_settings;
- D. SELECT data_dir FROM pg_settings;
Answer: A
NEW QUESTION # 57
Which psql meta-command displays the structure of a specific table including columns, types, and constraints?
- A. SHOW TABLE tablename;
- B. \d tablename
- C. \dt tablename
- D. DESCRIBE tablename;
Answer: B
NEW QUESTION # 58
Which of the following commands in psql will execute SQL commands from a file?
- A. \x filename
- B. \i filename
- C. \e filename
- D. \f filename
Answer: B
NEW QUESTION # 59
Which PostgreSQL backup utility can create backups in custom compressed format?
- A. pg_basebackup
- B. pg_dump with -Fc option
- C. psql
- D. pg_restore
Answer: B
NEW QUESTION # 60
Which parameter must be set to enable WAL archiving for Point-in-Time Recovery in PostgreSQL 13?
- A. wal_level = minimal
- B. wal_level = logical
- C. wal_level = archive
- D. wal_level = replica
Answer: D
NEW QUESTION # 61
You want to set the effective cache size for indexes to 512MB. Which parameter should you configure?
- A. cache_size = 512MB
- B. index_cache = 512MB
- C. effective_cache_size = 512MB
- D. shared_cache = 512MB
Answer: C
NEW QUESTION # 62
You need to determine the names and definitions of all views in the edbuser schema. Which query should you use?
- A. SELECT * FROM pg_views WHERE schemaname='edbuser';
- B. SELECT * FROM pg_views;
- C. SELECT * FROM information_schema.views WHERE table_schema='edbuser';
- D. Both B and C
Answer: D
NEW QUESTION # 63
You want to set the maximum time to complete client authentication to 10 seconds. Which parameter should you configure?
- A. connection_timeout = 10s
- B. client_timeout = 10s
- C. authentication_timeout = 10s
- D. auth_timeout = 10s
Answer: C
NEW QUESTION # 64
You want to export the emp table to a CSV file with column headers using the COPY command. Which command should you use?
- A. COPY emp TO '/path/emp.csv' WITH CSV HEADER;
- B. COPY emp TO '/path/emp.csv' DELIMITER ',' HEADER;
- C. EXPORT emp TO '/path/emp.csv' CSV HEADER;
- D. COPY emp TO '/path/emp.csv' WITH CSV;
Answer: A
NEW QUESTION # 65
Which parameter specifies the number of connection slots reserved for superusers?
- A. admin_connections
- B. reserved_connections
- C. superuser_reserved_connections
- D. superuser_connections
Answer: C
NEW QUESTION # 66
Which configuration file controls client authentication in PostgreSQL?
- A. auth.conf
- B. pg_ident.conf
- C. postgresql.conf
- D. pg_hba.conf
Answer: D
NEW QUESTION # 67
Which pg_dump option allows you to dump only the data without schema definitions?
- A. -d
- B. -D
- C. --no-schema
- D. --data-only
Answer: D
NEW QUESTION # 68
What is the purpose of the checkpoint_timeout configuration parameter in PostgreSQL?
- A. To set backup timeout interval
- B. To set the time limit for query execution
- C. To define connection timeout
- D. To control the maximum time between automatic WAL checkpoints
Answer: D
NEW QUESTION # 69
......
Real exam questions are provided for EnterpriseDB PostgreSQL tests, which can make sure you 100% pass: https://freetorrent.dumpsmaterials.com/PostgreSQL-Essentials-real-torrent.html
