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.

D、The statement will be executed successfully， but the new time zone will neither be set for the database nor for a specific session.

相关问题推荐

• You have joined a new organization as a Database Administrator. The Security Administrator in your organization has kept human errors， such as erroneously dropping users， tables， and important data， to a minimum by carefully granting only the necessary privileges to each user. As a result of several ongoing transactions within your database， you discover that the flashback logs are rapidly increasing in the flash recovery area. To avoid out-of-space errors， you decide to delete the flashback logs from the flash recovery area. How can you delete the flashback logs from the database if your database is up and running？（）

  A、 Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.

  B、 Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement while the database is up and running.

  C、 Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command. Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.

  D、 Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.

  查看答案

• public class Yippee {  public static void main（String [] args） {  for（int x = 1； x 

  A、 No output is produced. 123

  B、 No output is produced. 234

  C、 No output is produced. 1234

  D、 An exception is thrown at runtime. 123

  E、 An exception is thrown at runtime. 234

  F、 An exception is thrown at rijntime. 1234

  查看答案

• You work as a database administrator at Certkiller .com. Your database is open and running in ARCHIVELOGmode. You take RMANfull backups every Sunday night. On Monday morning， while querying the user1.employeestable， you receive the following error message：  01578： ORACLE data block corrupted （file # 5， block # 51）  ORA-01110： data file 5：’/u01/app/oracle/oradata/orcl/example01.dbf’  You need to rectify the corruption while ensuring the following：  The data file should remain online.  The mean time to recover （MTTR） should be minimal.  You are not using a backup control file and all the archived logs are accessible.  Which option would you choose？（）

  A、 flash back the corrupted blocks

  B、 use the DBMS_REPAIR package

  C、 use the RMAN TSPITR command

  D、 use the RMAN BLOCKRECOVER command

  E、 use the RESTORE DATABASE and RECOVER DATABASE commands

  F、 investigate the time at which the corruption occurred and perform a point-in-time recovery

  查看答案

• Your SPFILE contains the following parameter settings：   SGA_TARGET = 8G   DB_CACHE_SIZE = 4G   SHARED_POOL_SIZE = 2G   LARGE_POOL_SIZE = 512M   JAVA_POOL_SIZE = 512M   LOG_BUFFER = 100M   SGA_MAX_SIZE = 10G   You query the V$SGA_DYNAMIC_COMPONENTS dynamic performance view and discover that the large pool component is currently sized at 1G. You want the value of the SGA_TARGET initialization parameter to 10G， but instead of specifying a value of 10G for the SGA_TARGET initialization parameter， you erroneously execute the following statement：   SQL>ALTER SYSTEM SET SGA_TARGET = 0 SCOPE = BOTH；   What is the result of this statement？（）  

  A、 The database crashes.

  B、 The large pool releases 512M of memory.

  C、 The large pool retains 1G of allocated memory.

  D、 The large pool increases to 1，512M of memory.

  查看答案

• Users are performing a large volume of inserts and deletes on the application tables in the APPS tablespace. You observe that there are several warning alerts being generated for the APPS tablespace space usage metrics. Currently， the warning threshold for the tablespace space usage metrics is set to 70%.  To make the generated alerts more useful as a problem identification tool， you want to reduce the frequency of alert generation for the tablespace space usage metrics for the APPS tablespace. What should you do？（）

  A、disable SQL tracing for theAPPS tablespace

  B、disable logging attribute for the APPS tablespace

  C、modify the tablespace to be a dictionary­managed tablespace

  D、increase the critical threshold value for the tablespace space usage metrics for the APPS tablespace

  E、increase the warning threshold value for the tablespace space usage metrics for the APPS tablespace

  查看答案