Postgres 16 Beginners Knowledge Quiz

We should VACUUM every table at least every 4 billion transactions?

Which data types are valid character types??

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

You should disable the default postgresql module before on Linux before installing the postgres server?

VACUUM FREEZE marks rows as frozen with special in the the past transaction ID's

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 psql command will return a list of all dictionary views?

SSL can be enforced for selective clients based on host or IP?

Transaction IDs are limited to 4 billion and can run out without maintenance?

What language is Postgres written in for portability

pg_dumpall allows point in time recovery to any point in time as long as WAL logs are available?

What is the name of the file that track row changes in Postgres?

Which of the below is an open source tool for remote backups?

which system function will show current user connected as?

Which data types below are Numeric?

Which environment variable can be set to avoid specifying a database when using psql connections?

Which of the below are the postgres 3 default databases?

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

pg_basebackup requires database to be offline for a valid backup?

What commands add rows to a newly created table and freezes them?