You created the ORDERS table in your database by using the following code: SQL> CREATE TABLE ORDERS (ORDER_DATE TIMESTAMP(0) WITH TIME ZONE); Then, you inserted data in the ORDERS table and saved it by issuing the following statements:SQL> INSERT INTO ORDERS VALUES(’18-AUG-00 10:26:44 PM America/New_York’); SQL> INSERT INTO ORDERS VALUES(’23-AUG-02 12:46:34 PM America/New_York’); SQL> COMMIT; Next, you issued the following statement to change the time zone for the database: SQL> ALTER DATABASE SET TIME_ZONE=’Europe/London’; What will be the result of executing the above statement?()
- A、 The statement will fail.
- B、 The statement will be executed successfully, and the new time zone will be set for the database.
- C、 The statement will be executed successfully, but the new time zone will be set for the current session.
- D、The statement will be executed successfully, but the new time zone will neither be set for the database nor for a specific session.
正确答案:A
答案解析:有

微信扫一扫手机做题