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 of the following is a consideration when choosing a partition key in PostgreSQL? The partition key should be frequently updated. The partition key should be a foreign key. The partition key should be used in query filters. The partition key should be a primary key. None Show Hint Choosing a partition key that is used in query filters can improve performance by enabling partition pruning, which reduces the number of partitions scanned. 2. In a PostgreSQL database, which partitioning method allows for the use of global indexes? Inheritance-based partitioning Declarative partitioning Both declarative and inheritance-based partitioning Neither declarative nor inheritance-based partitioning None Show Hint PostgreSQL does not support global indexes for either declarative or inheritance-based partitioning. Each partition must have its own index. 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
