单选题
Which of the following datatypes store time-zone information in the database？（）
TIMESTAMP
DATE
TIMESTAMP WITH TIME ZONE
TIMESTAMP WITH LOCAL TIME ZONE
DATETIME
单选题
You backed up the database at 8 a.m. today using an online backup. Accounting made a large change to the underlying data between 10 a.m. and noon. Which of the following actions would ensure that the changes could be recovered using the 8 a.m. backup？（）
Create a manual incremental online database backup.
Back up all the archived redo logs generated since the 8 a.m. backup.
Create a brand-new backup after all the changes have been applied.
There is no way to make the changes recoverable based on the 8 a.m. backup.
Perform an online backup of the tablespace（s） that contained changed data.
单选题
Which of the following options describes Segment Shrink？（）
Reclaims space above and below the high-water mark without using additional space
Moves rows to a new physical location，resetting the high-water mark，but uses additional space during the operation
Deallocates space above the high-water mark that is currently not in use
None of the above
单选题
What RMAN command must you use before you can back up a database using the recovery catalog？（）
create catalog
install database
catalog database
merge Catalog with database
register database
单选题
Examine the following scenario: - Database is running in ARCHIVELOG mode. - Complete consistent backup is taken every Sunday. - On Tuesday the instance terminates abnormally because the disk on which control files are located gets corrupted - The disk having active online redo log files is also corrupted. - The hardware is repaired and the paths for online redo log files and control files are still valid. Which option would you use to perform the recovery of database till the point of failure?（）
Restore the latest whole backup, perform complete recovery, and open the database normally
Restore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGS option.
Restore the latest backups control file, perform complete recovery, and open the database with the RESETLOGS option.
Restore the latest backup control file, perform incomplete recovery using backup control file, and open the database with the RESETLOG option.
单选题
Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework？（）
SQL statements that are part of the AWR baseline only
SQL statements based on the AWR top SQL identification
SQL statements that are part of the available SQL Tuning Set （STS） only
SQL statements that are available in the cursor cache and executed by a user other than SYS
单选题
Which statement about recovering from the loss of a redo log group is true？（）
If the lost redo log group is ACTIVE， you should first attempt to clear the log file.
If the lost redo log group is CURRENT， you must clear the log file.
If the lost redo log group is ACTIVE， you must restore，perform cancel-based incomplete recovery，and open the database using the RESETLOGS option.
If the lost redo log group is CURRENT， you must restore，perform cancel-based incomplete recovery，and open the database using the RESETLOGS option.
多选题
What are three benefits of using ASM？（）
Ease of disk administration and maintenance
Load balancing across physical disks
Software RAID-1 data redundancy with double or triple mirrors
Automatic recovery of failed disks
单选题
You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table？（）
The Automatic Memory Manager （AMM）
The SQL Tuning Advisor
The Segment Advisor
The SQL Access Advisor
单选题
You want to configure the Flashback Database feature and retain flashback logs for three days. Presently the database is open and configured in ARCHIVELOG mode. The following steps must be performed in the correct sequence to do this:
Choose the correct sequence.（）
4，1，3，2，5
4，3，1，2，5
2，4，3，5，1
4，2，5，3，1
推荐考题
-
在任何情况下，伸缩调节器处轨距的要求为（）。
-
人类有两套影响学习的记忆系统：陈述性记忆和程序记忆。陈述性记忆是对事实或者词汇之类基本认识的记忆。而程序记忆，就是一个人“不劳而获”的记忆。程序记忆是人养成习惯和习得技巧的方式，比如骑自行车。在很多时候，这种学习是无意识的。人们用早期发育的程序记忆系统来学习复杂的东西，比如语法规则。帮助人们学习词汇的陈述性记忆系统，则需要更多时问完成发育。儿童拥有程序记忆系统，并且不受陈述性记忆系统的干扰。由此可以推出()。
-
宋末元初四大家
-
公平目标的实现可以通过（）实现。
-
荟萃分析
-
人员安全疏散分析的性能判定标准为：可用疏散时间（A.SET）必须（）必需疏散时间（RSET）。
-
预防HIV感染的主要措施应当为（ ）
-
简述我国混合型债券市场的发展状况。
-
造成水中某些污染物在生物体内含量大大高于水体中的浓度的生物放大作用是指（）
-
输血的适应证中，不包括（）