Postgres Quiz Archive

1. Which fork is specific for unlogged tables?

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

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

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

5. Which 3 databases exist directly after cluster initialization?

choose 3 options

6. TOAST tables reside in a seperate schema?

7. System Catalog tables begin with which prefix?

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

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

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

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

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

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

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

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

16. The default Page size is 2k?

17. What is the purpose of the visibility map?

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

choose 3

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

20. What is another name for the postgres process?

1. What is the default Isolation Level?

2. non-repeatable read anomaly occurs when?

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

choose 3

4. Which parameters sets the database default isolation level?

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

6. Which of the below are valid Isolations Levels?

choose 2

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

Select more than 1 answer below:

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

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

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

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

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

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

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

5. Information about subtransactions is stored under?

6. indexes do not use row versioning?

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

8. Page free space can often become fragmented?

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

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