Which semi-structured data function returns an OBJECT constructed from the arguments.

Which semi-structured data function returns an OBJECT constructed from the arguments.
A . OBJECT_CONSTRUCT
B. OBJECT_ARRAY
C. OBJECT_INSPECT

View Answer

Answer: A

Explanation:

OBJECT_CONSTRUCT

Returns an OBJECT constructed from the arguments.

Let us do a hands-on exercise to understand this

select object_construct(‘a’,1,’b’,’BBBB’, ‘c’,null);

+———————————————-+

| OBJECT_CONSTRUCT(‘A’,1,’B’,’BBBB’, ‘C’,NULL) |

|———————————————-|

| { |

| "a": 1, |

| "b": "BBBB" |

| } |

+———————————————-+

Please note that the NULL has been omitted

If the key or value is NULL (i.e. SQL NULL), the key-value pair will be omitted from the resulting object. A key-value pair consisting of a not-null string as key and a JSON NULL as value (i.e. PARSE_JSON(‘NULL’)) will not be omitted.