Youissuedthefollowingstatement:SQL>ALTERDATABASEENABLERESUMABLETIMEOUTn;Whatwillbetheresultofissuingtheabovestatement?()A.ThecommandwillnotexecutesuccessfullybecauseTIMEOUTisaninvalidclausewiththeALTERDATABASEENABLERESUMABLEcommand.B.Thecommandwillnotexec

题目
Youissuedthefollowingstatement:SQL>ALTERDATABASEENABLERESUMABLETIMEOUTn;Whatwillbetheresultofissuingtheabovestatement?()

A.ThecommandwillnotexecutesuccessfullybecauseTIMEOUTisaninvalidclausewiththeALTERDATABASEENABLERESUMABLEcommand.

B.Thecommandwillnotexecutesuccessfullybecauseresumablespaceallocationisenabledatthesessionlevel.

C.Thecommandwillexecutesuccessfullyandresumablespacewillbeallocatedatthesessionlevel.

D.Thecommandwillexecutesuccessfullyandresumablespacewillbeallocatedattheinstancelevel.

相似考题

1.Youissuedthefollowingstatement:SQL>ALTERSESSIONSETNLS_LANG=FRENCH_CANADA.WE8ISO8859P1;WhichparameterisNOToverriddenbyusingtheabovestatement?()A.thevalueoftheNLS_LANGUAGEvariableB.thevalueoftheNLS_TERRITORYvariableC.thevalueoftheNLS_CURRENCYvariableD.thecharacterencodingschemeusedbytheclientapplication

2.Youissuedthefollowingstatement:SQL>ALTERDATABASEBACKUPCONTROLFILETOTRACE;Whatwillbetheresultofissuingthestatement?()A.Thecontrolfilewillbemultiplexed.B.Thecontrolfilewillberecreated.C.ThescriptcontainingtheCREATECONTROLFILEstatementwillbecreated.D.Thebinarybackupofthecontrolfilewillbecreated.

3.Youhaveperformedanincompleterecoverybecausesomeimportantuser’sschemaisdroppedandpurgedfromtheRecycleBin.Thecurrentlogsaresequenced1005and1006.Afterperformingtherecovery，youissuedthefollowingstatement：SQL>ALTERDATABASEOPENRESETLOGS；Whatwillbetheresultantlogsequencenumbers？（）A.0and1B.1and2C.1005and1006D.1006and1007

4.YourOracle10gdatabasecontainsatablewithaTIMESTAMPTOLOCALTIMEZONEcolumn.Thereareabouttwohundredcolumnvaluesforthecolumn.Youissuedthefollowingstatement：SQL>ALTERDATABASESETTIME_ZONE=’Europe/London’；Whatwillbetheresultofissuingtheabovestatement？（）A.Thestatementwillbeexecutedsuccessfully，andanewtimezonewillbesetforthedatabase.B.Thestatementwillbeexecutedsuccessfully，butanewtimezonewillnotbesetforthedatabase.C.ThestatementwillnotbeexecutedsuccessfullybecausetheSETTIME_ZONEclausecanbeusedonlywiththeALTERSESSIONstatement.D.ThestatementwillnotbeexecutedsuccessfullybecausetheALTERDATABASESETTIME_ZONEstatementisusedonlywhenthedatabasecontainsnotablewiththeTIMESTAMPTOLOCALTIMEZONEcolumn.

参考答案和解析
参考答案：B
相关内容