Postgres Quiz Archive

1. What is the point of the pg_global tablespace?

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

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

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

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

6. Which of below are predefined schemas?

choose 3

7. Some System Catalog tables are common to all databases in the cluster?

8. Files are logically split into pages?

9. What is a schema?

10. How many rows in a page does Postgres aim to have before considering TOAST?

11. What is the purpose of the template0 database?

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

13. The default Page size is 2k?

14. Each Database has its own System Catalog?

15. Tablespaces can be used to segregate data based on performance needs?

16. Which of below are predefined schemas?

choose 2

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

18. Which fork contains the actual table data?

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

choose 2

20. Which fork keeps track of available space within pages?

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

Select more than 1 answer below:

2. Which of the below are valid Isolations Levels?

choose 2

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

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

5. A phantom read anomaly occurs when?

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

7. What is the default Isolation Level?

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

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

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

choose 3

1. If a transaction is read only which kind of Transaction ID is it allocated?

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

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

choose 2

4. Which function can we use to find the current transaction ID?

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

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

7. Tuples can also be referred to as columns?

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

9. at any one time Postgres can have several versions of a row?

10. What does an Item Pointer contain?

choose 3