多选题
Identify the channel settings that can be performed using the CONFIGURE CHANNEL or ALLOCATECHANNEL commands in RMAN（） (choose all that apply)
Limiting the input/output (I/O) bandwidth consumption
Specifying the size of backup sets and backup pieces
Specifying vendor-specific information for a media manager
Specifying the parallelism for backup and restore operations
单选题
Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query: SQL> SELECT * FROM sales; Which process would retrieve the result from the database and return it to the client program?（）
User process
Server process
System Monitor (SMON)
Process Monitor (PMON)
Checkpoint process (CKPT)
多选题
Which two statements are true regarding an Automatic Storage Management （ASM） instance？（）
As ASM instance mounts an ASM control file
An ASM instance uses the ASMB process for rebalancing of disks within a disk group
Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitly
An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started
单选题
Which is not a valid way of backing up a control file？（）
Backing up the control file to trace
Copying the existing control file of the database to the backup location during a hot backup
Copying the existing control file of the database to the backup location during a cold backup
Creating a backup control file
Using the create controlfile command
单选题
By setting the value of MEMORY_TARGET to zero and setting the value of SGA_TARGET to a nonzero value， you will enable which of the following memory-management options？（）
Automatic PGA Memory Management
Automatic SGA Memory Management
Automatic Shared Memory Management
Automatic Memory Management
Manual SGA Memory Management
None of the above
单选题
Within a resource-plan definition， what differentiates a top-level plan from a subplan？（）
A subplan has the PLAN_SUB parameter value set to SUB
A top-level plan has the GROUP_OR_PLAN parameter set to the name of the subplan in the resource-plan definition
There is no difference in the resource-plan definition
A subplan always has the CPU_MTH parameter value set to RATIO
The string TOP_LEVEL is appended to the name of top-level resource plans
单选题
Your database is in NOARCHIVELOG mode. You start to do a backup， but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you？（）
Put the database in hot backup mode and perform an online backup，including backing up the archived redo logs.
Just back up the database datafiles without shutting down the database.
You will have to wait until you can shut down the database to perform the backup.
Mark each datafile as backup in progress， back them up individually，and then mark them as backup not in progress. No archived redo logs will need to be backed up.
Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing，you can shut down the database and back up the datafiles the user changed during the course of the remaining backup
单选题
You want to put a specific tablespace called MY_DATA in hot backup mode so you can back it up. What command would you use？（）
alter tablespace MY_DATA begin backup
alter tablespace MY_DATA start backup
alter tablespace MY_DATA backup begin
alter MY_DATA begin backup
You cannot back up individual tablespaces
多选题
You want to perform an RMAN backup of database as a copy. Which two factors will you consider whileperforming the backup operation?（） (Choose two).
The backup as copy can only be taken to disk
The backup as copy can only be taken to tape
Backup can be performed only when the instance is shutdown
Backup will constitute all used and unused blocks in the database
推荐考题
-
在任何情况下，伸缩调节器处轨距的要求为（）。
-
人类有两套影响学习的记忆系统：陈述性记忆和程序记忆。陈述性记忆是对事实或者词汇之类基本认识的记忆。而程序记忆，就是一个人“不劳而获”的记忆。程序记忆是人养成习惯和习得技巧的方式，比如骑自行车。在很多时候，这种学习是无意识的。人们用早期发育的程序记忆系统来学习复杂的东西，比如语法规则。帮助人们学习词汇的陈述性记忆系统，则需要更多时问完成发育。儿童拥有程序记忆系统，并且不受陈述性记忆系统的干扰。由此可以推出()。
-
宋末元初四大家
-
公平目标的实现可以通过（）实现。
-
荟萃分析
-
人员安全疏散分析的性能判定标准为：可用疏散时间（A.SET）必须（）必需疏散时间（RSET）。
-
预防HIV感染的主要措施应当为（ ）
-
简述我国混合型债券市场的发展状况。
-
造成水中某些污染物在生物体内含量大大高于水体中的浓度的生物放大作用是指（）
-
输血的适应证中，不包括（）