Medium-EasyUnderstandRDBMS & SQLMultiple Choice

In PostgreSQL, what is the advantage of JSONB over the JSON data type?

Understand — Tests comprehension and ability to explain concepts.

Answer Options

AJSONB preserves key order and duplicate keys; JSON does not
BJSONB stores data in binary format, supports GIN indexing, and has faster query performance; JSON stores raw text
CJSONB is human-readable; JSON requires decoding
DJSONB supports nested arrays; JSON only supports flat objects

Want to see the correct answer?

Get the answer with a detailed explanation, plus practice 15+ more RDBMS & SQL questions with adaptive quizzes and timed interviews.

See the Answer on Guru Sishya →

This question is from the RDBMS & SQL topic (Databases).

Learn RDBMS & SQL→Browse All Questions

More RDBMS & SQL Questions

Which JOIN type returns all rows from the left table and matched rows from the right table, filling NULLs where there is no match?

Easy

What is the difference between RANK() and DENSE_RANK() window functions when there are ties?

Medium-Easy

What type of index should you use for a column that is only ever queried with exact equality checks (e.g., WHERE user_id = 42)?

Medium-Easy

Which ACID property guarantees that a committed transaction's data survives a system crash?

Easy

At which isolation level can 'phantom reads' occur — where a transaction re-runs a query and finds new rows inserted by another committed transaction?

Medium