Let’s start the week with an exciting new quiz.
This quiz is related to the JSON support in SQL Server 2016.
As Microsoft says here: “JSON is a popular textual data format used for exchanging data in modern web and mobile applications. JSON is also used for storing unstructured data in log files or NoSQL databases like Microsoft Azure DocumentDB. Many REST web services return results formatted as JSON text or accept data formatted as JSON. Most Azure services such as Azure Search, Azure Storage, and Azure DocumentDb have REST endpoints that return or consume JSON. JSON is also the main format for exchanging data between web pages and web servers using AJAX calls.”
If this is quite new to you, read the entire MSDN article and then test your knowledge here.
Or, if you have a Pluralsight account, you can check out this course: https://app.pluralsight.com/library/courses/sql-server-2016-features-real-world-data/table-of-contents. There are some sections dedicated to the JSON support in SQL Server 2016.
Happy quizzing 🙂
0 of 10 questions completed
Are you able to resolve today’s SQL quiz?
This week’s test has a difficulty level of: MODERATE
Quiz subject: JSON Support in SQL Server 2016
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading...
You must sign in or sign up to start the quiz.
You have to finish following quiz, to start this quiz:
0 of 10 questions answered correctly
Time has elapsed
You have reached 0 of 0 points, (0)
Question 1 of 10
Fill in the blank with the appropriate value.
SQL Server 2016 comes with … JSON support.Correct
Question 2 of 10
Which data type will be used to store JSON values in SQL Server?Correct
Question 3 of 10
Which of the following is used to format query results as JSON text?Correct
Question 4 of 10
Which of the following is used to update the value of a property in a JSON string and return the updated JSON string?Correct
Question 5 of 10
Which of the following is used to import JSON data into SQL Server?Correct
Question 6 of 10
Which of the following is used to test whether a string contains valid JSON?Correct
Question 7 of 10
Which of the following is used to extract an object or an array from a JSON string?Correct
Question 8 of 10
Which of the following is used to extract a scalar value from a JSON string?Correct
Question 9 of 10
Replace the expresion […] in the SQL statement below with the function used to extract the value of a JSON property into a local variable:
SET @town = […](@jsonInfo, ‘$.info.address.town’)Correct
Question 10 of 10
Which of the following is not a valid JSON function in SQL Server 2016?Correct