Download EnterpriseDB PostgreSQL-Essentials Mock Test Study Material
PostgreSQL-Essentials Questions Prepare with Learning Information
NEW QUESTION # 26
Which command displays the current search path in PostgreSQL?
- A. GET search_path;
- B. \path
- C. SHOW search_path;
- D. SELECT search_path;
Answer: C
NEW QUESTION # 27
Which psql meta-command lists all schemas in the current database?
- A. \schemas
- B. \dn
- C. \ds
- D. \ls
Answer: B
NEW QUESTION # 28
You need to reclaim storage occupied by dead tuples in the customers table. Which command should you use?
- A. VACUUM customers;
- B. ANALYZE customers;
- C. CLUSTER customers;
- D. REINDEX customers;
Answer: A
NEW QUESTION # 29
Examine the following SQL:
CREATE VIEW vw_emp_details AS SELECT ename, sal, sal*12 AS annsal FROM emp; After creating the above view, what will be the result of the following query?
UPDATE vw_emp_details SET annsal = annsal + 100;
- A. Error: Views cannot be updated
- B. Statement executes successfully and all the rows of emp table are modified
- C. Statement executes successfully but none of the rows of emp table are modified
- D. Error: Cannot update column annsal
Answer: D
NEW QUESTION # 30
In PostgreSQL 13, which command is used to switch your connection to a different database in psql?
- A. USE dbname;
- B. \connect dbname
- C. SET DATABASE dbname;
- D. SWITCH dbname;
Answer: B
NEW QUESTION # 31
What is the purpose of the autovacuum parameter in PostgreSQL?
- A. To compress database files
- B. To manually run vacuum
- C. To enable automatic vacuuming of tables
- D. To backup data automatically
Answer: C
NEW QUESTION # 32
Which parameter controls the amount of memory allocated for maintenance operations like VACUUM and CREATE INDEX?
- A. work_mem
- B. autovacuum_work_mem
- C. maintenance_work_mem
- D. shared_buffers
Answer: C
NEW QUESTION # 33
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. None
- B. Serial
- C. Identity
Answer: C
NEW QUESTION # 34
Which pg_dump option creates a backup that can be restored using pg_restore?
- A. -Fc (custom format)
- B. -Fp (plain text format)
- C. Both B and C
- D. -Ft (tar format)
Answer: C
NEW QUESTION # 35
In PostgreSQL, which command is used to analyze database statistics for the query planner?
- A. REINDEX
- B. VACUUM
- C. CLUSTER
- D. ANALYZE
Answer: D
NEW QUESTION # 36
Which psql meta-command is used to describe a table including its structure, columns, and constraints?
- A. \describe tablename
- B. \dt tablename
- C. \show tablename
- D. \d tablename
Answer: D
NEW QUESTION # 37
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 --tuples -d databasename -U username
- B. psql -f sqldumpfilename -1 -d databasename -U username
- C. psql -f sqldumpfilename --all -d databasename -U username
- D. psql -f sqldumpfilename -quiet -d databasename -U username
Answer: B
NEW QUESTION # 38
Which parameter sets the number of autovacuum worker processes?
- A. max_autovacuum_workers
- B. autovacuum_max_workers
- C. vacuum_workers
- D. autovacuum_workers
Answer: B
NEW QUESTION # 39
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
Answer: A
NEW QUESTION # 40
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. None
- B. Both
- C. Serial
- D. Identity
Answer: D
NEW QUESTION # 41
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. REINDEX emp, dept;
- D. VACUUM emp, dept;
Answer: B
NEW QUESTION # 42
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. \r
- B. \e
- C. \l
- D. e
Answer: B
NEW QUESTION # 43
You need to reload the PostgreSQL configuration without restarting the server. Which function should you use?
- A. refresh_config()
- B. pg_restart_conf()
- C. pg_reload_conf()
- D. reload_configuration()
Answer: C
NEW QUESTION # 44
What is the purpose of the checkpoint_timeout configuration parameter in PostgreSQL?
- A. To define connection timeout
- B. To set backup timeout interval
- C. To set the time limit for query execution
- D. To control the maximum time between automatic WAL checkpoints
Answer: D
NEW QUESTION # 45
Which of the following commands in psql will execute SQL commands from a file?
- A. \e filename
- B. \f filename
- C. \i filename
- D. \x filename
Answer: C
NEW QUESTION # 46
You have created a database user named edbuser with password 'password'. Which command grants connection rights to the edbstore database for user edbuser?
- A. GRANT ACCESS ON DATABASE edbstore TO edbuser;
- B. GRANT ALL ON DATABASE edbstore TO edbuser;
- C. GRANT LOGIN ON DATABASE edbstore TO edbuser;
- D. GRANT CONNECT ON DATABASE edbstore TO edbuser;
Answer: D
NEW QUESTION # 47
Which command reclaims all obsolete row space and compacts the customers table for reuse?
- A. VACUUM FULL customers;
- B. ANALYZE customers;
- C. VACUUM customers;
- D. CLUSTER customers;
Answer: A
NEW QUESTION # 48
In PostgreSQL 13, what is the difference between GENERATED ALWAYS AS IDENTITY and GENERATED BY DEFAULT AS IDENTITY?
- A. BY DEFAULT prevents manual insertion
- B. They are identical
- C. ALWAYS prevents manual value insertion, BY DEFAULT allows it
- D. ALWAYS uses UUID, BY DEFAULT uses serial
Answer: C
NEW QUESTION # 49
......
Most Reliable EnterpriseDB PostgreSQL-Essentials Training Materials: https://www.prep4sureexam.com/PostgreSQL-Essentials-dumps-torrent.html
Practice Material for PostgreSQL-Essentials Exam Question Preparation: https://drive.google.com/open?id=1iPlWD7adBGb7XYIiIP3UZH3yD9Mq_fiD