You want to store user preferences as flexible key-value pairs and also generate unique IDs for each user. Which combination of extensions should you enable?

hard📝 Application Q8 of 15

PostgreSQL - Advanced Features

AEnable hstore for key-value storage and uuid-ossp for UUID generation

BEnable pg_trgm for key-value storage and hstore for UUIDs

CEnable uuid-ossp for key-value storage and pg_trgm for UUIDs

DEnable pg_trgm for both key-value storage and UUID generation

Step-by-Step Solution

Solution:

Step 1: Match extensions to features
hstore stores key-value pairs; uuid-ossp generates UUIDs.
Step 2: Eliminate incorrect pairs
pg_trgm is for text similarity, not key-value or UUIDs.
Final Answer:
Enable hstore for key-value storage and uuid-ossp for UUID generation -> Option A
Quick Check:
hstore + uuid-ossp = key-value + UUID [OK]

Quick Trick: hstore = key-value, uuid-ossp = UUIDs [OK]

Common Mistakes:

Mixing pg_trgm with key-value or UUID tasks
Assuming uuid-ossp stores key-value pairs
Confusing hstore with text similarity

Master "Advanced Features" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions

You want to store user preferences as flexible key-value pairs and also generate unique IDs for each user. Which combination of extensions should you enable?

Step 1: Match extensions to features

Step 2: Eliminate incorrect pairs

Final Answer:

Quick Check:

Want More Practice?