PostgreSQL Database Administration Quiz Questions and Answers

What is the name of the superuser?

Answer :
  • Postgres

PostgreSQL can be used from just about any major programming language, including C, C++, Perl, Python, Java, Tcl, and PHP. Is it true or false?

Answer :
  • True

What does a meta-command begin with?

Answer :
  • Backslash character (\)

VACUUM FULL shrinks indexes, optimizing database performance. Is it true or false?

Answer :
  • True

When using a SELECT statement on a table, or group of tables, those resources are locked exclusively. Is it true or false?

Answer :
  • False

Which of the following best describes a role?

Answer :
  • A template for authorization to various database objects

The basic SQL command to list tables is________.

Answer :
  • \dt

In PostgreSQL, what is a named collection of tables called?

Answer :
  • Schema

With PostgreSQL, how can you access data?

Answer :
  • Both A B

What command tells PostgreSQL that all of the changes you made to a database should become permanent?

Answer :
  • Commit