PostgreSQL-Essentials Dumps To Pass EnterpriseDB Exam in 24 Hours - ExamCost
Buy Latest PostgreSQL-Essentials Exam Q&A PDF - One Year Free Update
NEW QUESTION # 14
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?
- A. checkpoint_timeout
- B. max_wal_size
- C. wal_size
- D. wal_level
Answer: B
NEW QUESTION # 15
You want to configure your cluster to run in archive mode for Point-in-Time Recovery. Which parameter must you set in postgresql.conf?
- A. backup_mode = on
- B. archiving = on
- C. archive_mode = on
- D. wal_archive = on
Answer: C
NEW QUESTION # 16
You want to view all available functions in the current database using psql. Which command should you use?
- A. \f
- B. \functions
- C. \df
- D. \fn
Answer: C
NEW QUESTION # 17
You need to restore a database from a compressed format backup file created with pg_dump -Fc option.
Which utility should you use?
- A. pg_basebackup
- B. pg_restore
- C. pg_dump
- D. psql
Answer: B
NEW QUESTION # 18
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 -quiet -d databasename -U username
- B. psql -f sqldumpfilename -1 -d databasename -U username
- C. psql -f sqldumpfilename --tuples -d databasename -U username
- D. psql -f sqldumpfilename --all -d databasename -U username
Answer: B
NEW QUESTION # 19
In PostgreSQL, which command is used to analyze database statistics for the query planner?
- A. REINDEX
- B. CLUSTER
- C. VACUUM
- D. ANALYZE
Answer: D
NEW QUESTION # 20
SERIAL and IDENTITY columns can be used to add an auto-incrementing column in a Postgres table. Which of these two column types are SQL standard compliant?
- A. Serial
- B. Identity
- C. None
Answer: B
NEW QUESTION # 21
In PostgreSQL 13, which command is used to switch your connection to a different database in psql?
- A. SET DATABASE dbname;
- B. USE dbname;
- C. \connect dbname
- D. SWITCH dbname;
Answer: C
NEW QUESTION # 22
Which of the following directories store symbolic links for user-defined tablespaces in PostgreSQL?
- A. base
- B. pg_tblspc
- C. pg_wal
- D. global
Answer: B
NEW QUESTION # 23
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?
- A. -U
- B. -authenticate
- C. -A
- D. -db-auth
Answer: C
NEW QUESTION # 24
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. Both B and C
- C. SELECT * FROM pg_views;
- D. SELECT * FROM information_schema.views WHERE table_schema='edbuser';
Answer: B
NEW QUESTION # 25
You want to update statistics for the emp and dept tables to help the query planner. Which command should you use?
- A. UPDATE STATISTICS emp, dept;
- B. ANALYZE emp; ANALYZE dept;
- C. VACUUM emp, dept;
- D. REINDEX emp, dept;
Answer: B
NEW QUESTION # 26
You want to set the maximum time to complete client authentication to 10 seconds. Which parameter should you configure?
- A. authentication_timeout = 10s
- B. connection_timeout = 10s
- C. auth_timeout = 10s
- D. client_timeout = 10s
Answer: A
NEW QUESTION # 27
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?
- A. \e
- B. \r
- C. \l
- D. e
Answer: A
NEW QUESTION # 28
Which pg_restore option allows you to drop database objects before recreating them?
- A. -d
- B. -r
- C. -c or --clean
- D. --drop-all
Answer: C
NEW QUESTION # 29
Which system view provides real-time information about currently active sessions and running queries?
- A. pg_active_sessions
- B. pg_current_queries
- C. pg_sessions
- D. pg_stat_activity
Answer: D
NEW QUESTION # 30
In PostgreSQL 13, which parameter must be set to enable WAL archiving for Point-in-Time Recovery?
- A. archive_level must be set to full
- B. wal_archiving must be set to on
- C. backup_mode must be set to archive
- D. wal_level must be set to replica or higher
Answer: D
NEW QUESTION # 31
You want to set the effective cache size for indexes to 512MB. Which parameter should you configure?
- A. cache_size = 512MB
- B. effective_cache_size = 512MB
- C. shared_cache = 512MB
- D. index_cache = 512MB
Answer: B
NEW QUESTION # 32
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. SHOW DATABASE SIZE;
- C. SELECT name, size FROM pg_database;
- D. SELECT datname, pg_size_pretty(pg_database_size(datname)) AS size FROM pg_database;
Answer: D
NEW QUESTION # 33
Autocommit occurs in which of the following situations?
- A. All DML statements
- B. All DDL statements
- C. On DML and DDL statements
- D. None of the above
Answer: B
NEW QUESTION # 34
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?
- A. -x
- B. --waldir
- C. No such option is available in PostgreSQL
- D. --wal-segsize
Answer: D
NEW QUESTION # 35
......
Download the Latest PostgreSQL-Essentials Dump - 2026 PostgreSQL-Essentials Exam Question Bank: https://pass4sure.examcost.com/PostgreSQL-Essentials-practice-exam.html
