Postgres 16 Beginners Knowledge Quiz

/20
Created by Paul Sammy

Postgres 16 Beginner Knowledge Checker Test 1.0

20 Questions chosen at Random to test your knowledge.

You have 3 minutes so think fast.

1 / 20

Which connectors does Postgres Support?

2 / 20

which environment variable can be used to specify a user for psql?

3 / 20

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

4 / 20

What does \x instruct psql to do?

5 / 20

What is the maximum Table Size in Postgres?

6 / 20

What files is used by Postgres for configuration settings?

7 / 20

a VACUUM FULL will recover space from a delete at the o/s level?

8 / 20

What language is Postgres written in for portability

9 / 20

Which psql command will return a list of all dictionary views?

10 / 20

SELinux must be set to which  mode on systems with SELinx

11 / 20

which system function will show current user connected as?

12 / 20

Which of below utilities are considerations for logical backup?

13 / 20

Pages from a delete can only be reused once a Vacuum operation has been performed?

14 / 20

Which command modifies Database settings at the cluster level?

15 / 20

What is the purpose of the WAL writer?

16 / 20

which command can be used to verify a backup taken with pg_basebackup?

17 / 20

which psql command will return a list of databases?

18 / 20

pgAdmin can be used to run a database backup?

19 / 20

Which flag in psql can be used to save output to a file?

20 / 20

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

Your score is

0%

Exit