Postgres Quiz Archive

1. System Catalog tables begin with which prefix?

2. Which of below are predefined schemas?

choose 3

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

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

5. Postgres uses a thread based process model?

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

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

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

9. A single Postgres Instance can server only one database?

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

choose 3

11. Each Database has its own System Catalog?

12. If we create a new tablespace which directory will symbolic links be created from?

13. What is a schema?

14. What is another name for the postgres process?

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

16. Which fork is specific for unlogged tables?

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

18. Which of below are predefined schemas?

choose 2

19. What is the purpose of autovacuum?

20. TOAST tables reside in a seperate schema?

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

2. non-repeatable read anomaly occurs when?

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

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

5. What is the default Isolation Level?

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

7. The SQL standard specifies three isolation levels?

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

9. Which parameters sets the database default isolation level?

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

choose 3

1. Indexes values also support multi versioning with several versions of an index value existing at any point in time?

2. To identify different versions of one and the same row, PostgreSQL marks each of them with which two value?

3. Which function can we use to find the current transaction ID?

4. status of a subtransaction is written into CLOG?

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

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

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

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

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

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