Postgres Quiz Archive

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

2. What is a schema?

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

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

5. Each Database has its own System Catalog?

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

7. What is the purpose of wal writer?

8. What is the purpose of autovacuum?

9. Which of below are predefined schemas?

choose 2

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

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

12. Files are logically split into pages?

13. System Catalog tables begin with which prefix?

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

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

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

17. What is another name for the postgres process?

18. Postgres uses a thread based process model?

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

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

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

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

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

4. Which of the below are valid Isolations Levels?

choose 2

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

6. A phantom read anomaly occurs when?

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

8. What is the default Isolation Level?

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

Select more than 1 answer below:

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

1. Information about subtransactions is stored under?

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

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

choose 2

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

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

6. CLOG contains how many bits for each transaction?

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

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

9. Rows of TOAST tables are handled in such a way that they are never update?

10. Tuples can also be referred to as columns?