Postgres Quiz Archive

1. Some System Catalog tables are common to all databases in the cluster?

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

3. What is a schema?

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

5. Users should not modify the template0 database

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

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

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

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

10. What is the purpose of the template1 database?

11. What is the purpose of wal writer?

12. Files are logically split into pages?

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

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

choose 3

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

16. Tablespaces are used to define physical data layout?

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

18. TOAST tables reside in a seperate schema?

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

Choose 2 option

20. What is another name for the postgres process?

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

2. Which of the below are valid Isolations Levels?

choose 2

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

4. non-repeatable read anomaly occurs when?

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

6. What is the default Isolation Level?

7. Which parameters sets the database default isolation level?

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

Select more than 1 answer below:

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

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

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

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

3. CLOG files are stored in which directory?

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

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

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

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

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

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

10. Tuples can also be referred to as columns?