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

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

False

True

2 / 20

Which o/s file are server settings updated in?

postgresql.sql

postgresql.conf

postgresql.dat

postgresql.txt

3 / 20

pgcrypto supports only 1 way encryption?

True

False

4 / 20

Which of the below are attributes or connected to JIT compilation?

java

accelerating expression evaluation

jdbc

tuple deforming

5 / 20

Which of the below are valid modes to stop a cluster?

Fast

Abort

Smart

Safe

6 / 20

Which configuration files restricts and configures host based access?

pg_access.conf

pg_hba.conf

pg_network.conf

postgresql.conf

7 / 20

Which of below support incremental backups?

pgBackRest

pg_dumpall

Barman

Pg_basebackup

8 / 20

pg_tables view will list all tables in the database?

False

True

9 / 20

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

False

True

10 / 20

Which postgres command is used to unload table data into csv files on disk?

SELECT FOR UPDATE

pg_dumpall

pg_dump

COPY

11 / 20

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

Review past queries SQL

Run query SQL

Save query SQL

Run flashback query SQL

12 / 20

pg_dumpall can also dump users but not global objects?

True

False

13 / 20

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

sqlplus

isql

pg_ctl

psql

14 / 20

What is the purpose of schema search_path

no such concept

resolve order which objects are searched by owner

a special type of index different from btree

provide fast access to table using an index

15 / 20

which extension can be used to encrypt column data?

pg_aes

pgcrypto

pg_crypto

pg_sga

16 / 20

If we delete all rows from a table, its data pages are automatically deleted to free space on disk?

False

True

17 / 20

Vacuuming takes out SHARED locks only to allow performance to not be impeded?

False

True

18 / 20

What is the maximum Row Size in Postgres?

1.6TB

1Gb

3.2TB

100Mb

19 / 20

What is the default search_path

"$user"

"$schema", "$user"

public

"$user", public

20 / 20

Which of the below are valid Postgres environment variables?

PGCLUSTER

PGDATA

PGREPGROUP

PGPORT

Your score is

0%

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.

Necessary

Always Enabled

Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.

Cookie	Duration	Description
cookielawinfo-checkbox-analytics	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional	11 months	The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy	11 months	The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.

Others