单选题
You are administering a database stored in Automatic Storage management (ASM). The files are storedin the DATA disk group. You execute the following command:SQL > ALTER DISKGROUP data ADD ALIAS ‘+data/prod/myfile.dbf’ FOR ‘+data.231.45678’;What is the result?（）
The file ‘+data.231.54769’ is physically relocated to ‘+data/prod’ and renamed as ‘myfile.dbf’.
The file ‘+data.231.54769’ is renamed as ‘myfile.dbf’, and copied to ‘+data/prod’.
The file ‘+data.231.54769’ remains in the same location and a synonym 'myfile.dbf' is created.
The file ‘myfile.dbf’ is created in ‘+data/prod’ and the reference to ‘+data.231.54769’ in the data dictionary removed.
多选题
Which two statements are true about variable extent size support for large ASM files?（）
The metadata used to track extents in SGA is reduced.
Rebalance operations are completed faster than with a fixed extent size
An ASM Instance automatically allocates an appropriate extent size.
Resync operations are completed faster when a disk comes online after being taken offline.
Performance improves in a stretch cluster configuration by reading from a local copy of an extent.
多选题
Which two statements are true about the RMAN validate database command?（）
It checks the database for intrablock corruptions.
It can detect corrupt pfiles.
It can detect corrupt spfiles.
It checks the database for interblock corruptions.
It can detect corrupt block change tracking files.
单选题
You are connected to a pluggable database (PDB) as a common user with DBA privileges. The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following: SQL > ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = ‘*’ SCOPE = SPFILE; Which is true about the result of this command?（）
The STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened.
The STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened.
The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarted.
Nothing happens; because there is no SPFILE for each PDB, the statement is ignored.
多选题
The persistent configuration settings for RMAN have default for all parameters.Identify four RMAN commands that produce a multi-section backup.（）
BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;
BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;
BACKUP ARCHIVELOG ALL SECTION SIZE 25M;
BACKUP TABLESPACE TEMP SECTION SIZE 10M;
BACKUP TABLESPACE UNDO INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M;
BACKUP SPFILE SECTION SIZE 1M;
BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;
多选题
Examine the contents of SQL loader control file: Which three statements are true regarding the SQL* Loader operation performed using the control file?（）
An EMP table is created if a table does not exist. Otherwise, if the EMP table is appended with the loaded data.
The SQL* Loader data file myfile1.dat has the column names for the EMP table.
The SQL* Loader operation fails because no record terminators are specified.
Field names should be the first line in the both the SQL* Loader data files.
The SQL* Loader operation assumes that the file must be a stream record format file with the normal carriage return string as the record terminator.
多选题
Which three statements are true about Flashback Database?（）
Flashback logs are written sequentially, and are archived.
Flashback Database uses a restored control file to recover a database.
The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Area.
Flashback Database can recover a database to the state that it was in before a reset logs operation.
Flashback Database can recover a data file that was dropped during the span of time of the flashback.
Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.
单选题
Your database supports a DSS workload that involves the execution of complex queries: Currently, the library cache contains the ideal workload for analysis. You want to analyze some of the queries for an application that are cached in the library cache. What must you do to receive recommendations about the efficient use of indexes and materialized views to improve query performance?（）
Create a SQL Tuning Set (STS) that contains the queries cached in the library cache and run the SQL Tuning Advisor (STA) on the workload captured in the STS.
Run the Automatic Workload Repository Monitor (ADDM).
Create an STS that contains the queries cached in the library cache and run the SQL Performance Analyzer (SPA) on the workload captured in the STS.
Create an STS that contains the queries cached in the library cache and run the SQL Access Advisor on the workload captured in the STS.
单选题
Which statement is true about Oracle Net Listener?（）
It acts as the listening endpoint for the Oracle database instance for all local and non-local user connections.
A single listener can service only one database instance and multiple remote client connections.
Service registration with the listener is performed by the process monitor (PMON) process of each database instance.
The listener.ora configuration file must be configured with one or more listening protocol addresses to allow remote users to connect to a database instance.
单选题
You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT.You issue the following statements: SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM; SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT; For which database users is the audit policy now active?（）
All users except SYS
All users except SCOTT
All users except sys and SCOTT
All users except sys, system, and SCOTT
推荐考题
-
在任何情况下，伸缩调节器处轨距的要求为（）。
-
人类有两套影响学习的记忆系统：陈述性记忆和程序记忆。陈述性记忆是对事实或者词汇之类基本认识的记忆。而程序记忆，就是一个人“不劳而获”的记忆。程序记忆是人养成习惯和习得技巧的方式，比如骑自行车。在很多时候，这种学习是无意识的。人们用早期发育的程序记忆系统来学习复杂的东西，比如语法规则。帮助人们学习词汇的陈述性记忆系统，则需要更多时问完成发育。儿童拥有程序记忆系统，并且不受陈述性记忆系统的干扰。由此可以推出()。
-
宋末元初四大家
-
公平目标的实现可以通过（）实现。
-
荟萃分析
-
人员安全疏散分析的性能判定标准为：可用疏散时间（A.SET）必须（）必需疏散时间（RSET）。
-
预防HIV感染的主要措施应当为（ ）
-
简述我国混合型债券市场的发展状况。
-
造成水中某些污染物在生物体内含量大大高于水体中的浓度的生物放大作用是指（）
-
输血的适应证中，不包括（）