Postgres Quiz Archive

1. Which fork is specific for unlogged tables?

2. What is the purpose of the postgres database?

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

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

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

6. Files are logically split into pages?

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

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

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

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

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

12. Which of below are predefined schemas?

choose 3

13. What is the purpose of the visibility map?

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

15. System Catalog tables begin with which prefix?

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

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

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

19. What command is used to create the Postgres cluster?

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

Choose 2 option

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

choose 3

2. Which parameters sets the database default isolation level?

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

4. non-repeatable read anomaly occurs when?

5. What is the default Isolation Level?

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

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

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

9. The SQL standard specifies three isolation levels?

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

Select more than 1 answer below:

1. Which of the below are true about a Pages Item Pointer?

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

3. CLOG contains how many bits for each transaction?

4. UPDATE can be regarded as which 2 separate operations?

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

6. Tuples can also be referred to as columns?

7. status of a subtransaction is written into CLOG?

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

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

choose 2

10. Page header sizes can be easily displayed using the <choose from answers> extension