单项选择题 IntheinstanceofthePRODdatabase,thecheckpoint(CKPT)processrunsaftereveryminute.AdatabaseuserupdatestherowsoftheORDERStable.Becauseoftheconfiguration,theCKPTprocessgetsinitiatedbeforetheusercommitsthetransaction.WhatwouldhappentothemodifiedblockswhentheCKPTprocessisstarted?()
单项选择题 UsersinyourPRODdatabasecomplainabouttheslowresponseofthetransactions.Whileinvestigatingthereason,youfindthatthetransactionsarewaitingfortheundosegmentstobeavailable,andundoretentionhasbeensettozero.Whatwouldyoudotoovercomethisproblem?()
单项选择题 Thecustomerandordertablesareoftenusedinjoins,therebyresultingincomplexqueries.Youcreatedviewstosimplifythewritingofqueries.Theseviewsarestoredin().