niusouti.com

YourOracle10gdatabasecontainsatablewithaTIMESTAMPTOLOCALTIMEZONEcolumn.Thereareabouttwohundredcolumnvaluesforthecolumn.Youissuedthefollowingstatement:SQL>ALTERDATABASESETTIME_ZONE=’Europe/London’;Whatwillbetheresultofissuingtheabovestatement?()A.Thestatem

题目

YourOracle10gdatabasecontainsatablewithaTIMESTAMPTOLOCALTIMEZONEcolumn.Thereareabouttwohundredcolumnvaluesforthecolumn.Youissuedthefollowingstatement:SQL>ALTERDATABASESETTIME_ZONE=’Europe/London’;Whatwillbetheresultofissuingtheabovestatement?()

A.Thestatementwillbeexecutedsuccessfully,andanewtimezonewillbesetforthedatabase.

B.Thestatementwillbeexecutedsuccessfully,butanewtimezonewillnotbesetforthedatabase.

C.ThestatementwillnotbeexecutedsuccessfullybecausetheSETTIME_ZONEclausecanbeusedonlywiththeALTERSESSIONstatement.

D.ThestatementwillnotbeexecutedsuccessfullybecausetheALTERDATABASESETTIME_ZONEstatementisusedonlywhenthedatabasecontainsnotablewiththeTIMESTAMPTOLOCALTIMEZONEcolumn.


相似考题