多选题
You work as a database administrator for Certkiller .com. Users in the Certkiller PROD database complain about the slow response when accessing the database. In the Active Session Waiting： Configuration page you find that the majority of the wait time is for the redo log buffer.Further investigation using the Run Queue graph and operating system tools reveals that the redo log files are on the same disks， and that the disk I/O for the redo log files is the reason for the performance degradation. Which two actions would you take to gain performance？（）
Increase the size of redo log files
Increase the size of redo log buffer
Increase the number of redo log files
Place the redo log files on a separate disk
Decrease the number of redo log groups to two
Increate the number Log Writer （LGWR） process
单选题
You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file？（）
Restore all the data files and open the database
Create the data file and performtablespacerecovery
No need to restore any file， just recover the database
Restore only the system data file and recover the database
Restore only lost date file and performtablespacerecovery
单选题
Exhibit
One the evening of April 22， you are working on a database created using Oracle Database 10g. This database operates in the ARCHIVELOG mode. You discover that you need crucial data that was dropped from the database at 8：00 a.m. No full backup has been taken after April 15. What would you do？（）
recover the database until April 10
recover the database until April 15
recover the database until 22 7：59 a.m.
recovery is not possible； manually re-create the object
多选题
In your database， the Log Writer （LGWR） process is unable to write to a member of a current redo log group due to read/write failure. Which two effects would you see in your database？（）
The database instance aborts.
The database operation temporarily halts till the member becomes available.
Writing proceeds as normal. LGWR writes to the available members of a group and ignores the unavailable members.
The member would be marked as STALE and an error message would be written to the alert log file and LGWR trace file.
The status of the group changes to INACTIVE and an error message would be written to the alert log file and LGWR trace file.
单选题
Exhibit， error
You work as a database administrator for Supportcenter.cn. When you try to connect to the database， you get an error （See exhibit）. What could be the possible reason for getting such an error？（）
Database is not open
Listener is not running
Service name is not correct
Wrong port number used in URL
Usersysdoes have themediaprivilege
单选题
Your database is started by using the server parameter file （SPFILE）. You issued this command to change the value of the LOG_BUFFER initialization parameter： ALTER SYSTEM SET LOG_BUFFER=24M SCOPE=BOTH； What would be the outcome of this command？ （）
The command would return an error because LOG_BUFFER is a static parameter.
The parameter value would be changed and it would come into effect immediately.
You need to restart the database so that parameter changes can come into effect.
The command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.
单选题
Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2， and archiving has stopped. All the redo logs are filled and database activity is halted. Database writer has written everything to disk. Which command would you execute to proceed further？（）
RECOVER LOGFILE BLOCK GROUP 2；
ALTER DATABASE DROP LOGFILE GROUP 2；
ALTER DATABASE CLEAR LOGFILE GROUP 2；
ALTER DATABASE RECOVER LOGFILE GROUP 2；
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2；
单选题
Your boss at Certkiller .com wants you to clarify Oracle 10g. Which statement is true about the analysis of the Automatic Database Diagnostic Monitor （ADDM）？（）
A
B
C
D
E
F
多选题
You work as a database administrator for Certkiller .com. You are using Recovery Manager （RMAN） to perform backups in your databases. Which four backup operations can be performed using RMAN？（）
A backup of the target database when it is mounted
A backup of online redo log files when the database is open
A backup of only used data blocks in the file beingbeingbackup up
A backup of online， read/write data files when the database is open
A backup of only those data blocks that have changed since a previous backup
A backup of online， read/write data files when the database is in the NOMOUNT state.
单选题
While planning to manage more than one database in your system， you perform the following activities： 1. Organize different categories of files into independent subdirectories. 2. Use consistent naming convention for database files. 3. Separate administrative information pertaining to each database. Which option corresponds to the type of activities performed by you？（）
Oracle Managed Files
Oracle Grid Architecture
Optimal Flexible Architecture
Oracle database architecture
推荐考题
-
在任何情况下，伸缩调节器处轨距的要求为（）。
-
人类有两套影响学习的记忆系统：陈述性记忆和程序记忆。陈述性记忆是对事实或者词汇之类基本认识的记忆。而程序记忆，就是一个人“不劳而获”的记忆。程序记忆是人养成习惯和习得技巧的方式，比如骑自行车。在很多时候，这种学习是无意识的。人们用早期发育的程序记忆系统来学习复杂的东西，比如语法规则。帮助人们学习词汇的陈述性记忆系统，则需要更多时问完成发育。儿童拥有程序记忆系统，并且不受陈述性记忆系统的干扰。由此可以推出()。
-
宋末元初四大家
-
公平目标的实现可以通过（）实现。
-
荟萃分析
-
人员安全疏散分析的性能判定标准为：可用疏散时间（A.SET）必须（）必需疏散时间（RSET）。
-
预防HIV感染的主要措施应当为（ ）
-
简述我国混合型债券市场的发展状况。
-
造成水中某些污染物在生物体内含量大大高于水体中的浓度的生物放大作用是指（）
-
输血的适应证中，不包括（）