Postgres Quiz Archive

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

choose 3

2. What is the point of the pg_global tablespace?

3. What is the name of the directory that contains the files related to the Postgres cluster?

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

choose 2

5. Which fork is specific for unlogged tables?

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

7. Postgres uses a thread based process model?

8. If we create a new tablespace which directory will symbolic links be created from?

9. What is another name for the postgres process?

10. A Postgres cluster consists of 2 or more physical servers accessing one Postgres Instance?

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

12. Which 3 databases exist directly after cluster initialization?

choose 3 options

13. To be able to restore data consistency, Postgres maintains

14. Users should not modify the template0 database

15. Who is the Author of the Postgres 14 Internals book?

16. Which of below are predefined schemas?

choose 3

17. The default Page size is 2k?

18. Each Database has its own System Catalog?

19. What is the purpose of the visibility map?

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

Choose 2 option

1. Which parameters sets the database default isolation level?

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

3. What are some of database features we can use to avoid a non repeatable read?

Select more than 1 answer below:

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

5. Which of the below are valid Isolations Levels?

choose 2

6. Snapshot isolation is preferred but increases the number of required locks?

7. What is the default Isolation Level?

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

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

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

1. Postgres table physical data files are always cross compatible across platforms?

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

choose 2

3. Information about subtransactions is stored under?

4. Which 2 items does a Virtual XID consist of?

5. CLOG contains how many bits for each transaction?

6. psql provides a special mode that allows you to continue a transaction after a failure?

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

8. To identify different versions of one and the same row, PostgreSQL marks each of them with which two value?

9. Which 2 of the below represent transaction IDs used for row versioning?

10. The page header stores checksum and the sizes of the other parts of the page?