Postgres Quiz Archive

1. What is the purpose of wal writer?

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

3. What is the purpose of the public schema?

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

5. Files are logically split into pages?

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

7. Postgres server spawns a new backend session for each connection?

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

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

10. What is the purpose of the template0 database?

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

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

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

14. Which of below are predefined schemas?

choose 2

15. What is a schema?

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

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

18. The default Page size is 2k?

19. Which fork is specific for unlogged tables?

20. TOAST tables reside in a seperate schema?

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

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

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

choose 3

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

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. At any moment the database system can contain several versions of one and the same row?

9. non-repeatable read anomaly occurs when?

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

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

2. Information about subtransactions is stored under?

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

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. Indexes values also support multi versioning with several versions of an index value existing at any point in time?

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

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

choose 2

9. indexes do not use row versioning?

10. Tuples can also be referred to as columns?