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 uses a threads based process model?

2 / 20

Which 2 commands below are considered DCL?

3 / 20

what utility is used to start and stop a database cluster?

4 / 20

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

5 / 20

What is the purpose of pg_ctl reload command?

6 / 20

A domain is a data type that allows storing of network and web address in a format easily queried?

7 / 20

Which data types are valid character types??

8 / 20

What does \x instruct psql to do?

9 / 20

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

10 / 20

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

11 / 20

What is the standard Page size in Postgres?

12 / 20

The SQL below will generate an EXPLAIN Plan and also run the query?

EXPLAIN select * from paul_sammy_tab1;

13 / 20

Which process listeners for new connections?

14 / 20

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

15 / 20

Which of the below are valid Postgres environment variables?

16 / 20

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

17 / 20

ANALYZE command can be run on temporary tables?

18 / 20

which extension can be used to encrypt column data?

19 / 20

Which of below are valid methods to create a database?

20 / 20

COPY FROM : copies data from a table to a file

Your score is

0%

Exit