试题详情
- 单项选择题 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
关注下方微信公众号，在线模考后查看
热门试题
- Given： What is
- Which are̳
- Which two tasks can
- To enable̳
- Which object privile
- You create&ens
- Which of the followi
- What criterion
- Which three tasks ca
- ORACLE9i数据库服务器不能在下列哪
- When exporting
- RMAN provides more g
- The database admini
- Which two statements
- Consider the&e
- Which of
- Identify four&
- When CONFIGURE
- You realize that the
- A Mysql instance is