Postgres Quiz Archive

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

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

3. Which 3 databases exist directly after cluster initialization?

choose 3 options

4. Which of below are predefined schemas?

choose 2

5. Which fork is specific for unlogged tables?

6. Tablespaces are used to define physical data layout?

7. TOAST tables reside in a seperate schema?

8. Postgres uses a thread based process model?

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

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

choose 3

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

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

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

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

15. Users should not modify the template0 database

16. What is a schema?

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

18. What is the purpose of the template1 database?

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

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

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

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

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

choose 3

4. non-repeatable read anomaly occurs when?

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

6. A phantom read anomaly occurs when?

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

8. Which of the below are valid Isolations Levels?

choose 2

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

Select more than 1 answer below:

10. The SQL standard specifies three isolation levels?

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

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

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

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

5. Indexes values also support multi versioning with several versions of an index value existing at any point in time?

6. CLOG Pages are never cached in memory?

7. Postgres table physical data files are always cross compatible across platforms?

8. indexes do not use row versioning?

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

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