Which of the following is the correct way to declare a JSON column in a PostgreSQL table?

easy📝 Syntax Q12 of 15

PostgreSQL - JSON and JSONB

ACREATE TABLE data (info XML);

BCREATE TABLE data (info TEXT[]);

CCREATE TABLE data (info VARCHAR);

DCREATE TABLE data (info JSON);

Step-by-Step Solution

Solution:

Step 1: Identify JSON data type syntax
PostgreSQL uses the JSON or JSONB data type to store JSON data.
Step 2: Check each option
Only CREATE TABLE data (info JSON); uses JSON type correctly; others use unrelated types.
Final Answer:
CREATE TABLE data (info JSON); -> Option D
Quick Check:
JSON column = JSON type [OK]

Quick Trick: Use JSON or JSONB type for JSON columns [OK]

Common Mistakes:

Master "JSON and JSONB" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free