Skip to main content
Journey Uncommon Logo
JourneyUncommon
mediumSQLJSONB queryingSingle-choice MCQ

Given a JSONB column `data`, which expression returns the boolean true (a JSON value) rather than text, for the row where data = '{"flags": {"active": true}}'?

-- column: data jsonb -- A) data -> 'flags' -> 'active' -- B) data ->> 'flags' ->> 'active' -- C) data #>> '{flags,active}' -- D) data -> 'flags' ->> 'active'