{"interactiveVideo":{"video":{"startScreenOptions":{"title":"Interactive Video","hideStartTitle":false},"textTracks":{"videoTrack":[{"label":"Subtitles","kind":"subtitles","srcLang":"en"}]},"files":[{"path":"videos\/files-5eea659ccb7dd.mp4","mime":"video\/mp4","copyright":{"license":"CC BY","version":"4.0"},"metadata":{"qualityName":"720p"}}]},"assets":{"interactions":[{"x":13.100436681222707,"y":36.8753032508491,"width":23.886462882096072,"height":12.036708515283843,"duration":{"from":199.274,"to":201.274},"libraryTitle":"Fill in the Blanks","action":{"library":"H5P.Blanks 1.14","params":{"media":{"disableImageZooming":false},"text":"

How can we delete only Log records entered by userId 'ktrang'?<\/p>\n","overallFeedback":[{"from":0,"to":100}],"showSolutions":"Show solution","tryAgain":"Retry","checkAnswer":"Check","notFilledOut":"Please fill in all blanks to view solution","answerIsCorrect":"':ans' is correct","answerIsWrong":"':ans' is wrong","answeredCorrectly":"Answered correctly","answeredIncorrectly":"Answered incorrectly","solutionLabel":"Correct answer:","inputLabel":"Blank input @num of @total","inputHasTipLabel":"Tip available","tipLabel":"Tip","behaviour":{"enableRetry":true,"enableSolutionsButton":true,"enableCheckButton":true,"autoCheck":false,"caseSensitive":true,"showSolutionsRequiresInput":true,"separateLines":false,"confirmCheckDialog":false,"confirmRetryDialog":false,"acceptSpellingErrors":true},"scoreBarLabel":"You got :num out of :total points","confirmCheck":{"header":"Finish ?","body":"Are you sure you wish to finish ?","cancelLabel":"Cancel","confirmLabel":"Finish"},"confirmRetry":{"header":"Retry ?","body":"Are you sure you wish to retry ?","cancelLabel":"Cancel","confirmLabel":"Confirm"},"questions":["

DELETE FROM Log
\n WHERE *userID = 'ktrang'*;
\n <\/p>\n"]},"subContentId":"3416e4fd-2086-4571-af81-fb3f59cb5321","metadata":{"contentType":"Fill in the Blanks","license":"U","title":"DELETE's WHERE clause Fill in the Blanks"}},"pause":true,"displayType":"poster","buttonOnMobile":false,"adaptivity":{"correct":{"allowOptOut":false,"message":""},"wrong":{"allowOptOut":false,"message":""},"requireCompletion":false},"label":""},{"x":62.22707423580786,"y":73.64341085271317,"width":10,"height":10,"duration":{"from":298.846,"to":308.846},"libraryTitle":"Link","action":{"library":"H5P.Link 1.3","params":{"linkWidget":{"protocol":"https:\/\/","url":"docs.microsoft.com\/EN-US\/SQL\/T-SQL\/STATEMENTS\/DELETE-TRANSACT-SQL?VIEW=SQL-SERVER-VER15"},"title":"DELETE T-SQL documentation"},"subContentId":"f89bd58a-1264-46e8-a686-c91633171728","metadata":{"contentType":"Link","license":"U"}},"displayType":"poster","visuals":{"backgroundColor":"rgba(0,0,0,0.5)","boxShadow":true},"pause":false,"buttonOnMobile":false},{"x":9.825327510917031,"y":36.82170542635659,"width":28.340611353711793,"height":13.870769650655022,"duration":{"from":333.584,"to":335.584},"libraryTitle":"Drag Text","action":{"library":"H5P.DragText 1.10","params":{"taskDescription":"

How would you update all rows in the Log table and change the hostName to 'localhost'?<\/p>\n","overallFeedback":[{"from":0,"to":100}],"checkAnswer":"Check","tryAgain":"Retry","showSolution":"Show solution","dropZoneIndex":"Drop Zone @index.","empty":"Drop Zone @index is empty.","contains":"Drop Zone @index contains draggable @draggable.","ariaDraggableIndex":"@index of @count draggables.","tipLabel":"Show tip","correctText":"Correct!","incorrectText":"Incorrect!","resetDropTitle":"Reset drop","resetDropDescription":"Are you sure you want to reset this drop zone?","grabbed":"Draggable is grabbed.","cancelledDragging":"Cancelled dragging.","correctAnswer":"Correct answer:","feedbackHeader":"Feedback","behaviour":{"enableRetry":true,"enableSolutionsButton":true,"enableCheckButton":true,"instantFeedback":false},"scoreBarLabel":"You got :num out of :total points","textField":"*UPDATE* *Log*\n\t*SET* *hostName* *=* *'localhost'*;"},"subContentId":"05b79bb7-fba1-47a9-a7aa-4b162a89d0dc","metadata":{"contentType":"Drag Text","license":"U","title":"UPDATE all records Drag Text"}},"pause":true,"displayType":"poster","buttonOnMobile":false,"adaptivity":{"correct":{"allowOptOut":false,"message":""},"wrong":{"allowOptOut":false,"message":""},"requireCompletion":false},"label":""},{"x":3.2751091703056767,"y":40.756914119359536,"width":34.93449781659389,"height":12.663755458515285,"duration":{"from":355.329,"to":357.329},"libraryTitle":"Fill in the Blanks","action":{"library":"H5P.Blanks 1.14","params":{"media":{"disableImageZooming":false},"text":"

We want to update the hostName of only those Log records whose userId is 'ktrang':<\/p>\n","overallFeedback":[{"from":0,"to":100}],"showSolutions":"Show solution","tryAgain":"Retry","checkAnswer":"Check","notFilledOut":"Please fill in all blanks to view solution","answerIsCorrect":"':ans' is correct","answerIsWrong":"':ans' is wrong","answeredCorrectly":"Answered correctly","answeredIncorrectly":"Answered incorrectly","solutionLabel":"Correct answer:","inputLabel":"Blank input @num of @total","inputHasTipLabel":"Tip available","tipLabel":"Tip","behaviour":{"enableRetry":true,"enableSolutionsButton":true,"enableCheckButton":true,"autoCheck":false,"caseSensitive":false,"showSolutionsRequiresInput":true,"separateLines":false,"confirmCheckDialog":false,"confirmRetryDialog":false,"acceptSpellingErrors":true},"scoreBarLabel":"You got :num out of :total points","confirmCheck":{"header":"Finish ?","body":"Are you sure you wish to finish ?","cancelLabel":"Cancel","confirmLabel":"Finish"},"confirmRetry":{"header":"Retry ?","body":"Are you sure you wish to retry ?","cancelLabel":"Cancel","confirmLabel":"Confirm"},"questions":["

UPDATE Log
\n SET hostName = 'localhost'
\n *WHERE userId = 'ktrang'*;
\n <\/p>\n"]},"subContentId":"4546713c-932b-499f-9c97-7b355d420437","metadata":{"contentType":"Fill in the Blanks","license":"U","title":"UPDATE with WHERE Fill in the Blanks"}},"pause":true,"displayType":"poster","buttonOnMobile":false,"adaptivity":{"correct":{"allowOptOut":false,"message":""},"wrong":{"allowOptOut":false,"message":""},"requireCompletion":false},"label":""},{"x":60.043668122270745,"y":75.5813953488372,"width":10,"height":10,"duration":{"from":443.818,"to":453.818},"libraryTitle":"Link","action":{"library":"H5P.Link 1.3","params":{"linkWidget":{"protocol":"https:\/\/","url":"DOCS.MICROSOFT.COM\/EN-US\/SQL\/T-SQL\/QUERIES\/UPDATE-TRANSACT-SQL?VIEW=SQL-SERVER-VER15"},"title":"UPDATE T-SQL documentation"},"subContentId":"d7053ddb-c0fc-4bce-95dd-a3ea7ebe491b","metadata":{"contentType":"Link","license":"U"}},"displayType":"poster","visuals":{"backgroundColor":"rgba(0,0,0,0.5)","boxShadow":true},"pause":false,"buttonOnMobile":false},{"x":29.47598253275109,"y":3.881610868510432,"width":28.209606986899566,"height":21.65938864628821,"duration":{"from":615.86,"to":617.86},"libraryTitle":"Drag Text","action":{"library":"H5P.DragText 1.10","params":{"taskDescription":"

Can you guess how we would explicitly define which columns (only those that are mandatory \u2014 not null, not auto-incrementing identity, and having no default values) of the target table we are inserting our value tuples into?<\/p>\n","overallFeedback":[{"from":0,"to":100}],"checkAnswer":"Check","tryAgain":"Retry","showSolution":"Show solution","dropZoneIndex":"Drop Zone @index.","empty":"Drop Zone @index is empty.","contains":"Drop Zone @index contains draggable @draggable.","ariaDraggableIndex":"@index of @count draggables.","tipLabel":"Show tip","correctText":"Correct!","incorrectText":"Incorrect!","resetDropTitle":"Reset drop","resetDropDescription":"Are you sure you want to reset this drop zone?","grabbed":"Draggable is grabbed.","cancelledDragging":"Cancelled dragging.","correctAnswer":"Correct answer:","feedbackHeader":"Feedback","behaviour":{"enableRetry":true,"enableSolutionsButton":true,"enableCheckButton":true,"instantFeedback":false},"scoreBarLabel":"You got :num out of :total points","textField":"INSERT INTO Log(*date*, *time*, *hostName*, *logCategoryCode*)\n\tVALUES ('2020.06.16', '12:00 p.m.', 'CHRIS-X', 'I'),\n\t\t('2020.06.16', '12:01 p.m.', 'CHRIS-X', 'I');"},"subContentId":"b717de64-2886-480b-a9c2-077752fba1ab","metadata":{"contentType":"Drag Text","license":"U","title":"Explicit columns INSERT syntax Drag Text"}},"pause":true,"displayType":"poster","buttonOnMobile":false,"adaptivity":{"correct":{"allowOptOut":false,"message":""},"wrong":{"allowOptOut":false,"message":""},"requireCompletion":false},"label":""},{"x":36.02620087336245,"y":38.81610868510432,"width":25.589519650655024,"height":13.799126637554586,"duration":{"from":690.216,"to":692.216},"libraryTitle":"Fill in the Blanks","action":{"library":"H5P.Blanks 1.14","params":{"media":{"disableImageZooming":false},"text":"

How can we duplicate the top two Log records, inserting those rows back into the Log table?<\/p>\n","overallFeedback":[{"from":0,"to":100}],"showSolutions":"Show solution","tryAgain":"Retry","checkAnswer":"Check","notFilledOut":"Please fill in all blanks to view solution","answerIsCorrect":"':ans' is correct","answerIsWrong":"':ans' is wrong","answeredCorrectly":"Answered correctly","answeredIncorrectly":"Answered incorrectly","solutionLabel":"Correct answer:","inputLabel":"Blank input @num of @total","inputHasTipLabel":"Tip available","tipLabel":"Tip","behaviour":{"enableRetry":true,"enableSolutionsButton":true,"enableCheckButton":true,"autoCheck":false,"caseSensitive":false,"showSolutionsRequiresInput":true,"separateLines":false,"confirmCheckDialog":false,"confirmRetryDialog":false,"acceptSpellingErrors":true},"scoreBarLabel":"You got :num out of :total points","confirmCheck":{"header":"Finish ?","body":"Are you sure you wish to finish ?","cancelLabel":"Cancel","confirmLabel":"Finish"},"confirmRetry":{"header":"Retry ?","body":"Are you sure you wish to retry ?","cancelLabel":"Cancel","confirmLabel":"Confirm"},"questions":["

INSERT INTO Log
\n SELECT *TOP (2)* date, time, hostName, userId, logCategoryCode, source, message
\n FROM Log;
\n <\/p>\n"]},"subContentId":"ca767c34-d4fb-4377-81b3-a6672e485f6a","metadata":{"contentType":"Fill in the Blanks","license":"U","title":"TOP keyword Fill in the Blanks"}},"pause":true,"displayType":"poster","buttonOnMobile":false,"adaptivity":{"correct":{"allowOptOut":false,"message":""},"wrong":{"allowOptOut":false,"message":""},"requireCompletion":false},"label":""}]},"summary":{"task":{"library":"H5P.Summary 1.10","params":{"intro":"Choose the correct statement.","summaries":[{"subContentId":"699923ee-183c-4a39-b620-af6b66defa94","tip":""}],"overallFeedback":[{"from":0,"to":100}],"solvedLabel":"Progress:","scoreLabel":"Wrong answers:","resultLabel":"Your result","labelCorrect":"Correct.","labelIncorrect":"Incorrect! Please try again.","alternativeIncorrectLabel":"Incorrect","labelCorrectAnswers":"Correct answers.","tipButtonLabel":"Show tip","scoreBarLabel":"You got :num out of :total points","progressText":"Progress :num of :total"},"subContentId":"ed7ba01c-e888-40f3-a9d9-584947609c6c","metadata":{"contentType":"Summary","license":"U","title":"Untitled Summary"}},"displayAt":3}},"override":{"autoplay":false,"loop":false,"showBookmarksmenuOnLoad":false,"showRewind10":false,"deactivateSound":false,"preventSkippingMode":"none"},"l10n":{"interaction":"Interaction","play":"Play","pause":"Pause","mute":"Mute","unmute":"Unmute","quality":"Video Quality","captions":"Captions","close":"Close","fullscreen":"Fullscreen","exitFullscreen":"Exit Fullscreen","summary":"Open summary dialog","bookmarks":"Bookmarks","endscreen":"Submit screen","defaultAdaptivitySeekLabel":"Continue","continueWithVideo":"Continue with video","playbackRate":"Playback Rate","rewind10":"Rewind 10 Seconds","navDisabled":"Navigation is disabled","sndDisabled":"Sound is disabled","requiresCompletionWarning":"You need to answer all the questions correctly before continuing.","back":"Back","hours":"Hours","minutes":"Minutes","seconds":"Seconds","currentTime":"Current time:","totalTime":"Total time:","singleInteractionAnnouncement":"Interaction appeared:","multipleInteractionsAnnouncement":"Multiple interactions appeared.","videoPausedAnnouncement":"Video is paused","content":"Content","answered":"@answered answered","endcardTitle":"@answered Question(s) answered","endcardInformation":"You have answered @answered questions, click below to submit your answers.","endcardInformationNoAnswers":"You have not answered any questions.","endcardInformationMustHaveAnswer":"You have to answer at least one question before you can submit your answers.","endcardSubmitButton":"Submit Answers","endcardSubmitMessage":"Your answers have been submitted!","endcardTableRowAnswered":"Answered questions","endcardTableRowScore":"Score","endcardAnsweredScore":"answered","endCardTableRowSummaryWithScore":"You got @score out of @total points for the @question that appeared after @minutes minutes and @seconds seconds.","endCardTableRowSummaryWithoutScore":"You have answered the @question that appeared after @minutes minutes and @seconds seconds."}}

DML: INSERT, UPDATE, DELETE

Chris Lo