MS SQL Server - 95 - JSON MCQ

95 – JSON MCQ

1 / 25

1. What does JSON stand for in the context of MS SQL Server?

A. JavaScript Online Notation

C. JavaScript Object Naming

B. JavaScript Object Notation

D. JavaScript Object Normalization

2 / 25

2. In SQL Server, which data type is used to store JSON data?

B. NVARCHAR

C. JSON

D. XML

A. VARCHAR

3 / 25

3. Which function is used to parse a JSON string and return a JSON object in SQL Server?

A. JSON_VALUE

C. JSON_MODIFY

B. JSON_QUERY

D. JSON_PARSE

4 / 25

4. What is the purpose of the JSON_VALUE function in SQL Server?

B. To modify a JSON object

D. To validate JSON syntax

A. To extract a scalar value from a JSON object

C. To query JSON data

5 / 25

5. Which SQL Server function is used to query nested JSON objects?

B. JSON_QUERY

D. JSON_PARSE

A. JSON_VALUE

C. JSON_MODIFY

6 / 25

6. In SQL Server, what is the JSON_MODIFY function used for?

D. To validate JSON syntax

C. To create a new JSON object

B. To modify a value in a JSON object

A. To extract a value from a JSON object

7 / 25

7. Which SQL Server function allows you to check if a JSON string is valid?

B. JSON_QUERY

D. ISJSON

C. JSON_MODIFY

A. JSON_VALUE

8 / 25

8. What is the purpose of the FOR JSON clause in SQL Server?

D. To format query results as JSON

B. To filter JSON objects

A. To query JSON data

C. To validate JSON syntax

9 / 25

9. Which of the following is true about the JSON data type in SQL Server?

D. JSON data type is not supported in SQL Server.

A. JSON data is always stored in a binary format.

B. JSON data can be indexed for faster retrieval.

C. JSON data can only be stored as plain text.

10 / 25

10. In SQL Server, how can you extract a value from a specific property within a JSON object?

C. Using the JSON_PARSE function with a property name

B. Using the JSON_MODIFY function with a property name

D. Using the ISJSON function with a property name

A. Using the JSON_VALUE function with a JSON path expression

11 / 25

11. What is a JSON path expression in SQL Server?

A. A regular expression used to validate JSON data

C. A binary format for storing JSON data

B. A query language for querying JSON data

D. A method for creating nested JSON objects

12 / 25

12. In SQL Server, which function is used to add a new property to a JSON object?

B. JSON_QUERY

A. JSON_VALUE

C. JSON_MODIFY

D. JSON_PARSE

13 / 25

13. How can you format the result of a query as JSON in SQL Server?

B. Using the TO_JSON function

C. Using the JSON_FORMAT option

A. Using the FOR JSON clause

D. Using the JSON_STRINGIFY function

14 / 25

14. What does the ISJSON function return in SQL Server if the input is valid JSON?

D. FALSE

C. TRUE

A. 1

B. 0

15 / 25

15. In SQL Server, how can you remove a property from a JSON object?

C. Using the JSON_MODIFY function with a null value

A. Using the JSON_VALUE function

D. Using the ISJSON function

B. Using the JSON_QUERY function

16 / 25

16. What is the maximum depth allowed for nested JSON objects in SQL Server?

B. 100 levels

D. There is no maximum depth limit.

A. 50 levels

C. 255 levels

17 / 25

17. In SQL Server, how can you escape special characters within a JSON string?

D. Special characters cannot be escaped in JSON strings.

C. Use a backslash () before the special characters.

A. Use double quotes around the JSON string.

B. Use single quotes around the JSON string.

18 / 25

18. What is the result of JSON_QUERY when the specified JSON path does not exist in the JSON data?

A. It returns NULL.

B. It returns an empty string.

D. It returns the entire JSON object.

C. It raises an error.

19 / 25

19. In SQL Server, which function is used to convert a SQL result set into JSON format?

A. JSON_VALUE

D. FOR JSON AUTO

B. JSON_QUERY

C. JSON_MODIFY

20 / 25

20. What is the primary use case for the OPENJSON function in SQL Server?

C. To create a new JSON object

D. To format JSON data for display

A. To validate JSON data

B. To extract data from a JSON array

21 / 25

21. In SQL Server, what is the purpose of the WITHOUT_ARRAY_WRAPPER option in the FOR JSON clause?

C. It validates JSON arrays.

B. It adds square brackets to JSON arrays.

A. It removes square brackets from JSON arrays.

D. It converts JSON arrays to strings.

22 / 25

22. In SQL Server, which function allows you to shred (parse) JSON data into relational format?

C. JSON_MODIFY

A. JSON_VALUE

D. OPENJSON

B. JSON_QUERY

23 / 25

23. What is the primary advantage of using JSON as a data format in SQL Server?

A. Compatibility with other relational database systems

D. Flexibility in handling unstructured data

B. Reduced storage space requirements

C. Improved query performance

24 / 25

24. Which of the following is a valid JSON path expression in SQL Server?

B. /property1/property2

C. property1.property2

A. $.property1.property2

D. property1[0]

25 / 25

25. In SQL Server, what is the main difference between JSON_QUERY and JSON_VALUE?

D. JSON_VALUE is used for creating JSON data, while JSON_QUERY is used for parsing JSON data.

A. JSON_QUERY returns a JSON object, while JSON_VALUE returns a scalar value.

C. JSON_QUERY is used for modifying JSON data, while JSON_VALUE is used for querying.

B. JSON_VALUE returns a JSON object, while JSON_QUERY returns a scalar value.

Your score is

MS SQL Server – 95 – JSON MCQ