移动端

  • 题王微信公众号

    题王微信公众号

    微信搜“题王网”真题密题、最新资讯、考试攻略、轻松拿下考试

单选题

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?()  

发布日期:2020-04-10

You created the ORDERS table in your database by u...
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.

题王网让考试变得更简单

扫码关注题王,更多免费功能准备上线!

此试题出现在

CMS专题

CMS专题

去刷题
热门试题热门资讯 相关试题

暂无相关推荐~