单选题
By mistake， you ran the batch job （for updating the BILL_DETAILS table） twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify： a） a list of changes made along with the transaction identifier of each change b） the necessary SQL statements to undo the erroneous changes Which option would you choose？（）
RMAN only
Flashback Table only
Flashback Versions Query only
Flashback Database and Flashback Transaction Query
Flashback Versions Query and Flashback Transaction Query
单选题
View the Exhibit and examine the properties of the TT tablespace.
Using Database Control， you have scheduled a job to shrink the TRANS table residing on the TT tablespace. The job would run at 5：00 p.m. every Friday.When you examine the space usage of the table after the completion of the job， you find that the table has not been shrunk. What could have been the reason for this？（）
The tablespace that contains the TRANS table is online.
The tablespace that contains the TRANS table is permanent.
The tablespace that contains the TRANS table is locally managed.
The segment space management of the tablespace that contains the TRANS table is manual in nature.
单选题
You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）
loss of one of the tablespaces
loss of a system data file
loss of one of the control files
loss of a tempfile
loss of the only member of an unarchived redo log group
loss of a member from each redo log group
单选题
An RMAN backup job fails， displaying the following error message： ORA/x7f19809： limit exceeded for recovery files Your analysis shows that the Flash Recovery area is full. What would you do to resolve the error？（）
increase the value of UNDO_RETENTION
change the value of WORKAREA_SIZE_POLICY to AUTO
increase the value of DB_RECOVERY_FILE_DEST_SIZE
increase the value of CONTROL_FILE_RECORD_KEEP_TIME
单选题
You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup？（）
online redo log files
alert log files
control file
datafiles associated with the SYSTEM tablespace
单选题
You have configured the flash recovery area to store online redo log files， control files， archived redo logs and RMAN backups. Which of the following files can you successfully delete from the flash recovery area if you want to reclaim the space within it？（）
multiplexed control files
RMAN obsolete backups
multiplexed online redo log files
archived redo logs that have not been copied to tape
单选题
You are designing an application for a telecom company and you have been asked to design a database table to facilitate monthly bill generation. The bill would include details of customer calls， listed in chronological order. Which method would you follow to achieve this objective without increasing the overhead of sorting the rows？（）
create a hash cluster to store the data
create an index cluster to store the data
create a partitioned table to store the data
create a sorted hash cluster to store the data
create a heap table with rowid to store the data
单选题
You are maintaining an OLTP database in Oracle10g. You find that the database is generating a large number of trace files. You decide to disable the trace files generated by the ARCn background process. Which action will enable you to disable the trace files generated by the ARCn background process？（）
Remove the LOG_ARCHIVE_DEST parameter from the init.ora file.
Set the value of the SQL_TRACE parameter to FALSE in the init.ora file.
Use the DBMS_MONITOR.SESSION_TRACE_DISABLE procedure.
Set the value of the LOG_ARCHIVE_TRACE initialization parameter to zero.
单选题
You executed the following query： SELECT operation， undo_sql， table_name FROM flashback_transaction_query； Which statement is correct regarding the query output？（）
It would return information regarding only the last committed transaction.
It would return only the active transactions in all the undo segments in the database.
It would return only the committed transactions in all the undo segments in the database.
It would return both active and committed transactions in all the undo segments in the database.
It would return information regarding the transactions that began and were committed in the last 30 minutes.
单选题
In which scenario do you use the Flashback Database feature？（）
when a table is dropped and you restore it from the Recycle Bin
when a user’s schema is dropped and you recover the user’s schema
when some incorrect data is inserted in the table and you retrieve the table to a state that was at a certain timestamp
when a row of a table is updated frequently and committed， and you view all the versions of the row within a specific duration
推荐考题
-
在任何情况下，伸缩调节器处轨距的要求为（）。
-
人类有两套影响学习的记忆系统：陈述性记忆和程序记忆。陈述性记忆是对事实或者词汇之类基本认识的记忆。而程序记忆，就是一个人“不劳而获”的记忆。程序记忆是人养成习惯和习得技巧的方式，比如骑自行车。在很多时候，这种学习是无意识的。人们用早期发育的程序记忆系统来学习复杂的东西，比如语法规则。帮助人们学习词汇的陈述性记忆系统，则需要更多时问完成发育。儿童拥有程序记忆系统，并且不受陈述性记忆系统的干扰。由此可以推出()。
-
宋末元初四大家
-
公平目标的实现可以通过（）实现。
-
荟萃分析
-
人员安全疏散分析的性能判定标准为：可用疏散时间（A.SET）必须（）必需疏散时间（RSET）。
-
预防HIV感染的主要措施应当为（ ）
-
简述我国混合型债券市场的发展状况。
-
造成水中某些污染物在生物体内含量大大高于水体中的浓度的生物放大作用是指（）
-
输血的适应证中，不包括（）