Partitioning: Declarative vs. Inheritance-based Quiz Home › PostgreSQL DBA › Partitioning: Declarative vs. Inheritance-based 📊 Postgres Database Administration – Partitioning: Declarative vs. Inheritance-based 20 questions · 15 min timer · Explanations included · Free 1. In a PostgreSQL database, which partitioning method allows for the use of global indexes? Declarative partitioning Neither declarative nor inheritance-based partitioning Inheritance-based partitioning Both declarative and inheritance-based partitioning None 1 out of 20 2. In PostgreSQL, what is a benefit of using subpartitioning? It provides additional granularity for data management. It allows for the use of global indexes. It simplifies the partitioning strategy. It improves performance by reducing the number of partitions. None 2 out of 20 Loading questions... 3 out of 20 Loading questions... 4 out of 20 Loading questions... 5 out of 20 Loading questions... 6 out of 20 Loading questions... 7 out of 20 Loading questions... 8 out of 20 Loading questions... 9 out of 20 Loading questions... 10 out of 20 Loading questions... 11 out of 20 Loading questions... 12 out of 20 Loading questions... 13 out of 20 Loading questions... 14 out of 20 Loading questions... 15 out of 20 Loading questions... 16 out of 20 Loading questions... 17 out of 20 Loading questions... 18 out of 20 Loading questions... 19 out of 20 Loading questions... 20 out of 20 Click Submit to see your final score! Previous Start Quiz Next Time's up
