Which command reclaims all obsolete row space and compacts the customers table for reuse?

• A.ANALYZE customers;
• B.CLUSTER customers;
• C.VACUUM FULL customers;
• D.VACUUM customers;

Comment: *

Name: *

Email: *

Verification: *

You want to gracefully terminate a user's connection to the database. Which function should you use?

• A.pg_terminate_backend(pid)
• B.pg_kill_backend(pid)
• C.pg_cancel_backend(pid)
• D.pg_disconnect_backend(pid)

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

In PostgreSQL, which system catalog stores information about databases?

• A.pg_class
• B.information_schema.databases
• C.pg_database
• D.pg_tables

Comment: *

Name: *

Email: *

Verification: *

Which psql command quits the psql interface?

• A.All of the above
• B.\exit
• C.\quit
• D.\q

Comment: *

Name: *

Email: *

Verification: *