niusouti.com

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

题目
Youissuedthefollowingstatement:SQL>ALTERSESSIONSETNLS_LANG=FRENCH_CANADA.WE8ISO8859P1;WhichparameterisNOToverriddenbyusingtheabovestatement?()

A.thevalueoftheNLS_LANGUAGEvariable

B.thevalueoftheNLS_TERRITORYvariable

C.thevalueoftheNLS_CURRENCYvariable

D.thecharacterencodingschemeusedbytheclientapplication

相似考题

1.Youissuedthefollowingstatement:SQL>ALTERDATABASEENABLERESUMABLETIMEOUTn;Whatwillbetheresultofissuingtheabovestatement?()A.ThecommandwillnotexecutesuccessfullybecauseTIMEOUTisaninvalidclausewiththeALTERDATABASEENABLERESUMABLEcommand.B.Thecommandwillnotexecutesuccessfullybecauseresumablespaceallocationisenabledatthesessionlevel.C.Thecommandwillexecutesuccessfullyandresumablespacewillbeallocatedatthesessionlevel.D.Thecommandwillexecutesuccessfullyandresumablespacewillbeallocatedattheinstancelevel.

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.

相关内容