Oracle认证考试
You want to migrate your existing non/x7fASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task？（）A、the CONVERT command of RMANB、Data Pump Export and Import into the same databaseC、conventional export a
题目
You want to migrate your existing non/x7fASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task？（）
- A、the CONVERT command of RMAN
- B、Data Pump Export and Import into the same database
- C、conventional export and import into the same database
- D、the BACKUP DATABASE and RESTORE DATABASE commands of RMAN
- E、the BACKUP AS COPY DATABASE and SWITCH DATABASE TO COPY command of RMAN
参考答案和解析
相似问题和答案
第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
正确答案:B
第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
正确答案:D
第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
正确答案:C
第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.
正确答案:C
第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
正确答案:B,C
第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.
正确答案:D
第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
正确答案:B
第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
正确答案:A
第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.
正确答案:C
第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
正确答案:B