Test Your Microsoft SQL Server JSON SELECT Knowledge with This Quiz

Progress

True / False

JSON functions can be used to parse and manipulate JSON data in SQL Server.

True False

SQL Server provides functions like JSON_VALUE and JSON_QUERY to parse and manipulate JSON data.

True / False

The JSON_MODIFY function in SQL Server allows modification of JSON data in a column.

True False

JSON_MODIFY can be used to update values within JSON text stored in a column.

True / False

You cannot extract JSON data as text using JSON functions in SQL Server.

True False

SQL Server allows extraction of JSON data as text using JSON functions like JSON_VALUE.

True / False

OPENJSON returns a set of rows with a column for each property in the JSON object.

True False

OPENJSON can transform JSON objects into a set of rows and columns.

True / False

JSON_QUERY function can return a JSON object or array from a JSON string.

True False

JSON_QUERY extracts a JSON object or array from a JSON string.

True / False

The JSON_VALUE function cannot be used to extract a scalar value from a JSON string.

True False

JSON_VALUE is used to extract a scalar value from a JSON string.

True / False

FOR JSON PATH clause converts SQL query results into a JSON text.

True False

The FOR JSON PATH clause formats SQL query results as JSON text.

True / False

The JSON data type is natively supported in SQL Server.

True False

SQL Server does not have a native JSON data type; it uses NVARCHAR.

True / False

You can use the FOR JSON AUTO clause to automatically format query results as JSON.

True False

The FOR JSON AUTO clause automatically formats query results as JSON.

Q10

True / False

The ISJSON function is used to validate if a string contains valid JSON.

True False

ISJSON checks whether a string contains valid JSON.

Q11

True / False

JSON data cannot be indexed in SQL Server.

True False

You can create indexes on JSON data in SQL Server using computed columns.

Q12

True / False

The JSON_OBJECT function creates a new JSON object in SQL Server.

True False

SQL Server does not have a JSON_OBJECT function; JSON objects are handled as NVARCHAR.

Q13

True / False

The JSON_ARRAY function is used to create an array from a set of rows.

True False

SQL Server does not have a JSON_ARRAY function; arrays are created using JSON functions and string concatenation.

Q14

True / False

You can use the CROSS APPLY operator with OPENJSON to join JSON data with relational data.

True False

CROSS APPLY can be used with OPENJSON to join JSON data with relational tables.

Q15

True / False

JSON_VALUE and JSON_QUERY are interchangeable functions in SQL Server.

True False

JSON_VALUE is used for scalar values, while JSON_QUERY is used for JSON objects and arrays.

Q16

Single Choice

Which function is used to extract a scalar value from a JSON string in SQL Server?

JSON_VALUE JSON_QUERY JSON_MODIFYOPENJSON

The JSON_VALUE function is used to extract scalar values from JSON strings.

Q17

Single Choice

Which clause converts SQL query results into JSON text in SQL Server?

FOR JSON AUTO FOR JSON PATH JSON_QUERYOPENJSON

The FOR JSON PATH clause converts SQL query results into JSON text.

Q18

Single Choice

Which function allows modification of JSON data within a JSON string in SQL Server?

JSON_VALUE JSON_QUERY JSON_MODIFYISJSON

The JSON_MODIFY function allows modification of JSON data within a JSON string.

Q19

Single Choice

What is the purpose of the ISJSON function in SQL Server?

To create JSON objects To validate JSON strings To extract JSON dataTo modify JSON data

The ISJSON function checks if a string contains valid JSON.

Q20

Single Choice

Which function is used to parse JSON text into a relational format in SQL Server?

JSON_VALUE JSON_QUERY JSON_MODIFYOPENJSON

The OPENJSON function parses JSON text into a relational format.

Q21

Single Choice

Which of the following clauses is used to format SQL query results as JSON text?

FOR JSON AUTO FOR JSON PATH JSON_QUERYOPENJSON

The FOR JSON AUTO clause formats SQL query results as JSON text.

Q22

Single Choice

Which function can be used to extract a JSON object or array from a JSON string?

JSON_VALUE JSON_QUERY JSON_MODIFYISJSON

The JSON_QUERY function extracts a JSON object or array from a JSON string.

Q23

Single Choice

What does the FOR JSON PATH clause do in SQL Server?

Creates JSON objects Validates JSON strings Formats query results as JSON textModifies JSON data

The FOR JSON PATH clause formats SQL query results as JSON text with a specified structure.

Q24

Single Choice

Which function can return a scalar value from a JSON string?

JSON_VALUE JSON_QUERY JSON_MODIFYOPENJSON

The JSON_VALUE function returns a scalar value from a JSON string.

Q25

Single Choice

What is the purpose of the JSON_QUERY function in SQL Server?

To create JSON objects To validate JSON strings To extract JSON objects or arraysTo modify JSON data

The JSON_QUERY function extracts JSON objects or arrays from a JSON string.

Q26

Single Choice

Which clause automatically formats SQL query results as JSON?

FOR JSON AUTO FOR JSON PATH JSON_QUERYOPENJSON

The FOR JSON AUTO clause automatically formats SQL query results as JSON.

Q27

Single Choice

What does the JSON_MODIFY function do in SQL Server?

Extracts JSON objects Validates JSON strings Modifies JSON dataParses JSON text

The JSON_MODIFY function allows modification of values within JSON text.

Q28

Single Choice

Which function checks if a string contains valid JSON in SQL Server?

JSON_VALUE JSON_QUERY JSON_MODIFYISJSON

The ISJSON function checks whether a string contains valid JSON.

Q29

Single Choice

Which function is used to parse JSON text into a relational format?

JSON_VALUE JSON_QUERY JSON_MODIFYOPENJSON

The OPENJSON function parses JSON text into a relational format.

Q30

Single Choice

Which clause in SQL Server converts query results into JSON text?

FOR JSON AUTO FOR JSON PATH JSON_QUERYOPENJSON

The FOR JSON PATH clause converts query results into JSON text.

Q31

Multiple Choice

Which functions can be used to parse and manipulate JSON data in SQL Server?

JSON_VALUE JSON_QUERY JSON_MODIFYISJSON

JSON_VALUE, JSON_QUERY, and JSON_MODIFY are used to parse and manipulate JSON data in SQL Server.

Q32

Multiple Choice

Which clauses are used to format query results as JSON text in SQL Server?

FOR JSON AUTO FOR JSON PATH JSON_QUERYOPENJSON

The FOR JSON AUTO and FOR JSON PATH clauses format query results as JSON text.

Q33

Multiple Choice

Which functions can be used to extract data from JSON strings in SQL Server?

JSON_VALUE JSON_QUERY JSON_MODIFYISJSON

JSON_VALUE and JSON_QUERY can be used to extract data from JSON strings.

Q34

Multiple Choice

Which functions can be used to modify JSON data in SQL Server?

JSON_VALUE JSON_QUERY JSON_MODIFYISJSON

JSON_MODIFY is used to modify JSON data, while JSON_VALUE and JSON_QUERY are used to extract data.

Q35

Multiple Choice

Which functions are specifically used for JSON data validation in SQL Server?

JSON_VALUE JSON_QUERY JSON_MODIFYISJSON

ISJSON is used for JSON data validation, while the other functions are for parsing and manipulation.

Q36

Multiple Choice

Which functions are used to handle JSON arrays in SQL Server?

JSON_VALUE JSON_QUERY JSON_MODIFYISJSON

JSON_QUERY can extract JSON arrays, while JSON_VALUE extracts scalar values.

Q37

Multiple Choice

Which functions are used to manipulate JSON data in SQL Server?

JSON_VALUE JSON_QUERY JSON_MODIFYISJSON

JSON_MODIFY is used for manipulation, while JSON_VALUE and JSON_QUERY are for extraction.

Q38

Multiple Choice

Which functions can be used to extract scalar values from JSON strings in SQL Server?

JSON_VALUE JSON_QUERY JSON_MODIFYISJSON

JSON_VALUE extracts scalar values, while JSON_QUERY extracts JSON objects or arrays.

Q39

Multiple Choice

Which functions can validate and extract JSON data in SQL Server?

JSON_VALUE JSON_QUERY JSON_MODIFYISJSON

ISJSON validates JSON data, while JSON_VALUE and JSON_QUERY extract data.

Q40

Multiple Choice

Which functions can be used to work with JSON data in SQL Server?

JSON_VALUE JSON_QUERY JSON_MODIFYISJSON

JSON_VALUE, JSON_QUERY, and JSON_MODIFY are used to work with JSON data in SQL Server.

Q41

Multiple Choice

Which functions can extract JSON objects or arrays from JSON strings in SQL Server?

JSON_VALUE JSON_QUERY JSON_MODIFYISJSON

JSON_QUERY extracts JSON objects or arrays, while JSON_VALUE extracts scalar values.

Q42

Multiple Choice

Which functions can be used to parse JSON data in SQL Server?

JSON_VALUE JSON_QUERY JSON_MODIFYOPENJSON

OPENJSON, JSON_VALUE, and JSON_QUERY can be used to parse JSON data in SQL Server.

Q43

Multiple Choice

Which functions can be used to validate and parse JSON data in SQL Server?

JSON_VALUE JSON_QUERY JSON_MODIFYISJSON

ISJSON validates JSON data, while OPENJSON, JSON_VALUE, and JSON_QUERY parse it.

Q44

Multiple Choice

Which functions can extract scalar values and JSON objects from JSON strings?

JSON_VALUE JSON_QUERY JSON_MODIFYISJSON

JSON_VALUE extracts scalar values, while JSON_QUERY extracts JSON objects.

Q45

Multiple Choice

Which functions can be used to modify and validate JSON data in SQL Server?

JSON_VALUE JSON_QUERY JSON_MODIFYISJSON

JSON_MODIFY is used to modify JSON data, while ISJSON validates it.

Microsoft SQL Server Database Quiz Questions