单选题
To increase the availability of an Advanced Replication environment， you can add a new master to a replication group without quiescing the group. This is achieved（）.
Only when the new master site already has existing replication groups.
By issuing a single command to create, populate, and activate the new master.
When the master definition site is not the same for all of the master groups.
Without impacting end users who are executing data manipulation language (DML) commands on the replicated tables.
单选题
Click the Exhibit button and examine the diagram， which illustrates the components performing tasks within an Oracle Shared Sever environment. Which task is being performed by component 4？（）
The PMON process registers the request in the response queue.
A shared sever places the process request in the response queue.
A request within the request queue is processed by an idle shared server process.
A dispatcher assigns a request from the request queue to and idle shared server process.
单选题
Two data files have been deleted at the operating system level by accident. Your database is running in ARCHIVELOG mode and online backups are taken nightly. One of the data files that has been deleted belongs to the USERS tablespace on the other belongs to the SYSTEM tablespace. How can you recover from this situation？（）
Shut down the database, restore the two data files and then start up the database.
Take the system and users tablespace offline, restore the two data files, recover the two datafiles, and then bring the SYSTEM and USERS tablespaces online.
Shut down the database, restore the two data files, start up the database in MOUNT mode, recover the two data files, and then alter the database open.
Take the SYSTEM and USERS tablespaces offline, recover the two datafiles and then bring the SYSTEM and USERS tablespaces online.
多选题
You can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback？（）
Oracle Flashback uses undo information to construct consistent data.
You can use a cursor opened while using an Oracle Flashback image to perform DML once you deactivate Oracle Flashback in your session.
You can only use Oracle Flashback view of the data if the required records are still in the online redo log files.
Oracle Flashback lists the DML that was executed during the period you identify when initiating your session.
多选题
In which three situations is incomplete recovery required？（）
After a shutdown abort.
When recovering to an SCN.
When recovering until a specific time.
When a required archived log is missing.
多选题
The multithreaded agent architecture for heterogeneous services is similar to the Oracle multithreaded server architecture. The principal difference is that it used threads instead of processes. What are thee kinds of threads that it uses？（）
TCP
Task
Monitor
Dispatcher
Shared Server
Shutdown address
单选题
Which statement is true regarding Dynamic Service Registration？（）
Dynamic service registration requires configuration in the listener .ora file.
Dynamic service registration can be used only with an Oracle9/instance.
Dynamic service registration cannot register a local listener that does not use TCP/IP or port 1521.
The PMON background process automatically registers each database instance if the necessary parameters have been set in the database initialization parameter file.
单选题
What criterion does Oracle9i use to determine whether a database file is an Oracle Managed File？（）
The filename format.
Information stored inside a data dictionary table.
Information stored in the ALERT.LOG file for the corresponding instance.
Information stored inside the corresponding initialization parameter file for the instance.
单选题
Where can you obtain information about full database backup set created using RMAN， if the control file was used as the repository？（）
V$BACKUPSET
RC_DATABASE
V$BACKUP_SET
RC_BACKUP_SET
推荐考题
-
在任何情况下，伸缩调节器处轨距的要求为（）。
-
人类有两套影响学习的记忆系统：陈述性记忆和程序记忆。陈述性记忆是对事实或者词汇之类基本认识的记忆。而程序记忆，就是一个人“不劳而获”的记忆。程序记忆是人养成习惯和习得技巧的方式，比如骑自行车。在很多时候，这种学习是无意识的。人们用早期发育的程序记忆系统来学习复杂的东西，比如语法规则。帮助人们学习词汇的陈述性记忆系统，则需要更多时问完成发育。儿童拥有程序记忆系统，并且不受陈述性记忆系统的干扰。由此可以推出()。
-
宋末元初四大家
-
公平目标的实现可以通过（）实现。
-
荟萃分析
-
人员安全疏散分析的性能判定标准为：可用疏散时间（A.SET）必须（）必需疏散时间（RSET）。
-
预防HIV感染的主要措施应当为（ ）
-
简述我国混合型债券市场的发展状况。
-
造成水中某些污染物在生物体内含量大大高于水体中的浓度的生物放大作用是指（）
-
输血的适应证中，不包括（）