Postgres Quiz Archive

1. The default Page size is 2k?

2. Each Database has its own System Catalog?

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

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

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

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

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

choose 3

8. What is the purpose of wal writer?

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

10. Which 3 databases exist directly after cluster initialization?

choose 3 options

11. What is the purpose of the template0 database?

12. Which of below are predefined schemas?

choose 2

13. What is the purpose of the visibility map?

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

15. TOAST tables reside in a seperate schema?

16. What is another name for the postgres process?

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

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

19. What is the default standard size for a fork file?

20. pg_catalog schema is used to store system catalog tables?

1. A phantom read anomaly occurs when?

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. Snapshot isolation is preferred but increases the number of required locks?

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

Select more than 1 answer below:

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

7. The SQL standard specifies three isolation levels?

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

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

choose 3

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

1. A page along with its tuples is read into the buffer cache with compression transformations to enhance cache efficiency?

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

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

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

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

6. CLOG files are stored in which directory?

7. Information about subtransactions is stored under?

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

9. Page free space can often become fragmented?

10. What does an Item Pointer contain?

choose 3