PostgreSQL Database Administration Quiz Questions and Answers

Which of the following processes does not exist in PostgreSQL?

Answer :
  • WAL cleaner process

Does PostgreSQL have a Connection Pool mechanism out of the box?

Answer :
  • Yes

What is shared_buffers used for?

Answer :
  • To configure data cache size

What is the Default WAL size?

Answer :
  • 16MB

What is the default value for WAL page size?

Answer :
  • 8kb

What does the REDO function do?

Answer :
  • It replays all transactions from the last checkpoint

Which of the following is the default isolation level in PostgreSQL?

Answer :
  • Read Commited

Is auto vacuum enabled by default?

Answer :
  • Yes

How to get the query plan with actual data?

Answer :
  • Explain analyze

Which of the following role attributes do not exist in PostgreSQL?

Answer :
  • LOGOUT