Free EnterpriseDB PostgreSQL-Essentials Exam Dumps Questions & Answers

Which psql meta-command is used to list all databases in the cluster?

• A.  \databases
• B.  \list
• C.  Both A and B
• D.  \l

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.  Identity
• B.  Serial
• C.  None

Which psql meta-command lists all schemas in the current database?

• A.  \ls
• B.  \ds
• C.  \dn
• D.  \schemas

You need to reload the PostgreSQL configuration without restarting the server. Which function should you use?

• A.  refresh_config()
• B.  pg_reload_conf()
• C.  reload_configuration()
• D.  pg_restart_conf()

You want to export query results to a CSV file from psql. Which command should you use?

• A.  \export filename.csv
• B.  SAVE AS 'filename.csv'
• C.  \copy tablename TO 'filename.csv' CSV
• D.  EXPORT TO 'filename.csv'