Postgres Quiz Archive

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

2. System Catalog tables begin with which prefix?

3. Users should not modify the template0 database

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

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

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

7. Each Database has its own System Catalog?

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

choose 3

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

10. What is the purpose of wal writer?

11. A single Postgres Instance can server only one database?

12. Postgres uses a thread based process model?

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

14. What is the purpose of the postgres database?

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

16. Which fork is specific for unlogged tables?

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

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

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

20. When PostgreSQL is running what can it be referred to as?

Choose 2 option

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

2. non-repeatable read anomaly occurs when?

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

4. A phantom read anomaly occurs when?

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

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

Select more than 1 answer below:

7. What is the default Isolation Level?

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

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

10. The SQL standard specifies three isolation levels?

1. What does an Item Pointer contain?

choose 3

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

3. psql provides a special mode that allows you to continue a transaction after a failure?

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

choose 2

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

6. The page header is located in the highest address?

7. Information about subtransactions is stored under?

8. If a transaction aborts, all page changes are reverted(rolled back) in place?

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

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