多选题
Which three actions are required to configure the Flashback Database? （）
set Flash Recovery Area
enable Flashback logging
create FLASHBACK tablespace
start the database in the ARCHIVELOG mode
start the database in the NOARCHIVELOG mode
单选题
Which statement describes the effect of the execution of the above PL/SQL block?（）
The plan baselines are verified with the SQL profiles.
All fixed plan baselines are converted into nonfixed plan baselines.
All the nonaccepted SQL profiles are accepted into the plan baseline.
The nonaccepted plans in the SQL Management Base are verified with the existing plan baselines.
单选题
You issued the following command on the temporary tablespace LMTEMP in your database: SQL>ALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M; Which requirement must be fulfilled for this command to succeed?（）
The tablespace must be locally managed.
The tablespace must have only one temp file.
The tablespace must be made nondefault and offline.
The tablespace can remain as the default but must have no active sort operations.
多选题
On which two database objects can the VERSIONS clause of the Flashback Versions Query be used?（）
fixed tables
heap tables
external tables
temporary tables
Index-Organized Tables (IOTs)
多选题
You are managing an Oracle Database 11g database with the ASM storage. The database is having big file tablespaces. You want files to open faster and less memory to be used in the shared pool to manage the extent maps. What configuration would you effect to achieve your objective? （）
Set the ASM compatibility attribute for the ASM disk group to 11.1.0.
Set the RDBMS compatibility attribute for the ASM disk group to 11.1.0.
Set the COMPATIBLE initialization parameter for the ASM instance to 11.1.0.
Set the COMPATIBLE initialization parameter for the database instance to 11.1.0.
单选题
The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which statement is true while performing a tape backup in an RMAN session?（）
The tape I/O performed is asynchronous
The tape buffer is allocated from the System Global Area (SGA)
The tape buffer is allocated from the Program Global Area (PGA)
Oracle I/O uses an interrupt mechanism to determine when each I/O completes
多选题
Which three statements are true about persistent configuration?（）
A user cannot set privileges on the persistent lightweight jobs
Persistent lightweight jobs generate a large amount of metadata
It is possible to create fully self-contained persistent lightweight jobs
The use of a template is mandatory to create persistent lightweight jobs
Persistent lightweight jobs are useful when users need to create a large number of jobs in a short time
单选题
You are in the process of creating a virtual private catalog in your Oracle Database 11g database. The PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The database user who owns the base recovery catalog is CATOWNER. CATOWNER executes the following command to grant privileges to a new user VPC1 using Oracle Database 11g RMAN executables:
What is the outcome of the above commands?（）
They execute and create a virtual catalog for pre-Oracle 11g clients.
They produce an error because PROD1 and PROD2 databases belong to the older version.
They produce an error because you need to connect as CATOWNER to execute this packaged procedure.
They produce an error because you need to connect to the target database to execute this packaged procedure.
多选题
Which two statements regarding a SQL profile are true?（）
It is built by Automatic Tuning Optimizer.
It cannot be stored persistently in the data dictionary.
It can be used by the query optimizer automatically.
It can be created manually by using the CREATE PROFILE command.
单选题
Which of the following datatypes store time-zone information in the database?（）
TIMESTAMP
DATE
TIMESTAMP WITH TIME ZONE
TIMESTAMP WITH LOCAL TIME ZONE
DATETIME
推荐考题
-
在任何情况下，伸缩调节器处轨距的要求为（）。
-
人类有两套影响学习的记忆系统：陈述性记忆和程序记忆。陈述性记忆是对事实或者词汇之类基本认识的记忆。而程序记忆，就是一个人“不劳而获”的记忆。程序记忆是人养成习惯和习得技巧的方式，比如骑自行车。在很多时候，这种学习是无意识的。人们用早期发育的程序记忆系统来学习复杂的东西，比如语法规则。帮助人们学习词汇的陈述性记忆系统，则需要更多时问完成发育。儿童拥有程序记忆系统，并且不受陈述性记忆系统的干扰。由此可以推出()。
-
宋末元初四大家
-
公平目标的实现可以通过（）实现。
-
荟萃分析
-
人员安全疏散分析的性能判定标准为：可用疏散时间（A.SET）必须（）必需疏散时间（RSET）。
-
预防HIV感染的主要措施应当为（ ）
-
简述我国混合型债券市场的发展状况。
-
造成水中某些污染物在生物体内含量大大高于水体中的浓度的生物放大作用是指（）
-
输血的适应证中，不包括（）