单选题
Two database users, Jack and Bill, are accessing the SupportCenter STAFF table of the SupportCenter DB database. When Jack modifies a value in the table, the new value is invisible to Bill. Which is the modified value invisible to Bill?（）
The modified data are not available on disk.
The modified data have been flushed out from memory.
The modified rows of the SupportCenter STAFF table have been locked.
Jack has not committed the changes after modifying the value.
Both users are accessing the database from two different machines.
多选题
Which two operations can be flashed back using the Flashback technology？（）
DROP USER SMITH；
DROP TABLE EMPLOYEES；
DROP TABLESPACE USERS；
ALTER TABLE SALES_REP DROP PARTITION P1；
ALTER TABLE EMPLOYEES DROP COLUMN DESIG_ID；
单选题
It is a holiday and no transactions are being performed on the database. You took a consistent backup of your database without using Recovery Manager （RMAN）. How would you make use of this consistent backup in RMAN？（）
cannot be used in RMAN
by starting up the database again
by using the CATALOG command of RMAN
by using the RECOVER CATALOG command in RMAN
by re-creating the target control file to rebuild the RMAN repository
单选题
You work as a database administrator for Certkiller .com. In your production database， the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database， you want to accomplish this task with no impact on the user’s connections. Which activity must you have completed before accomplishing this task？（）
You must have started the database instance in restricted mode.
You must have started the database instance inNORMALmode.
You must have started the database instance with server parameter file.
You must have started the database instance but must not have mounted.
You must have started the database instance but must not have opened.
单选题
You want to be notified when the space usage of an existing critical tablespace has reached 75% of the allocated space. Which option would you use to achieve this？（）
run a procedure to check the tablespace space usage
define the warning threshold for the tablespace at 75% in Database Control
create a trigger to be executed when tablespace space usage reaches 75%
submit a job by using DBMS_JOB package to check the free space in the tablespace at regular intervals
define the warning threshold to be 75% for the tablespace by ALTER TABLESPACE .. ADD THRESHOLD command
多选题
You work as a database administrator for Certkiller .com. While setting up the database for your production environment， you want to create a user according to the requirements in the exhibit. 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 Certkiller TBS1
Password never expire
Defaulttablespace Certkiller TBS1
Quota unlimited on Certkiller TBS1
TemporarytablespaceTEMP
TemporarytablespaceSYSTEM
单选题
Which is the correct description of the significance of the ORACLE_HOME environmental variable？（）
It specifies the directory containing the Oracle software.
It specifies the directory containing the Oracle-Managed Files.
It specifies the directory for database files， if not specified explicitly.
It specifies the base directory of Optimal Flexible Architecture （OFA） .
单选题
You are using the following command to clear the log file group： ALTER DATABASE CLEAR LOFFILE GROUP 2； In which case would the command be successful？（）
Group 2 is the active group.
Group 2 is the current group.
Database is in the MOUNT state.
Group 2 has been already archived.
推荐考题
-
在任何情况下，伸缩调节器处轨距的要求为（）。
-
人类有两套影响学习的记忆系统：陈述性记忆和程序记忆。陈述性记忆是对事实或者词汇之类基本认识的记忆。而程序记忆，就是一个人“不劳而获”的记忆。程序记忆是人养成习惯和习得技巧的方式，比如骑自行车。在很多时候，这种学习是无意识的。人们用早期发育的程序记忆系统来学习复杂的东西，比如语法规则。帮助人们学习词汇的陈述性记忆系统，则需要更多时问完成发育。儿童拥有程序记忆系统，并且不受陈述性记忆系统的干扰。由此可以推出()。
-
宋末元初四大家
-
公平目标的实现可以通过（）实现。
-
荟萃分析
-
人员安全疏散分析的性能判定标准为：可用疏散时间（A.SET）必须（）必需疏散时间（RSET）。
-
预防HIV感染的主要措施应当为（ ）
-
简述我国混合型债券市场的发展状况。
-
造成水中某些污染物在生物体内含量大大高于水体中的浓度的生物放大作用是指（）
-
输血的适应证中，不包括（）