问题:
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.
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?()
● 参考解析
本题暂无解析