Postgres Quiz Archive

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

2. Postgres uses a thread based process model?

3. What is the purpose of the public schema?

4. What is the name of the 2 default tablespaces created after initialization?

choose 2

5. Which fork is specific for unlogged tables?

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

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

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

9. TOAST tables reside in a seperate schema?

10. The default Page size is 2k?

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

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

13. Which of below are predefined schemas?

choose 3

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

15. Users should not modify the template0 database

16. What is the purpose of the visibility map?

17. What is the purpose of the postgres database?

18. Which 3 databases exist directly after cluster initialization?

choose 3 options

19. Each Database has its own System Catalog?

20. Which of below are predefined schemas?

choose 2

1. Which parameters sets the database default isolation level?

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

Select more than 1 answer below:

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

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

5. non-repeatable read anomaly occurs when?

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

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

8. Which of the below are valid Isolations Levels?

choose 2

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

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

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

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

3. CLOG files are stored in which directory?

4. What does an Item Pointer contain?

choose 3

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

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

7. Page free space can often become fragmented?

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

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

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