Youissuedthefollowingstatement:SQLALTERSESSIONSETNLS_LANG=FRENCH_CANADA.WE8ISO8859P1;WhichparameterisNOToverriddenbyusingtheabovestatement?() A.thevalueoftheNLS_LANGUAGEvariableB.thevalueoftheNLS_TERRITORYvariableC.thevalueoftheNLS_CURRENCYvariableD.thecharacterencodingschemeusedbytheclientapplication
Youissuedthefollowingstatement:SQL>ALTERSESSIONSETNLS_LANG=FRENCH_CANADA.WE8ISO8859P1;WhichparameterisNOToverriddenbyusingtheabovestatement?()
A.thevalueoftheNLS_LANGUAGEvariable
B.thevalueoftheNLS_TERRITORYvariable
C.thevalueoftheNLS_CURRENCYvariable
D.thecharacterencodingschemeusedbytheclientapplication
相关考题:
Youissuedthefollowingstatement:SQLALTERDATABASEENABLERESUMABLETIMEOUTn;Whatwillbetheresultofissuingtheabovestatement?() A.ThecommandwillnotexecutesuccessfullybecauseTIMEOUTisaninvalidclausewiththeALTERDATABASEENABLERESUMABLEcommand.B.Thecommandwillnotexecutesuccessfullybecauseresumablespaceallocationisenabledatthesessionlevel.C.Thecommandwillexecutesuccessfullyandresumablespacewillbeallocatedatthesessionlevel.D.Thecommandwillexecutesuccessfullyandresumablespacewillbeallocatedattheinstancelevel.
YourOracle10gdatabasecontainsatablewithaTIMESTAMPTOLOCALTIMEZONEcolumn.Thereareabouttwohundredcolumnvaluesforthecolumn.Youissuedthefollowingstatement:SQLALTERDATABASESETTIME_ZONE=’Europe/London’;Whatwillbetheresultofissuingtheabovestatement?()A.Thestatementwillbeexecutedsuccessfully,andanewtimezonewillbesetforthedatabase.B.Thestatementwillbeexecutedsuccessfully,butanewtimezonewillnotbesetforthedatabase.C.ThestatementwillnotbeexecutedsuccessfullybecausetheSETTIME_ZONEclausecanbeusedonlywiththeALTERSESSIONstatement.D.ThestatementwillnotbeexecutedsuccessfullybecausetheALTERDATABASESETTIME_ZONEstatementisusedonlywhenthedatabasecontainsnotablewiththeTIMESTAMPTOLOCALTIMEZONEcolumn.
Youissuedthefollowingstatement:SQL>ALTERDATABASEBACKUPCONTROLFILETOTRACE;Whatwillbetheresultofissuingthestatement?() A.Thecontrolfilewillbemultiplexed.B.Thecontrolfilewillberecreated.C.ThescriptcontainingtheCREATECONTROLFILEstatementwillbecreated.D.Thebinarybackupofthecontrolfilewillbecreated.
Youhaveperformedanincompleterecoverybecausesomeimportantuser’sschemaisdroppedandpurgedfromtheRecycleBin.Thecurrentlogsaresequenced1005and1006.Afterperformingtherecovery,youissuedthefollowingstatement:SQLALTERDATABASEOPENRESETLOGS;Whatwillbetheresultantlogsequencenumbers?()A.0and1B.1and2C.1005and1006D.1006and1007