Postgres Quiz Archive

1. What is the purpose of the postgres database?

2. What is another name for the postgres process?

3. System Catalog tables begin with which prefix?

4. What is a schema?

5. Which fork keeps track of available space within pages?

6. Postgres uses a thread based process model?

7. Which of below are predefined schemas?

choose 2

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

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

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

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

12. The default Page size is 2k?

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

choose 3

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

15. What is the purpose of wal writer?

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

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

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

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

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

1. The SQL standard specifies three isolation levels?

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

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

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

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

Select more than 1 answer below:

6. non-repeatable read anomaly occurs when?

7. Which parameters sets the database default isolation level?

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

choose 3

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

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

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

2. CLOG contains how many bits for each transaction?

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

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

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

6. What does an Item Pointer contain?

choose 3

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

8. indexes do not use row versioning?

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

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

choose 2