Postgres Quiz Archive

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

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

choose 3

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

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

5. Each Database has its own System Catalog?

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

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

8. Files are logically split into pages?

9. Tablespaces are used to define physical data layout?

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

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

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

13. What is the name of the system catalog table for relations?

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

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

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

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

18. Which 3 databases exist directly after cluster initialization?

choose 3 options

19. System Catalog tables begin with which prefix?

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

1. Which parameters sets the database default isolation level?

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

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

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

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

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

7. non-repeatable read anomaly occurs when?

8. The SQL standard specifies three isolation levels?

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

choose 3

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

Select more than 1 answer below:

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

2. virtual IDs exist only in PGDATA/pg_vxid when not cached?

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

4. index row headers like table row headers contain xmin and xmax fields?

5. CLOG files are stored in which directory?

6. If a transaction is read only which kind of Transaction ID is it allocated?

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

8. What does an Item Pointer contain?

choose 3

9. Tuples can also be referred to as columns?

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