（单选题）
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？（）
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.
DThe statement will be executed successfully， but the new time zone will neither be set for the database nor for a specific session.
正确答案
答案解析
略
相似试题
（单选题）
You created a database by using the Database Configuration Assistant. What must you do to access a user account in the sample schemas？（）
（单选题）
You have created a resource plan， DB_PLAN， using DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN and you want to impose a restriction on utilization of resources by the database users. Which step must be performed before you can start using the resource plan？（）
（单选题）
You want to create a copy of the DEPARTMENTS table. When that is complete， you want to truncate the new DEPARTMENTS table， then restore the data with a direct-load insert from the old DEPARTMENTS table. Which CREATE statement should you use？（）
（单选题）
You work with a newly created database. Presently， there is no application load on the database instance. You want to create a baseline for tuning the application， so you decide to collect recommendations that can be implemented to improve application performance. What action must you take to achieve this？（）
（单选题）
You work as a database administrator for Certkiller .com. You want to create a new optimized database for your transactional production environment to be used by a financial application. While creating the database， you want the Oracle Software to take care of all basic settings to optimize the database performance. Which method would you use to achieve this objective？（）
（多选题）
You work as a database administrator for Supportcenter.cn. While setting up the database for your production environment， you want to create a user according to the requirements in the exhibit. Which three options of the CREATE USER command would you use to achieve this objective？（）
（多选题）
You work as a database administrator for Certkiller .com. While setting up the database for your production environment， you want to create a user according to the requirements in the exhibit. Which three options of the CREATE USER command would you use to achieve this objective？（）
（多选题）
You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing. What information is captured as part of this process？（）
（单选题）
As DBA for the Rebel Alliance you have decided that you need to facilitate some redundancy in your database. Using ASM， you want to create a disk group that will provide for the greatest amount of redundancy for your ASM data （you do not have advanced SAN mirroring technology available to you， unfortunately）. Which of the following commands would create a disk group that would offer the maximum in data redundancy？（）
（单选题）
You work as a database administrator for Certkiller .com. You need to rename a data file of atablespace. How would you perform this？（）
