单选题
You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance， you plan to move the data from the flat files to clustered tables in an Oracle database.While migrating the data， you want to have minimal impact on the database performance and optimize the dataload operation. Which method would you use to load data into the Oracle database（）
Use the external table population.
Use the Oracle Data Pump export and import utility.
Use the conventional path data load of the SQL*Loader utility.
Use the INSERT INTO...SELECT command to load the data
单选题
For which database operation would you need the database to be in the MOUNT state（）
renaming the control files
re-creating the control files
dropping a user in your database
dropping a tablespace in your database
configuring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes
单选题
The job to gather optimizer statistics for objects runs as part of the automatic maintenance window in yourdatabase instance. At a certain point of time， the maintenance window closes before the statistics are gatheredfor all objects. Which statement is true in this scenario（）
The statistics collection continues until all objects are processed.
The job is terminated and the statistics collected are restored to a time before the job started.
This produces an error and the statistics collected are locked until the next time that the maintenancewindow is opened.
The job is terminated and the statistics for the remaining objects are collected the next time that themaintenance window is opened
单选题
Which statement is true about the UNDO_RETENTION parameter when retention guarantee is notenabled（）
It is the time period after which the undo data becomes obsolete.
It is the time period after which the committed undo data would be transferred to a temporarytablespace.
It is the minimum time period up to which the committed undo data would be retained if free undo spaceis available.
It is the time period after which the undo data is transferred to the Flash Recovery Area to provide readconsistency.
多选题
You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode. Which two statements are true in this scenario（）
You must shut down the database instance to perform the backups.
You must configure the Flash Recovery Area （FRA） for the database.
You can perform complete database backups without closing the database.
All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.
单选题
View the Exhibit and examine the privileges granted to the SL_REP user. The EMP table is owned by theSCOTT user. The SL_REP user executes the following command：SQL> GRANT SELECT ON scott.emp TO hr； Which statement describes the outcome of the command（）
The command executes successfully.
The command produces an error because the EMP table is owned by SCOTT.
The command produces an error because SL_REP has the GRANT ANY OBJECT PRIVILEGE withoutADMIN_OPTION.
The command produces an error because SL_REP does not have the SELECT privilege withGRANT_OPTION on the EMP table
单选题
You want to access employee details contained in flat files as part of the EMPLOYEE table. You planto add a new column to the EMPLOYEE table to achieve this. Which data type would you use for the new column（）
CLOB
BLOB
BFILE
LONG RAW
单选题
The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on theprocedure to many database users： CREATE OR REPLACE PROCEDURE create_dept （ v_deptno NUMBER， v_dname VARCHAR2， v_mgr NUMBER， v_loc NUMBER） BEGIN INSERT INTO hr.departments VALUES （v_deptno， v_dname， v_mgr， v_loc）； END； The users having permission to execute the procedure are able to insert records into the DEPARTMENTStable even though they do not have the INSERT privilege on the table. You want only those users whohave privileges on the DEPARTMENTS table to be able to execute the procedure successfully. What would you suggest to the PL/SQL developers to achieve this（）
Create the procedure with definer’s right.
Create the procedure with invoker’s right.
Grant the EXECUTE privilege with GRANT OPTION on the procedure to selected users.
Create the procedure as part of a PL/SQL package and grant the EXECUTE privilege on the package to selected users
多选题
Which two statements are true about standard database auditing（）
DDL statements can be audited.
Statements that refer to stand-alone procedure can be audited.
Operations by the users logged on as SYSDBA cannot be audited.
Only one audit record is ever created for a session per audited statement even though it is executedmore than once.
多选题
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 ename FROM emp 2 WHERE job=’CLERK’ FOR UPDATE OF empno； SCOTT has opened another session to work with the database instance. Which three operations wouldwait when issued in SCOTT’s second session（）
LOCK TABLE emp IN SHARE MODE；
LOCK TABLE emp IN EXCLUSIVE MODE；
UPDATE emp SET sal=sal*1.2 WHERE job=MANAGER；
INSERT INTO emp（empno，ename） VALUES （1289，’Harry’）；
SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno；
推荐考题
-
在任何情况下，伸缩调节器处轨距的要求为（）。
-
人类有两套影响学习的记忆系统：陈述性记忆和程序记忆。陈述性记忆是对事实或者词汇之类基本认识的记忆。而程序记忆，就是一个人“不劳而获”的记忆。程序记忆是人养成习惯和习得技巧的方式，比如骑自行车。在很多时候，这种学习是无意识的。人们用早期发育的程序记忆系统来学习复杂的东西，比如语法规则。帮助人们学习词汇的陈述性记忆系统，则需要更多时问完成发育。儿童拥有程序记忆系统，并且不受陈述性记忆系统的干扰。由此可以推出()。
-
宋末元初四大家
-
公平目标的实现可以通过（）实现。
-
荟萃分析
-
人员安全疏散分析的性能判定标准为：可用疏散时间（A.SET）必须（）必需疏散时间（RSET）。
-
预防HIV感染的主要措施应当为（ ）
-
简述我国混合型债券市场的发展状况。
-
造成水中某些污染物在生物体内含量大大高于水体中的浓度的生物放大作用是指（）
-
输血的适应证中，不包括（）