Question

SQL

Can a JSON Document have an array of data values?

True / False?

Answer 1

TRUE

PLEASE FIND THE ANSWER(S) and EXPLANATION BELOW.

Yes, we can have an array of data values in a JSON Document. !!

Explanation:-

A JSON document is a collection of key-value pairs where the key should always be a string and the data value can be anything like:

• a number
• a truth value
• an enum
• a string
• an array of the above values

Example format:

{

"key1" : "value1",

"key2" : "value2",

"key3" : "value3",

...

.

.

"key n" : "value n"

}

Here the JSON document is enclosed in curly braces { ........ }.

Each pair of (key-value) is separated by a comma operator as shown.

We can have an array of data values enclosed in the square brackets:

Example:

{

"name": "Raj",

"class": 10,

"marks": [ 89, 78, 99, 100, 40 ],

"grade": "A"

}

Here, the underlined key-value pair has a key-marks and it is having an array of 5 marks.!!

Hence, a JSON Document can have an array of data values ..!!