Postgres Quiz Archive

1. What is the purpose of the public schema?

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

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

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

5. Users should not modify the template0 database

6. Which fork contains the actual table data?

7. What is the purpose of the template0 database?

8. Which of below are predefined schemas?

choose 2

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

10. System Catalog tables begin with which prefix?

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

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

13. What is another name for the postgres process?

14. What is the purpose of the template1 database?

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

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

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

18. The default Page size is 2k?

19. How does Postgres know which schema to use if not specified?

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

1. which of the below statements will start a transaction as Read Repeatable?

2. non-repeatable read anomaly occurs when?

3. A phantom read anomaly occurs when?

4. What is the default Isolation Level?

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

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

7. Which of the below are valid Isolations Levels?

choose 2

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

Select more than 1 answer below:

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

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

choose 3

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

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

3. CLOG files are stored in which directory?

4. status of a subtransaction is written into CLOG?

5. Which 2 of the below represent transaction IDs used for row versioning?

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

7. Which function can we use to find the current transaction ID?

8. In Postgres, tables are often referred to as which of the below?

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

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