Postgres Quiz Archive

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

2. What is the purpose of wal writer?

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

4. What is the purpose of the public schema?

5. Which of below are predefined schemas?

choose 2

6. Which fork is specific for unlogged tables?

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

8. Which fork contains the actual table data?

9. Tablespaces are used to define physical data layout?

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

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

12. What is the name of the system catalog table for relations?

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

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

15. TOAST tables reside in a seperate schema?

16. What is the name of the 2 default tablespaces created after initialization?

choose 2

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

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

19. Users should not modify the template0 database

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

1. Which of the below are valid Isolations Levels?

choose 2

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

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

4. A phantom read anomaly occurs when?

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

6. Which parameters sets the database default isolation level?

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

8. non-repeatable read anomaly occurs when?

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

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

Select more than 1 answer below:

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

2. If a transaction is read only which kind of Transaction ID is it allocated?

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

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

5. psql provides a special mode that allows you to continue a transaction after a failure?

6. virtual IDs exist only in PGDATA/pg_vxid when not cached?

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

8. Tuples can also be referred to as columns?

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

10. What does an Item Pointer contain?

choose 3