You created the _睦霖题库

单项选择题 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.

热门试题