Postgres Quiz Archive

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

2. Each Database has its own System Catalog?

3. To understand each other, a client and a server must use one and the same interfacing protocol?

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

5. The pg_default tablespace should never be used to create user tables?

6. What is the purpose of the postgres database?

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

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

choose 2

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

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

11. What 3 files/forks as a minimum make up a table on disk?

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

13. System Catalog tables begin with which prefix?

14. What is the purpose of the template0 database?

15. Some System Catalog tables are common to all databases in the cluster?

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

17. What is the purpose of the visibility map?

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

choose 3

19. TOAST tables reside in a seperate schema?

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

Choose 2 option

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

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

Select more than 1 answer below:

3. A phantom read anomaly occurs when?

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. Data Consistency is best handled at the application layer rather than at the database layer?

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

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

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

choose 3

10. Which of the below are valid Isolations Levels?

choose 2

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

2. Which 2 items does a Virtual XID consist of?

3. The page Special Space is located at the start of the page with highest address

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

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

6. indexes do not use row versioning?

7. status of a subtransaction is written into CLOG?

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

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

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