A.Theextentsinundotablespaceretaindatauntilthenextfulldatabasebackup.
B.Theextentscontainingcommitteddataintheundotablespaceareneveroverwritten.
C.Theextentswhichnolongercontainuncommitteddataintheundotablespacearenotoverwrittenforatleast15minutes.
D.Theextentscontainingcommitteddataintheundotablespacearenotoverwrittenuntiltheinstanceisshutdown.
第1题
A.ItignoresNULLvalues
B.Reversingtheorderoftheintersectedtablesalterstheresult
C.ThenamesofcolumnsinallSELECTstatementsmustbeidentical
D.ThenumberofcolumnsanddatatypesmustbeidenticalforallSELECTstatementsinthequery
第2题
A.More memory per thread is beneficial in all scenarios
B.It causes increased overhead due to initial memory allocation
C.It can affect system stability during peak load times, due to swapping
D.It requires increasing the thread_cache_size variable
第3题
A.TheLOBvaluesareautomaticallycompressed.
B.TheLOBvaluesarecachedbydefaultinthebuffercache.
C.TheLOBvaluesareautomaticallystoredinencryptedmode.
D.AllLOBdatathatisidenticalintwoormorerowsinaLOBcolumnsharethesamedatablocks.
第4题
A.NoflashbackispossibletobringbacktheITEMtable.
B.TheORDERtableisdroppedalongwiththeITEMtable.
C.ThedependentreferentialintegrityconstraintsintheORDERtablearedisabled.
D.ThedependentreferentialintegrityconstraintsintheORDERtableareremoved.
E.ThetabledefinitionoftheITEMtableandassociatedindexesareplacedintherecyclebin.
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!