单项选择题

A. The statement will be executed successfully， and a n……

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.

<上一题目录下一题>

热门试题

单项选择题You are maintaining your database in Oracle10g. You find that the number of languages that should be supported in your database has increased. The character set of your database is UTF8. You decide to migrate your database to the AL16UTF16 national character set. How will you migrate your database from UTF8 to AL16UTF16？（）

A. by using the RMAN utility
B. by using the export/import utility
C. by using the ALTER DATABASE command
D. by enabling the change tracking feature

单项选择题Click the Exhibit（s） button to view the EMPLOYEES table. The EMPLOYEE table contains thousands of rows. The EMP_CODE column is the primary key column. At the end of every month， you are required to perform search queries based on the BASIC_SAL+COMM column values. Which type of index will you create？（）

A. B-tree Index
B. Bitmap Index
C. Function-based Index
D. Partitioned Index

单项选择题You issued the following command at the UNIX environment： % setenv ORA_SDTZ ’OZ_TZ’ What will be the impact of issuing the above command？（）

A. The operating system local time zone will be set for a user session using the operating system environment variable.
B. The database local time zone will be set for a user session using the operating system environment variable.
C. The operating system local time zone will be set for the database using the operating system environment
D. The database local time zone will be set for the database using the operating system environment variable.

单项选择题YouaremaintainingyourOracle10gdatabaseintheUNIXenvironment.Anapplicationrequiresoneoftheusersessionstoexistintheoperatingsystemlocaltimezone.Youdecidetosetthetimezoneforasessionusingtheoperatingsystemenvironmentvariable.Whichcommandwillyouissue？（）

A. setenv ORA_SDTZ ’DB_TZ’
B. setenv ORA_SDTZ ’+10：00’
C. setenv ORA_SDTZ ’OS-TZ’
D. setenv ORA_SDTZ ’Europe/London’

单项选择题YouarespecifyingFrenchcase-insensitivesortsbyusingtheNSL_SORTparameterfortheusersessionoftheuser，Scott.WhichvaluewillyousetfortheNLS_SORTparameter？（）

A. FRENCH_AI
B. FRENCH_CI
C. AI_FRENCH
D. CI_FRENCH