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. When using declarative partitioning, what is a potential downside of using hash partitioning? It does not support partition pruning. It can lead to uneven data distribution. It does not support unique constraints across partitions. It requires manual management of partitions. None 1 out of 20 2. Which partitioning method in PostgreSQL supports the use of default partitions? Neither declarative nor inheritance-based partitioning Both declarative and inheritance-based partitioning Inheritance-based partitioning Declarative partitioning 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
