Which of the following datatypes store time-zone information in the database？（）A、 TIMESTAMPB、 DATEC、 TIMESTAMP WITH TIME ZONED、 TIMESTAMP WITH LOCAL TIME ZONEE、 DATETIME

第1题：

第2题：

How does NTP help you troubleshoot network problems?（）

• A、By calculating the time offset from the GPS or atomic clock
• B、By setting the router clock to the default value if the router can't connect to a time server
• C、By setting all network devices to the correct time
• D、By setting necessary time date in the timestamp information

第3题：

第4题：

You are working on an Oracle Database 10g database. Because of data loss， you decided to perform a Flashback Database operation using the following command：  SQL> FLASHBACK DATABASE TO TIMESTAMP（SYSDATE 5/24）;  Which two statements are true？ （）

• A、SYSDATE should not be used with TIMESTAMP.
• B、The database must have multiplexed redo log files.
• C、The database must be in the MOUNT state to execute the command.
• D、The database must be opened with the RESETLOGS option after the flashback operation.
• E、The entire database needs to be restored from the most recent backup before the flashback operation.

第5题：

You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN). Identify two scenarios is which you must have a recovery catalog.（）

• A、To store the backup information of multiple database
• B、To restrict the amount of space that is used by the backups
• C、To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.
• D、To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.

第6题：

Which command will restore all datafiles to the date 9/30/2008 at 18:00 hours? （）

• A、restore datafiles until time '09/28/2008:21:03:11'
• B、restore database files until time '09/28/2008:18:00:00'
• C、restore database until time '09/28/2008:18:00:00'
• D、recover database until time '09/28/2008:18:00:00'
• E、recover database until timestamp '09/28/2008:18:00:00'

第7题：

Which of the following are all valid DB2 data types?（）

• A、LONG VARCHAR, SMALLINT, NUMBER, BLOB
• B、DECIMAL, DATE, DBCLOB, INTERVAL
• C、NUMERIC, TIMESTAMP, BYTE, FLOAT
• D、NUM, TIME, XML, DOUBLE

第8题：

第9题：

You executed the following FLASHBACK TABLE command： FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）; Which two statements are correct？（）

• A、The FLASHBACK TABLE statement will not be written to the alert log file.
• B、The changes made to the EMP table since the specified time will be undone.
• C、The EMP table that was dropped by mistake from the database will be restored.
• D、The FLASHBACK TABLE statement will be executed within a single transaction.
• E、The FLASHBACK TABLE statement will not maintain the existing indexes on the EMP table. 
• F、The list of transactions that have modified the EMP table since the specified time will be displayed.

第10题：

Which of the following datatypes store time-zone information in the database?（）

• A、TIMESTAMP
• B、DATE
• C、TIMESTAMP WITH TIME ZONE
• D、TIMESTAMP WITH LOCAL TIME ZONE
• E、DATETIME