单选题
You work as a database administrator for Supportcenter.cn. You find that reports are running for a long time in your data warehousing applications. You suspect a lack of indexes is the reason for the performance degradation. Which advisory component would you refer to， in order to determine the appropriate indexes？（）
Memory Advisors
Segment Advisors
SQL Tuning and Access Advisors
Automated Workload Repository （AWR）
Automatic Database Diagnostic Monitor （ADDM）
单选题
Where do you find information about a missing redo log file？（）
trace file
audit trail
control file
alert log file
event viewer
单选题
What advantage would you get if you increase the length of time during which the undo information would be stored in the database？（）
roll back of large transactions
roll forward to redo a transaction
data concurrency for large updates
read consistency for long-running transactions
单选题
The user SCOTT executes the following command successfully to increase the salary values in one of his sessions： SQL> UPDATE emp SET sal=sal*1.15 WHERE deptno=20； Before SCOTT ends the transaction， user HR who has the privileges on EMP table executes a query to fetch the salary details but finds the old salary values instead of the increased values. Why does HR still see the old data？（）
because of redo data from redo log file
because of data from database buffer cache
because of data from a temporary tablespace
because of undo data from the undo tablespace
单选题
You work as a database administrator for Certkiller .com. You are using three database， Certkiller DB01， Certkiller DB02， and Certkiller DB03， on different host machines in your development environment. The database serverconfiguration， such as IP address and listener port number， change frequently due to development requirements， and you havethe task of notifying the developers of the changes. Which connection method would you use to overcome this overhead？（）
Host naming
Local naming
Easy Connect
External naming
directory naming
多选题
What are the consequences of executing the SHUTDOWN ABORT command？ （）
The database files are synchronized.
Uncommitted changes are not rolled back.
The database is closed， but the instance is still started.
Database buffers and redo buffers are not written to the disk.
The database undergoes automatic media recovery during the next startup.
单选题
You executed the following command to start the database： SQL> STARTUP ORACLE instance started. Total System Global Area 281018368 bytes Fixed Size 789000 bytes Variable Size 229635576 bytes Database Buffers 50331648 bytes Redo Buffers 262144 bytes ORA-00205： error in identifying controlfile， check alert log for more info Which view would you query at this stage to investigate this missing control file？（）
V$INSTANCE
V$CONTROLFILE
DBA_CONTROL_FILES
V$DATABASE_PROPERTIES
V$CONTROLFILE_RECORD_SECTION
多选题
While setting up the database for your production environment， you want to create a user with following requirements. 1.The objects created by the user must be stored in a tablespace， TBS1， if the TABLESPACE option is not defined during the object creation. 2.The user should be able to use 10MB of space in the tablespace TBS1. 3.The user must change the password immediately after logging in for the first time. Which three options of the CREATE USER command would you use to achieve this objective？（）
profile
account lock
account unlock
password expire
quota 10MB on TBS1
password never expire
default tablespace TBS1
quota unlimited on TBS1
temporary tablespace TEMP
temporary tablespace SYSTEM
推荐考题
-
在任何情况下，伸缩调节器处轨距的要求为（）。
-
人类有两套影响学习的记忆系统：陈述性记忆和程序记忆。陈述性记忆是对事实或者词汇之类基本认识的记忆。而程序记忆，就是一个人“不劳而获”的记忆。程序记忆是人养成习惯和习得技巧的方式，比如骑自行车。在很多时候，这种学习是无意识的。人们用早期发育的程序记忆系统来学习复杂的东西，比如语法规则。帮助人们学习词汇的陈述性记忆系统，则需要更多时问完成发育。儿童拥有程序记忆系统，并且不受陈述性记忆系统的干扰。由此可以推出()。
-
宋末元初四大家
-
公平目标的实现可以通过（）实现。
-
荟萃分析
-
人员安全疏散分析的性能判定标准为：可用疏散时间（A.SET）必须（）必需疏散时间（RSET）。
-
预防HIV感染的主要措施应当为（ ）
-
简述我国混合型债券市场的发展状况。
-
造成水中某些污染物在生物体内含量大大高于水体中的浓度的生物放大作用是指（）
-
输血的适应证中，不包括（）