YoucreatedtheORDERStableinyourdatabaseby&eYoucreatedtheORDERStableinyourdatabasebyusingthefollowingcode:SQL>CREATETABLEORDERS(ORDER_DATETIMESTAMP(0)WITHTIMEZONE);Then,youinserteddataintheORDERStableandsaveditbyissuingthefollowingstatements:SQL>INSERTINTOO

题目
YoucreatedtheORDERStableinyourdatabaseby&e

YoucreatedtheORDERStableinyourdatabasebyusingthefollowingcode:

SQL>CREATETABLEORDERS(ORDER_DATETIMESTAMP(0)WITHTIMEZONE);

Then,youinserteddataintheORDERStableandsaveditbyissuingthefollowingstatements:SQL>INSERTINTOORDERSVALUES(’18-AUG-0010:26:44PMAmerica/New_York’);

SQL>INSERTINTOORDERSVALUES(’23-AUG-0212:46:34PMAmerica/New_York’);

SQL>COMMIT;

Next,youissuedthefollowingstatementtochangethetimezoneforthedatabase:

SQL>ALTERDATABASESETTIME_ZONE=’Europe/London’;

Whatwillbetheresultofexecutingtheabovestatement?()


相似考题