多选题You want to migrate your existing non-ASM files to ASM files for the database PROD. Which method  or command would you use to accomplish this task？（）Athe CONVERT command of RMANBData Pump Export and Import into the same databaseCconventional export and

第1题：

n your production database you want to use an Automatic Storage Management （ASM） instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance？（）

• A、 Oracle Migration Assistant
• B、 Recovery Manager （RMAN）
• C、 Oracle Data Pump Export and Import
• D、 conventional Oracle Export and Import
• E、 operating system utilities to copy the files to the ASM instance

第2题：

You want to convert your existing non-ASM files to ASM files for the database PROD.  Which method or command would you use to accomplish this task？（）  

• A、 Data Pump Export and Import
• B、 conventional export and import
• C、 the CONVERT command of RMAN
• D、 the BACKUP AS COPY. command of RMAN

第3题：

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

第4题：

You are using flat files as the data source for one of your data warehousing applications. To optimizethe application performance， you plan to move the data from the flat files toclustered tablesin an Oracle database.  While migrating the data， you want to have minimal impact on the database performance and optimize thedata load 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.

第5题：

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

第6题：

You want to create a new optimized database for your transactional production environment to be used by a financial application. While creating the database， you want the Oracle software to take care of all basic settings to optimize the database performance. Which method would you use to achieve this objective？（）

• A、Use the CREATE DATABASE .. command to create the database with Oracle-managed files. 
• B、Use the Database Configuration Assistant (DBCA) to create the database with Oracle-managed files. 
• C、Use Enterprise Manager to create a new database with the Online Transaction Processing (OLTP) option. 
• D、Use Database Configuration Assistant (DBCA) to create the database with Transaction Processing template. 
• E、Use the CREATE DATABASE .. command to create the database with Automatic Storage Management (ASM) file system.

第7题：

In your production database you want to use an Automatic Storage Management （ASM） instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance？（）

• A、Oracle Migration Assistant
• B、Recovery Manager （RMAN）
• C、Oracle Data Pump Export and Import
• D、conventional Oracle Export and Import
• E、operating system utilities to copy the files to the ASM instance

第8题：

You have received a default route through BGP from your ISP and you want to redistribute it into OSPF.Which method will accomplish this?（）

• A、Apply an export policy to OSPF that exports the default route
• B、Apply an import policy to OSPF that imports the default route
• C、Apply the default-network command to OSPF
• D、Apply the redistribute-igp command to BGP

第9题：

You have an Automatic Storage Management （ASM） instance managing the database files of your production database. The database contains ASM files and non-ASM files. Using Recovery Manager （RMAN）， you migrate the complete production database to use the ASM instance. Which statement is true？ （）

• A、 RMAN would relocate all the data files to an ASM disk group and other files to an operating system location， defined using Oracle Managed Files （OMF）.
• B、 RMAN would relocate the ASM files to an ASM disk group and the non-ASM files to an operating system location， defined using OMF
• C、 RMAN would relocate all the database files to an ASM disk group.
• D、 RMAN would change the file definitions in the control file to use the ASM but would not relocate the database files physically.

第10题：

In your production database you want to use an Automatic Storage Management （ASM） instance to manage the database files.  Which option would you use to migrate the database files from a non/x7fASM instance to an ASM instance？（）

• A、Oracle Migration Assistant
• B、Recovery Manager （RMAN）
• C、Oracle Data Pump Export and Import
• D、conventional Oracle Export and Import
• E、operating system utilities to copy the files to the ASM instance