最新的EnterpriseDB PostgreSQL Essentials Certification v13 - PostgreSQL-Essentials免費考試真題
Which psql meta-command is used to describe a table including its structure, columns, and constraints?
正確答案: A
You want to create a backup of all databases in a PostgreSQL cluster. Which utility should you use?
正確答案: A
Which directory in the PostgreSQL data directory contains the Write-Ahead Log files?
正確答案: D
You want to reload the PostgreSQL configuration without restarting the server. Which function should you execute?
正確答案: C
Which command can be used to display all roles and their attributes in PostgreSQL using psql?
正確答案: C
You need to determine the names and definitions of all views in the edbuser schema. Which query should you use?
正確答案: C
In PostgreSQL 13, which command is used to switch your connection to a different database in psql?
正確答案: D
You want to export the emp table to a CSV file with column headers using the COPY command. Which command should you use?
正確答案: C
In PostgreSQL, which command is used to analyze database statistics for the query planner?
正確答案: D