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. Which partitioning method in PostgreSQL supports the use of default partitions? Declarative partitioning Both declarative and inheritance-based partitioning Inheritance-based partitioning Neither declarative nor inheritance-based partitioning None Show Hint Declarative partitioning supports the use of default partitions, which can catch data that does not match any other partition's criteria. 2. In PostgreSQL, what is a potential drawback of using too many partitions? Increased storage requirements for partition metadata. Increased complexity in query planning. Decreased performance due to excessive partition pruning. Limited scalability due to partition constraints. None Show Hint Using too many partitions can increase complexity in query planning, as the planner has to consider more partitions, potentially impacting performance. Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Click Submit to see your final score! Previous Start Quiz Next Time's up
