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

Postgres does not Support Table partitioning?

2 / 20

Which JOINS does postgres support from below:

3 / 20

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

4 / 20

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

5 / 20

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

6 / 20

SELinux must be set to which  mode on systems with SELinx

7 / 20

which system function will show current user connected as?

8 / 20

Constraints can be set to be deferrable?

9 / 20

Its possible to restrict what data is returned to a user depending on who they log on if they query the same table?

10 / 20

Which of the below types does Postgres Support?

11 / 20

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

12 / 20

pg_dumpall can also dump users but not global objects?

13 / 20

What is the standard Page size in Postgres?

14 / 20

Which postgres server paraemeter are read only?

15 / 20

What command is used to initialise a new cluster?

16 / 20

What is the maximum number of indexes a table can have in Postgres?

17 / 20

which flag in psql will list all databaseS?

18 / 20

Which flag in psql can be user to switch database connections?

19 / 20

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

20 / 20

What language is Postgres written in for portability

Your score is

0%

Exit