Which of the following commands correctly creates a BRIN index on the created_on column of the user_activity table?

easy📝 Syntax Q3 of 15

PostgreSQL - Indexing Strategies

Which of the following commands correctly creates a BRIN index on the created_on column of the user_activity table?

ACREATE INDEX ON user_activity (created_on) USING brin_index;

BCREATE BRIN INDEX user_activity ON created_on;

CCREATE INDEX brin_user_activity ON user_activity (created_on) USING btree;

DCREATE INDEX ON user_activity USING brin (created_on);

Step-by-Step Solution

Solution:

Step 1: Recall BRIN index syntax
The correct syntax is CREATE INDEX [name] ON [table] USING brin (column);
Step 2: Analyze options
CREATE INDEX ON user_activity USING brin (created_on); matches the correct syntax without specifying an index name (which is optional).
Final Answer:
CREATE INDEX ON user_activity USING brin (created_on); -> Option D
Quick Check:
Correct syntax uses 'USING brin' [OK]

Quick Trick: Use 'CREATE INDEX ON table USING brin (column)' syntax [OK]

Common Mistakes:

Master "Indexing Strategies" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free