You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables. While migrating the data， you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database？（）

单项选择题Inyourdatabase，theSTATISTICS_LEVELinitializationparameterissettoBASIC.Whatistheimpactofthissetting？（）

A.The optimizer statistics are collected automatically.
B.Only the timed operating system （OS） statistics and plan execution statistics are collected.
C.The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
D.The snapshots for the Automatic Workload Repository （AWR） are not generated automatically. 
E.Snapshots cannot be collected manually by using DBMS_WORKLOAD_REPOSITORY PACKAGE.

单项选择题Youwanttomonitorandcontroltheresourceusagebysessions.Youwanttobewarnedautomaticallywhenmorethan100sessionsareopenedwithyourdatabase.Whatactionwouldyoutaketoachievethis？（）

A.Use the Database Resource Manager.
B.Set the limits in the profiles used by users.
C.Modify the SESSIONS initialization parameter.
D.Set the warning threshold for the Current Logons Count metric.

多项选择题WhichtwostatementsregardingtheLOGGINGclauseoftheCREATETABLESPACE...statementarecorrect？（）

A.This clause is not valid for a temporary or undo tablespace.
B.If the tablespace is in the NOLOGGING mode，no operation on the tablespace will generate redo.
C.The tablespace will be in the NOLOGGING mode by default，if not specified while creating a tablespace.
D.The tablespace-level logging attribute can be overridden by logging specifications at the table，index， materialized view，materialized view log，and partition levels.

单项选择题WhichtwooperationscanbeflashedbackusingtheFlashbacktechnology？（）

A.DROP USER SMITH；
B.DROP TABLE EMPLOYEES；
C.DROP TABLESPACE USERS；
D.ALTER TABLE SALES_REP DROP PARTITION P1；
E.ALTER TABLE EMPLOYEES DROP COLUMN DESIG_ID；

单项选择题Yourdatabaseishavingtwocontrolfiles，threeredologfilegroupswithtwomembersineachgroup.Failureofwhichfilewouldcauseaninstancetoshutdown？（）

A.any control file
B.any archive log file
C.one of the redo log members
D.loss of the initialization parameter file
E.any data file belonging to the default permanent tablespac