You are managing an Oracle Data

第1题：

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（）

• A、Use the external table population.
• B、Use the Oracle Data Pump export and import utility.
• C、Use the conventional path data load of the SQL*Loader utility.
• D、Use the INSERT INTO...SELECT command to load the data

第2题：

You can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback？（）

• A、Oracle Flashback uses undo information to construct consistent data. 
• B、You can use a cursor opened while using an Oracle Flashback image to perform DML once you deactivate Oracle Flashback in your session. 
• C、You can only use Oracle Flashback view of the data if the required records are still in the online redo log files. 
• D、Oracle Flashback lists the DML that was executed during the period you identify when initiating your session. 

第3题：

第4题：

You issue the following statement：   SQL> SELECT FIRSTNAME， LASTNAME FROM HR.EMPLOYEE；  You receive the following error：         01578： ORACLE data block corrupted （file# 6， block # 54）        ORA-01110 ： data file 6： ’u01/oracle/oradata/data1.dbf’   How will you resolve this problem of data block corruption by reducing the mean time to recover （MTTR）？（）

• A、 by using the DBMS_REPAIR package
• B、 by using the DBVERIFY utility
• C、 by using Block Media Recovery
• D、 by issuing the ANALYZE TABLE HR.EMPLOYEES VALIDATE STRUCTURE command

第5题：

You want to estimate the size of a table by using the Oracle Enterprise Manager.  On which data is the size of the table NOT based？（）

• A、 column sizes
• B、 column data types
• C、 PCTFREE
• D、 projected number of row
• E、 PCTUSED

第6题：

Which  statements are true regarding the Oracle Data Pump export and import operations（）

• A、You cannot export data from a remote database.
• B、You can rename tables during an import operation.
• C、You can overwrite existing dump files during an export operation.
• D、You can compress the data during export but not the metadata because it is not supported

第7题：

Which three statements are true about Oracle Data Pump export and import operations?（）

• A、You can detach from a data pump export job and reattach later.
• B、Data pump uses parallel execution server processes to implement parallel import.
• C、Data pump import requires the import file to be in a directory owned by the oracle owner.
• D、The master table is the last object to be exported by the data pump.
• E、You can detach from a data pump import job and reattach later.

第8题：

第9题：

You are using Oracle Enterprise Manager to estimate the size of a table to be created. You have typed data regarding the column names， data types， sizes of the columns， and the projected number of rows in the table. Which additional information does the Oracle Enterprise Manager return？（）

• A、 space allocated in the tablespace
• B、 space required for the bitmap index on a column of the table
• C、 space remaining in the tablespace after creating the table
• D、 estimated value of the PCTFREE storage parameter

第10题：

Which two statements are true regarding the Oracle Data Pump export and import operations（）

• A、You cannot export data from a remote database.
• B、You can rename tables during an import operation.
• C、You can overwrite existing dump files during an export operation.
• D、You can compress the data during export but not the metadata because it is not supported.