（单选题）
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 work as a database administrator for Certkiller .com. In your Oracle database10g installation you have set ORACLE_BASE to /u01/app/oracle. Which objective will be achieved by this setting？（）
（单选题）
Your boss at Certkiller .com wants you to clarify Oracle 10g. What statement about the Shared Server configuration is valid？（）
（单选题）
Your boss at Certkiller .com wants you to clarify Oracle 10g. Which statement is true about the analysis of the Automatic Database Diagnostic Monitor （ADDM）？（）
（单选题）
You executed the following command in Recovery Manager （RMAN） against your Oracle 10g database： RMAN> REPORT NEED BACKUP days 3; What would be the output of this command？（）
（单选题）
You are working as a DBA on Oracle Database 9i. You plan to upgrade your 9i database to Oracle 10g. To be familiar with the new database technology， you decide to install Oracle Database 10g on your workstation at home. You create a general purpose database. After the installation， you make the following changes in your initialization parameter file：LOG_ARCHIVE_DEST_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST’ DB_RECOVERY_FILE_DEST = ’LOCATION=d：/product/10.1.0/flash_recovery_area’ DB_RECOVERY_FILE_DEST_SIZE=10g Where are the archived redo logs stored for your database？（）
（单选题）
Your organization decided to upgrade the existing Oracle 10g database to Oracle 11g database in a multiprocessor environment. At the end of the upgrade，you observe that the DBA executes the following script： SQL> @utlrp.sql What is the significance of executing this script？（）
（单选题）
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？（）
（多选题）
You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option. What is the effect of opening the database with the RESETLOGS option？ （）
（单选题）
You performed an incomplete recovery on your Oracle Database 10g database using the following command： SQL> RECOVER DATABASE 2 UNTIL TIME ’2004-08-05：12：10：03’ 3 USING BACKUP CONTROLFILE； In which situation would the above recovery be required？（）
（多选题）
You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option. What is the effect of opening the database with the RESETLOGS option？（）
