---

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.

---

出自：Oracle认证

显示答案