Free EnterpriseDB PostgreSQL-Essentials Exam Dumps Questions & Answers

Which psql meta-command is used to describe a table including its structure, columns, and constraints?

• A.  \dt tablename
• B.  \describe tablename
• C.  \d tablename
• D.  \show tablename

Which psql meta-command is used to display all roles and their attributes?

• A.  \dr
• B.  \roles
• C.  \users
• D.  \du

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;

You need to take a backup of only the edbuser schema from the edbstore database. Which pg_dump option should you use?

• A.  Both B and C
• B.  -s edbuser
• C.  --schema edbuser
• D.  -n edbuser

Which of the following directories store symbolic links for user-defined tablespaces in PostgreSQL?

• A.  global
• B.  pg_tblspc
• C.  pg_wal
• D.  base