{"interactiveVideo":{"video":{"startScreenOptions":{"title":"Interactive Video","hideStartTitle":false},"textTracks":{"videoTrack":[{"label":"Subtitles","kind":"subtitles","srcLang":"en"}]},"files":[{"path":"videos\/files-5f1f1c220bea2.mp4","mime":"video\/mp4","copyright":{"license":"U"},"metadata":{"qualityName":"720p"}}]},"assets":{"interactions":[{"x":37.11790393013101,"y":9.70402717127608,"width":24.45414847161572,"height":18.16593886462882,"duration":{"from":266.028,"to":268.029},"libraryTitle":"Fill in the Blanks","action":{"library":"H5P.Blanks 1.14","params":{"media":{"disableImageZooming":false},"text":"

Transactions in relational databases such as SQL Server 2019 uphold properties defined by the acronym ACID. What does ACID stand for?<\/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":["

A: *Atomicity\/Atomic*<\/p>\n\n

C: *Consistency\/Consistent*<\/p>\n\n

I: *Isolation\/Isolated*<\/p>\n\n

D: *Durability\/Durable*<\/p>\n"]},"subContentId":"3ea5e54b-b906-49de-abff-9191711977e3","metadata":{"contentType":"Fill in the Blanks","license":"U","title":"ACID Fill in the Blanks"}},"pause":true,"displayType":"poster","buttonOnMobile":false,"adaptivity":{"correct":{"allowOptOut":false,"message":""},"wrong":{"allowOptOut":false,"message":""},"requireCompletion":false},"label":""},{"x":28.38427947598253,"y":38.81610868510432,"width":17.77292576419214,"height":11.60002729257642,"duration":{"from":357.447,"to":359.447},"libraryTitle":"True\/False Question","action":{"library":"H5P.TrueFalse 1.8","params":{"media":{"disableImageZooming":false},"correct":"true","behaviour":{"enableRetry":true,"enableSolutionsButton":true,"enableCheckButton":true,"confirmCheckDialog":false,"confirmRetryDialog":false,"autoCheck":false},"l10n":{"trueText":"True","falseText":"False","score":"You got @score of @total points","checkAnswer":"Check","showSolutionButton":"Show solution","tryAgain":"Retry","wrongAnswerMessage":"Wrong answer","correctAnswerMessage":"Correct answer","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"},"question":"

A dirty read occurs when a statement selects data that isn't committed yet by another transaction.<\/p>\n"},"subContentId":"41c63238-2e53-428e-80e1-f71cbed24030","metadata":{"contentType":"True\/False Question","license":"U","title":"Dirty Read True\/False Question"}},"pause":true,"displayType":"poster","buttonOnMobile":false,"adaptivity":{"correct":{"allowOptOut":false,"message":""},"wrong":{"allowOptOut":false,"message":""},"requireCompletion":false},"label":""},{"x":49.12663755458515,"y":79.45736434108527,"width":10,"height":10,"duration":{"from":418.906,"to":428.906},"libraryTitle":"Link","action":{"library":"H5P.Link 1.3","params":{"linkWidget":{"protocol":"https:\/\/","url":"docs.microsoft.com\/en-us\/sql\/relational-databases\/logs\/the-transaction-log-sql-server?view=sql-server-ver15"},"title":"The Transaction Log in SQL Server 2019"},"subContentId":"a6e4b0c9-83c9-44aa-b7fa-bf5773c5b574","metadata":{"contentType":"Link","license":"U"}},"displayType":"poster","visuals":{"backgroundColor":"rgba(0,0,0,0.5)","boxShadow":true},"pause":false,"buttonOnMobile":false},{"x":2.1834061135371177,"y":32.99369238233867,"width":39.12663755458516,"height":15.109170305676857,"duration":{"from":472.149,"to":474.149},"libraryTitle":"Drag Text","action":{"library":"H5P.DragText 1.10","params":{"taskDescription":"

Using the local variable, how do we update the Inventory table to reduce the quantity left for the product named \"Apple\"?<\/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 Inventory\n *SET* quantity_left = *quantity_left* - *@numPurchased*\n *WHERE* *name* = *'Apple'*;"},"subContentId":"edde7f42-c255-4588-9551-408ad63ffd4f","metadata":{"contentType":"Drag Text","license":"U","title":"UPDATE with Variables Drag Text"}},"pause":true,"displayType":"poster","buttonOnMobile":false,"adaptivity":{"correct":{"allowOptOut":false,"message":""},"wrong":{"allowOptOut":false,"message":""},"requireCompletion":false},"label":""},{"x":55.6768558951965,"y":34.93449781659389,"width":16.899563318777293,"height":13.741129912663757,"duration":{"from":569.049,"to":571.049},"libraryTitle":"Fill in the Blanks","action":{"library":"H5P.Blanks 1.14","params":{"media":{"disableImageZooming":false},"text":"

Instead of \"COMMIT\", what statement will never commit the changes to disk made by statements since \"BEGIN TRANSACTION\", regardless of whether an error occurred or not?<\/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":false},"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":["

*ROLLBACK*<\/p>\n"]},"subContentId":"6f39b951-c322-47f3-8e67-064d8ff794f7","metadata":{"contentType":"Fill in the Blanks","license":"U","title":"Rollback Fill in the Blanks"}},"pause":true,"displayType":"poster","buttonOnMobile":false,"adaptivity":{"correct":{"allowOptOut":false,"message":""},"wrong":{"allowOptOut":false,"message":""},"requireCompletion":false},"label":""},{"x":0,"y":46.57933042212518,"width":14.41048034934498,"height":11.204284934497817,"duration":{"from":593.639,"to":603.639},"libraryTitle":"Text","action":{"library":"H5P.Text 1.1","params":{"text":"

Choose either COMMIT or ROLLBACK to end your transaction block.<\/p>\n\n

We will write a conditional IF-ELSE statement soon to decide which of these statements to execute.<\/p>\n"},"subContentId":"ad0a04a6-2f09-4f30-91e0-e3375c2a40e7","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"pause":false,"displayType":"poster","buttonOnMobile":false,"visuals":{"backgroundColor":"rgb(255, 255, 255)","boxShadow":true},"goto":{"url":{"protocol":"http:\/\/"},"visualize":false,"type":""},"label":""},{"x":0,"y":60.07751937984496,"width":15.589519650655022,"height":8.979939956331878,"duration":{"from":694.389,"to":696.389},"libraryTitle":"Text","action":{"library":"H5P.Text 1.1","params":{"text":"

Write down the boolean expression that checks whether either the product or customer doesn't exist, or whether either the quantity left or customer's store credit balance is negative.<\/p>\n"},"subContentId":"69637461-1aff-458e-aca5-639c4083f4b3","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"pause":true,"displayType":"poster","buttonOnMobile":false,"visuals":{"backgroundColor":"rgb(255, 255, 255)","boxShadow":true},"goto":{"url":{"protocol":"http:\/\/"},"visualize":false,"type":""},"label":""}],"endscreens":[{"time":758.442667,"label":"12:38 Submit screen"}]},"summary":{"task":{"library":"H5P.Summary 1.10","params":{"intro":"Choose the correct statement.","summaries":[{"subContentId":"a78b76f8-3a0f-4eca-a149-436496891075","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":"1c835d6c-667d-4e70-9e1c-174dd00ab128","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."}}

Transactions

Chris Lo