多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

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
答案解析:
进入题库查看解析

微信扫一扫手机做题