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