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 of the below statements is true about tablespaces?

2 / 20

ANALYZE command can be run on temporary tables?

3 / 20

Which of below utilities are considerations for logical backup?

4 / 20

Where can we view current connections to database?

5 / 20

Using psql what is '-p' flag user for

6 / 20

A CROSS JOIN and a FULL OUT JOIN are the same thing?

7 / 20

What is another name for a row in Postgres?

8 / 20

Which default cli is used to run sql commands in Postgres?

9 / 20

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

10 / 20

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

11 / 20

Which JOINS does postgres support from below:

12 / 20

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

13 / 20

Which free open source graphical monitoring tool can be used with postgres?

14 / 20

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

15 / 20

Explain plans show which of below:

16 / 20

Which parameter can we set in postgres to track ling running queries?

17 / 20

superuser can be locked to certain IPs

18 / 20

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

19 / 20

Postgres does not Support Table partitioning?

20 / 20

Some views allow data to be updated?

Your score is

0%

Exit