Given the table users with a JSON column profile containing {"name": "Alice", "age": 30}, what is the output of:

medium📝 query result Q4 of 15

PostgreSQL - JSON and JSONB

Given the table users with a JSON column profile containing {"name": "Alice", "age": 30}, what is the output of:
SELECT profile->>'name' FROM users WHERE id=1;

A"Alice"

BAlice

C30

DNULL

Step-by-Step Solution

Solution:

Step 1: Understand ->> operator output
The ->> operator extracts the JSON field value as plain text, without quotes.
Step 2: Apply to given JSON
The key 'name' has value "Alice" in JSON, so output is the text Alice without quotes.
Final Answer:
Alice -> Option B
Quick Check:
->> returns text without quotes [OK]

Quick Trick: ->> returns plain text, no quotes included [OK]

Common Mistakes:

Expecting output with quotes
Confusing -> and ->> output types
Assuming numeric output for string keys

Master "JSON and JSONB" 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

Given the table users with a JSON column profile containing {"name": "Alice", "age": 30}, what is the output of:

Step 1: Understand ->> operator output

Step 2: Apply to given JSON

Final Answer:

Quick Check:

Want More Practice?