单选题
You are attempting to clear an unarchived redo log file. In order to manually enact a log switch, which of the following statements is appropriate?（）
ALTER DATABASE
ALTER SYSTEM
ALTER USER
ALTER REDO LOG
单选题
In order to find out how many database objects a user has created, which view would the DBA query in the Oracle data dictionary? （）
DBA_USERS
DBA_OBJECTS
DBA_TS_QUOTAS
DBA_TAB_PRIVS
单选题
You are configuring your index to be stored in a tablespace. Which of the following storage parameters are NOT appropriate for indexes?（）
OPTIMAL
INITIAL
PCTINCREASE
NEXT
单选题
You are using the Database Configuration Assistant to configure your Oracle database. Which of the following terms pertains to the creation of an object from which creation of the other database can be based? （）
Clone
Copy
Template
Terminal
单选题
In a situation where no multiplexing of redo logs takes place, what happens when Oracle cannot read data from the online redo log group for archiving?（）
Nothing happens
Oracle will automatically switch redo logs when detected
Oracle eventually won't allow new records to be added to the database
The instance crashes
单选题
A table was just created on your Oracle database with six extents allocated to it. Which of the following factors most likely caused the table to have so many extents allocated?（）
The value for MINEXTENTS setting
The value for PCTINCREASE setting
The value for MAXEXTENTS setting
By default, Oracle allocates six extents to all database objects
单选题
The user is trying to execute a SELECT statement. Which of the following background processes will obtain data from a disk for the user?（）
DISPATCHER
USER
SERVER
LGWR
DBW0
单选题
You just issued the following statement: ALTER TABLE SALES DROP COLUMN PROFIT. Which of the following choices identifies when the column will actually be removed from Oracle?（）
Immediately following statement execution
After the ALTER TABLE DROP UNUSED COLUMNS command is issued
After the ALTER TABLE SET UNUSED COLUMN command is issued
After the ALTER TABLE MODIFY command is issued
单选题
When determining the number of UNDO segments in a database, which of the following choices identifies a factor to consider? （）
Size of typical transactions
Concurrent transactions
Size of rows in table most frequently changed
Number of anticipated disk sorts
单选题
The rows inside three Oracle tables supporting a customer order entry system are frequently accessed together by means of a table join. Because data is always being added to the tables, you leave a lot of extra space inside each block to accommodate growth. Which of the following types of tables would be useful for storing the data in this context?（）
Temporary tables
Index-organized tables
Cluster tables
Standard Oracle tables
推荐考题
-
在任何情况下，伸缩调节器处轨距的要求为（）。
-
人类有两套影响学习的记忆系统：陈述性记忆和程序记忆。陈述性记忆是对事实或者词汇之类基本认识的记忆。而程序记忆，就是一个人“不劳而获”的记忆。程序记忆是人养成习惯和习得技巧的方式，比如骑自行车。在很多时候，这种学习是无意识的。人们用早期发育的程序记忆系统来学习复杂的东西，比如语法规则。帮助人们学习词汇的陈述性记忆系统，则需要更多时问完成发育。儿童拥有程序记忆系统，并且不受陈述性记忆系统的干扰。由此可以推出()。
-
宋末元初四大家
-
公平目标的实现可以通过（）实现。
-
荟萃分析
-
人员安全疏散分析的性能判定标准为：可用疏散时间（A.SET）必须（）必需疏散时间（RSET）。
-
预防HIV感染的主要措施应当为（ ）
-
简述我国混合型债券市场的发展状况。
-
造成水中某些污染物在生物体内含量大大高于水体中的浓度的生物放大作用是指（）
-
输血的适应证中，不包括（）