Postgres 16 Beginners Knowledge Quiz

Which of below are valid methods to create a database?

which flag in psql will list all databaseS?

Which of the below platforms are packages and installers available for?

When using pg_dump if o/s filesize limit will cause a dump to fail as dump as its too large what native o/s commands can use to reduce filesize.

Which 2 commands can either be run to reload update to pg_hba.conf

A database cluster is a 2 node active/active Database for High Availability in Postgres?

Which of the below are 2 default tablespaces with Postgres?

Which command modifies Database settings at the cluster level?

Which 2 command are used to provide or remove privileges in Postgres?

which below functions can be used to CAST one datatype to another

Which postgres server paraemeter are read only?

pgAdmin query tool allows user to perform which of the below:

Postgres uses a threads based process model?

How can you cancel a user query?

What is the purpose of continuous archiving?

What is a another word for a table or index in Postgres?

What can wal_level be set to for continuous archiving to be setup?

Postgres does not support sequences?

Vacuuming takes out SHARED locks only to allow performance to not be impeded?

The query below will return a list of databases?

SELECT datname FROM pg_database;