多选题
Which two statements regarding the Policy Framework in Enterprise Manager (EM) are correct?（）
Policy violations are prioritized as High, Medium, or Informational by category
Policies can be disabled completely, or flagged as ignored, for the specified target
Policies can be flagged as ignored, but never completely disabled, for the specified target
Policy violations must be corrected, otherwise the database will shut down until corrective action occurs
单选题
You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?（）
The data in the segment will be compacted but the high water mark will not be adjusted
The EMPLOYEES table will be changed to read-only mode during the shrink operation
The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over
The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation
Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation
单选题
You explicitly specified the tablespace usage threshold values while creating a tablespace. You need to revert to the database-wide default tablespace usage threshold values for the tablespace. Which PL/SQL package would you use?（）
DBMS_STATS
DBMS_ALERT
DBMS_SPACE
DBMS_MONITOR
DBMS_SERVER_ALERT
DBMS_SPACE_ADMIN
多选题
Which two statements regarding the FLASHBACK_TRANSACTION_QUERY view are correct?（）
You can find information about only active transactions from the view
You can find information about read only transactions from the view
You require the SELECT ANY TRANSACTION system privilege to access the view
You can find information about both active and committed transactions from the view
You require the SELECT ON FLASHBACK_TRANSACTION_QUERY object privilege to access the view
多选题
Which are the three levels at which the Segment Advisor generates advice?（）
block level
object level
schema level
segment level
tablespace level
推荐考题
-
在任何情况下，伸缩调节器处轨距的要求为（）。
-
人类有两套影响学习的记忆系统：陈述性记忆和程序记忆。陈述性记忆是对事实或者词汇之类基本认识的记忆。而程序记忆，就是一个人“不劳而获”的记忆。程序记忆是人养成习惯和习得技巧的方式，比如骑自行车。在很多时候，这种学习是无意识的。人们用早期发育的程序记忆系统来学习复杂的东西，比如语法规则。帮助人们学习词汇的陈述性记忆系统，则需要更多时问完成发育。儿童拥有程序记忆系统，并且不受陈述性记忆系统的干扰。由此可以推出()。
-
宋末元初四大家
-
公平目标的实现可以通过（）实现。
-
荟萃分析
-
人员安全疏散分析的性能判定标准为：可用疏散时间（A.SET）必须（）必需疏散时间（RSET）。
-
预防HIV感染的主要措施应当为（ ）
-
简述我国混合型债券市场的发展状况。
-
造成水中某些污染物在生物体内含量大大高于水体中的浓度的生物放大作用是指（）
-
输血的适应证中，不包括（）