PostgreSQL-Essentials Questions - Truly Beneficial For Your EnterpriseDB Exam (Updated 90 Questions)
View All PostgreSQL-Essentials Actual Exam Questions, Answers and Explanations for Free
NEW QUESTION # 21
Which command in psql toggles between aligned and unaligned output mode?
- A. \format
- B. \t
- C. \align
- D. \a
Answer: D
NEW QUESTION # 22
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. --wal-segsize
- B. No such option is available in PostgreSQL
- C. -x
- D. --waldir
Answer: A
NEW QUESTION # 23
Which parameter sets the number of autovacuum worker processes?
- A. max_autovacuum_workers
- B. vacuum_workers
- C. autovacuum_workers
- D. autovacuum_max_workers
Answer: D
NEW QUESTION # 24
In PostgreSQL, what is the default size of a WAL segment file?
- A. 16 MB
- B. 64 MB
- C. 32 MB
- D. 8 MB
Answer: A
NEW QUESTION # 25
Which psql command toggles the display of tuples only (without column headers)?
- A. \x
- B. \h
- C. \t
- D. \a
Answer: C
NEW QUESTION # 26
In PostgreSQL, which command is used to analyze database statistics for the query planner?
- A. REINDEX
- B. ANALYZE
- C. CLUSTER
- D. VACUUM
Answer: B
NEW QUESTION # 27
You need to take a full online base backup of your cluster using pg_basebackup. Which option specifies the output directory?
- A. --output directory
- B. -o directory
- C. -d directory
- D. -D directory
Answer: D
NEW QUESTION # 28
Which PostgreSQL configuration parameter controls the amount of memory used for sorting operations before writing to temporary disk files?
- A. temp_buffers
- B. work_mem
- C. shared_buffers
- D. maintenance_work_mem
Answer: B
NEW QUESTION # 29
In PostgreSQL, which system catalog stores information about databases?
- A. pg_class
- B. pg_database
- C. pg_tables
- D. information_schema.databases
Answer: B
NEW QUESTION # 30
Which of the following commands in psql will execute SQL commands from a file?
- A. \i filename
- B. \e filename
- C. \f filename
- D. \x filename
Answer: A
NEW QUESTION # 31
You want to check the current value of the max_connections parameter. Which SQL command should you use?
- A. GET max_connections;
- B. DISPLAY max_connections;
- C. SELECT max_connections;
- D. SHOW max_connections;
Answer: D
NEW QUESTION # 32
What is the purpose of shared_buffers configuration parameter in PostgreSQL?
- A. To set the amount of memory for sorting
- B. To control WAL buffer size
- C. To determine memory for caching data from disk
- D. To set connection pool size
Answer: C
NEW QUESTION # 33
Which system view provides real-time information about currently active sessions and running queries?
- A. pg_active_sessions
- B. pg_stat_activity
- C. pg_current_queries
- D. pg_sessions
Answer: B
NEW QUESTION # 34
You want to gracefully terminate a user's connection to the database. Which function should you use?
- A. pg_disconnect_backend(pid)
- B. pg_kill_backend(pid)
- C. pg_terminate_backend(pid)
- D. pg_cancel_backend(pid)
Answer: C
NEW QUESTION # 35
Which utility is used to take a backup of all databases in a PostgreSQL cluster including roles and tablespaces?
- A. pg_dumpall
- B. pg_clusterbackup
- C. pg_backup
- D. pg_dump
Answer: A
NEW QUESTION # 36
Which of the following directories store symbolic links for user-defined tablespaces in PostgreSQL?
- A. pg_tblspc
- B. base
- C. global
- D. pg_wal
Answer: A
NEW QUESTION # 37
Which configuration file controls client authentication in PostgreSQL?
- A. pg_ident.conf
- B. pg_hba.conf
- C. auth.conf
- D. postgresql.conf
Answer: B
NEW QUESTION # 38
Which pg_dump option allows you to dump only the data without schema definitions?
- A. --no-schema
- B. -d
- C. --data-only
- D. -D
Answer: C
NEW QUESTION # 39
Which psql meta-command is used to describe a table including its structure, columns, and constraints?
- A. \dt tablename
- B. \d tablename
- C. \describe tablename
- D. \show tablename
Answer: B
NEW QUESTION # 40
Which psql meta-command is used to list all databases in the cluster?
- A. \list
- B. \l
- C. Both A and B
- D. \databases
Answer: C
NEW QUESTION # 41
You want to set temporary memory to 8MB. Which parameter should you configure?
- A. temp_memory = 8MB
- B. work_mem = 8MB
- C. temporary_memory = 8MB
- D. temp_buffers = 8MB
Answer: D
NEW QUESTION # 42
Which command reclaims all obsolete row space and compacts the customers table for reuse?
- A. VACUUM FULL customers;
- B. VACUUM customers;
- C. CLUSTER customers;
- D. ANALYZE customers;
Answer: A
NEW QUESTION # 43
You need to configure your server to accept TCP/IP connections from specific IP addresses. Which file should you modify?
- A. recovery.conf
- B. pg_ident.conf
- C. pg_hba.conf
- D. postgresql.conf
Answer: C
NEW QUESTION # 44
......
PostgreSQL-Essentials dumps Free Test Engine Verified By It Certified Experts: https://passleader.examtorrent.com/PostgreSQL-Essentials-prep4sure-dumps.html
