Postgres Quiz Archive

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

2. Postgres uses a thread based process model?

3. What is the name of the catalog that stores metadata for all cluster objects?

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

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

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

7. Which fork is specific for unlogged tables?

8. What is the purpose of autovacuum?

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

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

11. Which of below are predefined schemas?

choose 3

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

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

14. The default Page size is 2k?

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

Choose 2 option

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

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

18. What is the purpose of the visibility map?

19. What is the purpose of the template1 database?

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

1. The SQL standard specifies three isolation levels?

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

3. non-repeatable read anomaly occurs when?

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

Select more than 1 answer below:

5. What is the default Isolation Level?

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

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

8. Which parameters sets the database default isolation level?

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

choose 3

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

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

2. CLOG files are stored in which directory?

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

4. Page free space can often become fragmented?

5. The page Special Space is located at the start of the page with highest address

6. What does an Item Pointer contain?

choose 3

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

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

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

10. CLOG contains how many bits for each transaction?