Postgres Quiz Archive

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

2. Which fork is specific for unlogged tables?

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

4. To understand each other, a client and a server must use one and the same interfacing protocol?

5. A schema can belong to more than one database?

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

7. TOAST tables reside in a seperate schema?

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

choose 2

9. What is the default standard size for a fork file?

10. Each Database has its own System Catalog?

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

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

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

choose 3

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

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

16. Which of below are predefined schemas?

choose 2

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

18. Which 3 databases exist directly after cluster initialization?

choose 3 options

19. The default Page size is 2k?

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

1. non-repeatable read anomaly occurs when?

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

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

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

5. Which of the below are valid Isolations Levels?

choose 2

6. A phantom read anomaly occurs when?

7. Which parameters sets the database default isolation level?

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

9. At any moment the database system can contain several versions of one and the same row?

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

1. When a transaction is committed Postgres uses a special <replace with answer> structure?

2. UPDATE can be regarded as which 2 separate operations?

3. virtual IDs exist only in PGDATA/pg_vxid when not cached?

4. Information about subtransactions is stored under?

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

6. Page free space can often become fragmented?

7. status of a subtransaction is written into CLOG?

8. a transaction containing a savepoint is will still be considered as only a single transaction?

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

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