单选题
Your database is functional with peak load for one hour. You want to preserve the performance statistics collected during this period so that they can be used for comparison while analyzing the performance of the database in the future. What action would you take to achieve this task？（）
Set the STATISTICS_LEVEL initialization parameter to ALL.
Create a baseline on a pair of snapshots that have the statistics of the peakload period in the database.
Decrease the snapshot interval in the AWR to collect more number of snapshots during the peakload period.
Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid theautomatic purging of the snapshots.
单选题
You want to move all the objects of the APPS user in the test database to the DB_USER schema of the production database. Which option of IMPDP would you use to accomplish this task？（）
FULL
SCHEMAS
REMAP_SCHEMA
REMAP_DATAFILES
REMAP_TABLESPACE
单选题
You have to shut down the database instance with the ABORT option because of a hardware failure. Which statement is true about the subsequent opening of the database？（）
The database would open normally.
The database would not open， and it would stop at mount stage.
The database would open after automatically performing instance recovery.
The database would not open， and you have to perform database recovery to open it.
多选题
User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK，or any data definition language （DDL） command： SQL> SELECT job FROM emp 2 WHERE job=’CLERK’ FOR UPDATE OF empno; SCOTT has opened another session to work with the database. Which three operations would wait when issued in SCOTT’s second session？（）
LOCK TABLE emp IN SHARE MODE;
LOCK TABLE emp IN EXCLUSIVE MODE;
DELETE FROM emp WHERE job=’MANAGER’;
INSERT INTO emp（empno，ename） VALUES （1289，’Dick’）;
SELECT job FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno;
单选题
The customer and order tables are often used in joins， thereby resulting in complex queries. You created views to simplify the writing of queries. These views are stored in（）.
user tables
view segment
table segment
data dictionary
object segment
performance tables
多选题
A user wants to connect to the database instance from an application that is running on a remote machine. Which tools should the DBA use to establish the required configuration to ensure that the user is able to connect to the database instance？（）
Data Pump
Oracle Net Manager
Oracle Enterprise Manager
Oracle Universal Installer （OUI）
Database Configuration Assistant （DBCA）
单选题
Your tnsnames.ora file has the following entry for the service alias ORCL： ORCL = （DESCRIPTION = （ADDRESS = （PROTOCOL = TCP） （HOST = 10.156.24.216） （PORT = 1521）） （CONNECT_DATA = （SERVER = DEDICATED） （SERVICE_NAME = orcl.oracle.com） ） ） The TNSPING command executes successfully when tested with ORCL but you are not able to connect to the database instance with the following command： SQL> CONNECT scott/tiger@orcl What could be the reason for this？（）
The listener is not running at the server.
The TNS_ADMIN environmental variable is set to a wrong value.
The orcl.oracle.com database service is not registered with the listener.
The DEFAULT_DOMAIN parameter is set to a wrong value in the SQLNET.ORA file.
单选题
You work as a database administrator for Supportcenter.cn. Users in the Supportcenter.cn PROD database complain about the slow response of transactions. While investigating the reason you find that the transactions are waiting for the undo segments to be available， and undo retention has been set to zero. What would you do to overcome this problem？（）
Increase the undo return
Create more undo segments
Create another undotablespace
Increase the size of the undo tablespace
单选题
You work as a database administrator for Supportcenter.cn. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case？（）
Hot backup
Online backup
consistent backup
incremental backup
inconsistent backup
单选题
You have two databases， FINDB and PAYDB， on single operating system and using Optimal Flexible architecture （OFA）. FINDB is functional and is currently being accessed by the users. While starting up the instance for the PAYDB database you get the following error： ORA-01081： cannot start - already running ORACLE - shut it down first Which environmental variable would you set before starting up the PAYDB database to overcome this error？（）
ORA_PATH
ORACLE_SID
ORACLE_BASE
ORACLE_HOME
LD_LIBRARY_PATH
推荐考题
-
在任何情况下，伸缩调节器处轨距的要求为（）。
-
人类有两套影响学习的记忆系统：陈述性记忆和程序记忆。陈述性记忆是对事实或者词汇之类基本认识的记忆。而程序记忆，就是一个人“不劳而获”的记忆。程序记忆是人养成习惯和习得技巧的方式，比如骑自行车。在很多时候，这种学习是无意识的。人们用早期发育的程序记忆系统来学习复杂的东西，比如语法规则。帮助人们学习词汇的陈述性记忆系统，则需要更多时问完成发育。儿童拥有程序记忆系统，并且不受陈述性记忆系统的干扰。由此可以推出()。
-
宋末元初四大家
-
公平目标的实现可以通过（）实现。
-
荟萃分析
-
人员安全疏散分析的性能判定标准为：可用疏散时间（A.SET）必须（）必需疏散时间（RSET）。
-
预防HIV感染的主要措施应当为（ ）
-
简述我国混合型债券市场的发展状况。
-
造成水中某些污染物在生物体内含量大大高于水体中的浓度的生物放大作用是指（）
-
输血的适应证中，不包括（）