Postgres Quiz Archive

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

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

choose 2

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

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

choose 3

5. Which of below are predefined schemas?

choose 3

6. It is the postmasters job to listener for incoming connections?

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

8. What is the purpose of the template1 database?

9. The information_schema schema provides information on Postgres release notes?

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

11. Which 3 databases exist directly after cluster initialization?

choose 3 options

12. Files are logically split into pages?

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

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

15. What 3 files/forks as a minimum make up a table on disk?

16. What is the purpose of autovacuum?

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

18. What is the purpose of the public schema?

19. What column in system catalogs servers as the Primary Key

20. Tablespaces are used to define physical data layout?

1. Which of the below are valid Isolations Levels?

choose 2

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

Select more than 1 answer below:

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

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

5. Which parameters sets the database default isolation level?

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

7. non-repeatable read anomaly occurs when?

8. What is the default Isolation Level?

9. Data Consistency is best handled at the application layer rather than at the database layer?

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

1. What does an Item Pointer contain?

choose 3

2. Page free space can often become fragmented?

3. CLOG Pages are never cached in memory?

4. In Postgres, tables are often referred to as which of the below?

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

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

7. status of a subtransaction is written into CLOG?

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

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

10. Information about subtransactions is stored under?