单选题
You issued the following statement： SQL> ALTER SESSION SET NLS_LANG=FRENCH_CANADA.WE8ISO8859P1； Which parameter is NOT overridden by using the above statement？（）
the value of the NLS_LANGUAGE variable
the value of the NLS_TERRITORY variable
the value of the NLS_CURRENCY variable
the character encoding scheme used by the client application
多选题
You decided to configure the flash recovery area in your database to centralize the storage of all the recovery files in a certain location on disk. Which two parameters will you specify in the init.ora file？（）
DB_CREATE_FILE_DEST
DB_RECOVERY_FILE_DEST
DB_RECOVERY_FILE_DEST_SIZE
DB_ONLINE_LOG_DEST_n
单选题
Which background process sequentially writes Flashback Database data from the flashback buffer to the Flashback Database logs？（）
DBWn
RECO
RVWR
LGWR
单选题
What will be the result of using the SQL> DROP USER SCOTT CASCADE； command？（）
The user， Scott， is dropped， all the objects in Scott’s schema are placed in the Recycle Bin， and the objects that are already in the Recycle Bin are dropped.
The user， Scott， is dropped， all the objects in Scott’s schema are placed in the Recycle Bin， and all the objects in the Recycle Bin， belonging to the user Scott， are not dropped.
The user， Scott， is dropped， all the objects in the Scott’s schema are not placed in the Recycle Bin， and the objects in the Recycle Bin， belonging to the user， Scott， are not dropped.
The user， Scott， is dropped， all the objects in Scott’s schema are not placed in the Recycle Bin， and the objects in the Recycle Bin are dropped.
多选题
Which two statements are true about Block Media Recovery （BMR）？（）
BMR increases the Mean Time To Recover （MTTR）.
BMR can only be implemented using Recovery Manager （RMAN）.
The blocks that need to be recovered are accessible during BMR.
BMR cannot be performed using cumulative incremental backups.
The datafile must be restored if most of the blocks in the datafile are corrupt.
单选题
Your database is configured on non-ASM disk storage. You need to migrate your database to ASM disk storage. Which statement is true about migrating from non-ASM disk storage to ASM disk storage？（）
You can use the operating system utility to migrate from non-ASM disk storage to ASM disk storage.
You cannot perform a database backup from non-ASM disk storage to tape and then move it to ASM disk storage.
You can use the SWITCH DATABASE TO COPY Recovery Manager （RMAN） command to switch back to non-ASM disk storage if you have not deleted your original datafiles.
You cannot use Recovery Manager （RMAN） to migrate from non-ASM disk storage to ASM disk storage if you are not using RMAN for your backup and recovery strategies.
单选题
You are maintaining the database in Oracle10g. You are performing an incomplete recovery by using RMAN because an important table， EMPLOYEE， is dropped and purged from the Recycle Bin. Which statement is NOT true regarding an incomplete recovery？（）
The target database must be in the MOUNT mode to ensure restoration of the datafiles.
You can restore the datafiles from the backup by using the RMAN utility only if the backups were taken using the RMAN utility.
The control file must be recreated.
The database must be opened with the RESETLOGS option.
单选题
You want to enable the user， Scott， to change to the GRP1 consumer group by issuing the following code： SQL> EXEC DBMS_SESSION.SWITCH_CURRENT_CONSUMER_GROUP （’SCOTT’， ’GRP1’， FALSE）； How will you grant the switch privilege to the user， Scott？（）
by using the DBMS_SESSION package
by granting the DBA role
by using the DBMS_RESOURCE_MANAGER package
by using the DBMS_RESOURCE_MANAGER_PRIVS package
单选题
Your database is running in the automatic Program Global Area （PGA） memory management and Shared Memory Management mode. You want to increase the memory available for the SQL work areas. What would you do？（）
modify the HASH_AREA_SIZE initialization parameter
modify the PGA_AGGREGATE_TARGET initialization parameter
modify the WORK_AREASIZE_POLICY initialization parameter
increase the value of the SGA_TARGET initialization parameter
increase the value of the SGA_MAX_SIZE initialization parameter
increase the value of the SORT_AREA_SIZE initialization parameter
单选题
You are working in an online transaction processing （OLTP） environment. You realize that the salary for an employee， John， has been accidentally modified in the EMPLOYEES table. Two days ago， the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area. Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected？（）
perform point-in-time recovery
perform a Flashback Table operation to restore the table to the state it was in two days ago
perform a Flashback Database operation to restore the database to the state it was in two days ago
perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements， and then use them for recovery
推荐考题
-
在任何情况下，伸缩调节器处轨距的要求为（）。
-
人类有两套影响学习的记忆系统：陈述性记忆和程序记忆。陈述性记忆是对事实或者词汇之类基本认识的记忆。而程序记忆，就是一个人“不劳而获”的记忆。程序记忆是人养成习惯和习得技巧的方式，比如骑自行车。在很多时候，这种学习是无意识的。人们用早期发育的程序记忆系统来学习复杂的东西，比如语法规则。帮助人们学习词汇的陈述性记忆系统，则需要更多时问完成发育。儿童拥有程序记忆系统，并且不受陈述性记忆系统的干扰。由此可以推出()。
-
宋末元初四大家
-
公平目标的实现可以通过（）实现。
-
荟萃分析
-
人员安全疏散分析的性能判定标准为：可用疏散时间（A.SET）必须（）必需疏散时间（RSET）。
-
预防HIV感染的主要措施应当为（ ）
-
简述我国混合型债券市场的发展状况。
-
造成水中某些污染物在生物体内含量大大高于水体中的浓度的生物放大作用是指（）
-
输血的适应证中，不包括（）