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

Oracle认证考试

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

Your Oracle10g database contains a table with a TIMESTAMP TO LOCAL TIME ZONE column. There are about two hundred column values for the column. You issued the following statement:   SQL> ALTER DATABASE SET TIME_ZONE =’Europe/London’;   What will be the result of issuing the above statement?()

  • A、 The statement will be executed successfully, and a new time zone will be set for the database.
  • B、 The statement will be executed successfully, but a new time zone will not be set for the database.
  • C、 The statement will not be executed successfully because the SET TIME_ZONE clause can be used only with the ALTER SESSION statement.
  • D、 The statement will not be executed successfully because the ALTER DATABASE SET TIME_ZONE statement is used only when the database contains no table with the TIMESTAMP TO LOCAL TIME ZONE column.
正确答案:D
答案解析:
进入题库查看解析

微信扫一扫手机做题