Postgres Quiz Archive

1. What is a schema?

2. Postgres server spawns a new backend session for each connection?

3. What is the point of the pg_global tablespace?

4. Which 3 databases exist directly after cluster initialization?

choose 3 options

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

choose 3

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

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

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

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

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

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

12. What is another name for the postgres process?

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

14. Which fork contains the actual table data?

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

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

17. Tablespaces are used to define physical data layout?

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

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

Choose 2 option

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

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

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

3. The SQL standard specifies three isolation levels?

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

5. What is the default Isolation Level?

6. non-repeatable read anomaly occurs when?

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

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

Select more than 1 answer below:

9. Which parameters sets the database default isolation level?

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

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

2. The page header stores checksum and the sizes of the other parts of the page?

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

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

5. CLOG files are stored in which directory?

6. Information about subtransactions is stored under?

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

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

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

10. CLOG contains how many bits for each transaction?