单选题
You are creating tablespaces in Oracle. Which of the following keywords or clauses permits the datafiles of a database to grow automatically in order to accommodate data growth?（）
DEFAULT STORAGE
EXTENT MANAGEMENT
AUTOEXTEND
DATAFILE
单选题
You are about to create your Oracle data dictionary for use with the database. Which of the following users would you connect to the database as for this purpose in Oracle9i and later releases?（）
SYSTEM
OUTLN
INTERNAL
SYS
单选题
You are managing the Oracle database. Which of the following choices correctly identifies when Oracle reads the contents of the init.ora file?（）
When the instance is started
When the database is mounted
When the database is opened
When the database is closed
单选题
Which component of the SGA stores parsed SQL statements is used for process sharing?（）
Buffer cache
Redo log buffer
Private SQL area
Library cache
Row cache
单选题
You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?（）
One tablespace has only one datafile
Many tablespaces can share one datafile
One tablespace can have many datafiles
One datafile can contain many tablespaces
单选题
Flushing dirty buffers out of the buffer cache is influenced to the greatest extent by which of the following process?（）
ARCH
SMON
LGWR
SERVER
单选题
Which of the following choices correctly describes the difference between a data load via the conventional path and the direct path?（）
One runs faster than the other
A conventional path data load bypasses most of the Oracle RDBMS, whereas a direct path load is a high-speed version of the SQL INSERT
A direct path data load bypasses most of the Oracle RDBMS, whereas a conventional path load is a high-speed version of the SQL INSERT
The conventional path runs when the CONVENTIONAL command-line parameter is set to TRUE
单选题
Which of the following datatypes are used in situations where you want an ordered set of data elements, where every element is the same datatype, and where you predefine the number of elements that appear in the set?（）
REF
TABLE
CLOB
VARRAY
单选题
When an UNDO segment is created manually by you, its availability status is set to which of the following automatically by Oracle?（）
Online
Pending online
Offline
Stale
单选题
You are defining areas on your Oracle database. Which of the following profile areas can be used to control the resource usage for the other four?（）
LOGICAL_READS_PER_SESSION
CONNECT_TIME
COMPOSITE_LIMIT
CPU_PER_SESSION
PRIVATE_SGA
推荐考题
-
在任何情况下，伸缩调节器处轨距的要求为（）。
-
人类有两套影响学习的记忆系统：陈述性记忆和程序记忆。陈述性记忆是对事实或者词汇之类基本认识的记忆。而程序记忆，就是一个人“不劳而获”的记忆。程序记忆是人养成习惯和习得技巧的方式，比如骑自行车。在很多时候，这种学习是无意识的。人们用早期发育的程序记忆系统来学习复杂的东西，比如语法规则。帮助人们学习词汇的陈述性记忆系统，则需要更多时问完成发育。儿童拥有程序记忆系统，并且不受陈述性记忆系统的干扰。由此可以推出()。
-
宋末元初四大家
-
公平目标的实现可以通过（）实现。
-
荟萃分析
-
人员安全疏散分析的性能判定标准为：可用疏散时间（A.SET）必须（）必需疏散时间（RSET）。
-
预防HIV感染的主要措施应当为（ ）
-
简述我国混合型债券市场的发展状况。
-
造成水中某些污染物在生物体内含量大大高于水体中的浓度的生物放大作用是指（）
-
输血的适应证中，不包括（）