Postgres Quiz Archive

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

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

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

4. The default Page size is 2k?

5. Tablespaces are used to define physical data layout?

6. Users should not modify the template0 database

7. Which of below are predefined schemas?

choose 2

8. Each Database has its own System Catalog?

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

10. What is the purpose of wal writer?

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

12. Tablespaces can be used to segregate data based on performance needs?

13. Each tablespaces can only be assigned for use by one database

14. Postgres uses a thread based process model?

15. What is the purpose of the public schema?

16. How many files or forks on disk will a 10Mb table with no index have?

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

Choose 2 option

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

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

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

choose 3

1. At any moment the database system can contain several versions of one and the same row?

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

Select more than 1 answer below:

3. Which of the below are valid Isolations Levels?

choose 2

4. The SQL standard specifies three isolation levels?

5. Which parameters sets the database default isolation level?

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

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

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

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

10. non-repeatable read anomaly occurs when?

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

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

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

choose 2

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

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

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

7. CLOG Pages are never cached in memory?

8. status of a subtransaction is written into CLOG?

9. CLOG contains how many bits for each transaction?

10. What does an Item Pointer contain?

choose 3