Postgres Quiz Archive

You have 200 seconds to answer 20 Random questions so think fast!

You will need to score 80% or over to pass!

Created by

Paul Sammy

PostgreSQL 14 Internals Chapter 1

A quiz to test the knowledge of those reading and learning from Postgres 14 Internals book by Egor Rogov, covering topics in Chapter 1.

1 / 20

1. How many files or forks on disk will a 10Mb table with no index have?

2 / 20

2. What is the purpose of the template1 database?

regular database that you can use at your discretion

No such database

a template for all the other databases

database used for temporary tables

3 / 20

3. What is the process first launched at server start?

postgres

postman

pginit

init

4 / 20

4. What is the name of the mechanism used to store a row bigger than a page size?

GROW

BAKE

BREAD

TOAST

5 / 20

5. What is the name of the 2 default tablespaces created after initialization?

choose 2

pg_temp

pg_tablespace

pg_global

pg_default

6 / 20

6. Each tablespaces can only be assigned for use by one database

False

True

7 / 20

7. What command is used to create the Postgres cluster?

StartNewPG

CreateCluster

Initialize

CreatePGC

8 / 20

8. A single Postgres Instance can server only one database?

False

True

9 / 20

9. Which of the below objects can be referred to as relations?

choose 3

sequences

tables

triggers

indexes

10 / 20

10. What is the name of the catalog that stores metadata for all cluster objects?

System Catalog

Sysasm Catalog

Sys Catalog

Sysaux Catalog

11 / 20

11. When PostgreSQL is running what can it be referred to as?

Choose 2 option

Quorum

Postgres Server

Instance

Aurora

12 / 20

12. Which fork is specific for unlogged tables?

free space map

Initialization fork

Main fork

visiblilty map

13 / 20

13. The pg_default tablespace should never be used to create user tables?

True

False

14 / 20

14. Postgres uses a thread based process model?

True

False

15 / 20

15. Postgres by default has built in connection pooling abilities?

False

True

16 / 20

16. What is the purpose of the public schema?

default schema for user objects

no such schema

schema used for heterogeneous replication

restricted schema for postgres internal usage only

17 / 20

17. What is the name of the system catalog table for relations?

pg_tables

pg_class

pg_catalog

pg_system

18 / 20

18. How does Postgres know which schema to use if not specified?

Directory Path

Search Path

Schema Path

Access Path

19 / 20

19. Each Database has its own System Catalog?

False

True

20 / 20

20. System Catalog tables begin with which prefix?

dba_

cat_

pg_

sys_

Your score is

Created by

Paul Sammy

PostgreSQL 14 Internals Chapter 2

A quiz to test the knowledge of those reading and learning from Postgres 14 Internals book by Egor Rogov, covering topics in Chapter 2.

1 / 10

1. Based on Snapshot Isolation use of MVCC which of the below are permitted?

choose 3

Read Uncommitted

Serializable

Repeatable Read

Read Committed

2 / 10

2. The more locks a transaction acquires, the better it is isolated from other transactions?

False

True

3 / 10

3. Which parameters sets the database default isolation level?

default_isolation_level

active_transaction_isolation

transaction_isolation_level

default_transaction_isolation

4 / 10

4. Which isolation level in theory could mean an application does not have to consider isolation anomalies?

Read Committed

Read Uncommitted

Repeatable Read

Serializable

5 / 10

5. What is the acronym used for the attributes that ensure Data consistency, integrity and durability?

ACID

SAFE

HIPPA

SOC2

6 / 10

6. which of the below statements will start a transaction as Read Repeatable?

CREATE EXTENSTION REPEATABLE_READ;

BEGIN ISOLATION LEVEL REPEATABLE READ;

SET ISO=REPEATABLE_READ;

ALTER SYSTEM SET ISO=REPEATABLE_READ;

7 / 10

7. A phantom read anomaly occurs when?

The same transaction executes two identical queries returning a set of rows that satisfy a particular condition, while another transaction adds some other rows satisfying this condition and commits.

The same transaction executes two identical queries returning a set of rows that satisfy a particular condition, while another transaction also queries this same data.

A transactions inserts a null value into a not null columns and commits

The same transactions issues a commit, then a rollback to restore data to its original value

8 / 10

8. Lost updates are forbidden by the standard at all isolation levels?

False

True

9 / 10

9. Which of the below would best describe a dirty read?

reading data direct from memory using pg_dirt

a session being able to see uncommited data altered by another session

reading the data directly from file using a text editor such as vi or notepad

a session being able to see commited data altered by another session

10 / 10

10. non-repeatable read anomaly occurs when?

A transaction reads one and the same row once and modifies this row and commits the change.

A transaction reads one and the same row twice, another transaction modifies this row between these reads issue a rollback.

A transaction reads one and the same row twice, another transaction modifies this row between these reads and commits the change.

A transaction reads one and the same row once, another transaction modifies this row between these reads and commits the change.

Your score is

Created by

Paul Sammy

PostgreSQL 14 Internals Chapter 3

A quiz to test the knowledge of those reading and learning from Postgres 14 Internals book by Egor Rogov, covering topics in Chapter 3.

1 / 10

1. A page along with its tuples is read into the buffer cache with compression transformations to enhance cache efficiency?

False

True

2 / 10

2. Rows of TOAST tables are handled in such a way that they are never update?

True

False

3 / 10

3. CLOG Pages are never cached in memory?

True

False

4 / 10

4. Page header sizes can be easily displayed using the <choose from answers> extension

pageinspect

pageheadinfo

pagedetect

pagesize

5 / 10

5. indexes do not use row versioning?

True

False

6 / 10

6. Each page has a layer that usually consists of?

choose 2

free space

undo segment

flashback block

page header

7 / 10

7. When a row is created, its xmin value is set to the transaction ID of which command?

DELETE

COMMIT

CREATE

INSERT

8 / 10

8. Indexes values also support multi versioning with several versions of an index value existing at any point in time?

True

False

9 / 10

9. The page Special Space is located at the start of the page with highest address

False

True

10 / 10

10. index row headers like table row headers contain xmin and xmax fields?

False

True

Your score is

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.