YourOracle10gdatabasecontainsatablewithaTIMESTAMPTOLOCALTIMEZONEcolumn.Thereareabouttwohundredcolumnvaluesforthecolumn.Youissuedthefollowingstatement:SQL>ALTERDATABASESETTIME_ZONE=’Europe/London’;Whatwillbetheresultofissuingtheabovestatement?()
A.Thestatementwillbeexecutedsuccessfully,andanewtimezonewillbesetforthedatabase.
B.Thestatementwillbeexecutedsuccessfully,butanewtimezonewillnotbesetforthedatabase.
C.ThestatementwillnotbeexecutedsuccessfullybecausetheSETTIME_ZONEclausecanbeusedonlywiththeALTERSESSIONstatement.
D.ThestatementwillnotbeexecutedsuccessfullybecausetheALTERDATABASESETTIME_ZONEstatementisusedonlywhenthedatabasecontainsnotablewiththeTIMESTAMPTOLOCALTIMEZONEcolumn.