itgle.com

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 AssistantB、 R

题目

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
相似考题

1.Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyzeimpact on the performance of SQL statements.()A. Change in the Oracle Database versionB. Change in your network infrastructureC. Change in the hardware configuration of the database serverD. Migration of database storage from non-ASM to ASM storageE. Database and operating system upgrade

2. You are managing an Oracle Database 11g database with the ASM storage. The database is having big file tablespaces. You want files to open faster and less memory to be used in the shared pool to manage the extent maps.  What configuration would you effect to achieve your objective？（）  A、 Set the ASM compatibility attribute for the ASM disk group to 11.1.0.B、 Set the RDBMS compatibility attribute for the ASM disk group to 11.1.0.C、 Set the COMPATIBLE initialization parameter for the ASM instance to 11.1.0.D、 Set the COMPATIBLE initialization parameter for the database instance to 11.1.0.

3. You are using an Automatic Storage Management （ASM） instance to manage the files of your production database. While studying the parameter file of the ASM instance， you find the following entry：  ASM_DISKSTRING = /devices/*  What could be the reason for this setting？（）A、to enable the ASM instance to identify the alert log fileB、to enable the ASM instance to identify the server parameter fileC、to enable the ASM instance to define the locations for Oracle Managed Files （OMF）D、to enable the ASM instance to identify all disks that can be accessed by it in the /devices directory

4.You work as a database administrator at Certkiller .com. Your production database uses an Automatic Storage Management （ASM） instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）A、 mount the new disk group in the ASM instanceB、 restart the ASM instance and the production database instanceC、 register the new disk groups in the production database instanceD、 restart the ASM instance without restarting the production database instanceE、 include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance

更多“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 AssistantB、 R”相关问题

  • 第1题：

    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

  • 第2题：

    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

  • 第3题：

    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

  • 第4题：

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

    • 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

    正确答案:A,E

  • 第5题：

    You are migrating your production database from non-ASM to ASM storage. You used the RMAN utility to migrate the database from non-ASM to ASM storage. Which type of backup command script will you use for migrating the database from non-ASM to ASM storage？（）

    • A、 BACKUP AS BACKUPSET
    • B、 BACKUP AS COPY
    • C、 BACKUP AS COMPRESSED BACKUPSET
    • D、 BACKUP INCREMENTAL LEVEL n CUMULATIVE

    正确答案:B

  • 第6题：

    You have an Automatic Storage Management （ASM） instance managing the database files of your production database. The database contains ASM files and non/x7fASM 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 database files to an ASM disk group.
    • B、RMAN would change the file definitions in the control file to use the ASM but would not relocate the database files physically.
    • C、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）.
    • D、RMAN would relocate the ASM files to an ASM disk group and the non­ASM files to an operating system location， defined using OMF

    正确答案:A

  • 第7题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第8题：

    单选题
    You are using an Automatic Storage Management （ASM） instance to manage the files of your production database. While studying the parameter file of the ASM instance， you find the following entry：  ASM_DISKSTRING = /devices/*  What could be the reason for this setting？（）
    A

    to enable the ASM instance to identify the alert log file

    B

    to enable the ASM instance to identify the server parameter file

    C

    to enable the ASM instance to define the locations for Oracle Managed Files （OMF）

    D

    to enable the ASM instance to identify all disks that can be accessed by it in the /devices directory


    正确答案： C
    解析： 暂无解析

  • 第9题：

    单选题
    You have a single Automatic Storage Management （ASM） instance running on the node on which your Oracle Database 10g resides. Which ASM instance initialization parameters must be included in the ASM instance initialization parameter file？（）
    A

     INSTANCE_TYPE

    B

     DB_UNIQUE_NAME

    C

     ASM_DISKSTRING

    D

     ASM_POWER_LIMIT


    正确答案： 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-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


    正确答案： A
    解析： 暂无解析

  • 第11题：

    多选题
    Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyzeimpact on the performance of SQL statements.（）
    A

    Change in the Oracle Database version

    B

    Change in your network infrastructure

    C

    Change in the hardware configuration of the database server

    D

    Migration of database storage from non-ASM to ASM storage

    E

    Database and operating system upgrade


    正确答案： A,E
    解析： 暂无解析

  • 第12题：

    多选题
    You are managing an Oracle Database 11g instance and an Oracle Database 10g instance on the same machine. Both instances use the ASM instance as storage. Which statement regarding the ASM disk group compatibility attributes are true in this scenario？（）
    A

    The database-compatibility version settings for each instance must be greater than or equal to the RDBMS compatibility of all ASM disk groups used by that database instances.

    B

    RDBMS compatibility and the database version determines whether a database instance can mount the ASM disk group.

    C

    The RDBMS compatibility settings for a disk group control the format of data structures for ASM metadata on the disk.

    D

    ASM compatibility controls which features for the ASM will be enabled.


    正确答案： D,B
    解析： 暂无解析

  • 第13题：

    Your production database uses an Automatic Storage Management （ASM） instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）

    • A、mount the new disk group in the ASM instance
    • B、restart the ASM instance and the production database instance
    • C、register the new disk groups in the production database instance
    • D、restart the ASM instance without restarting the production database instance
    • E、include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance

    正确答案:A

  • 第14题：

    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

  • 第15题：

    You have a single Automatic Storage Management （ASM） instance running on the node on which your Oracle Database 10g resides. Which ASM instance initialization parameters must be included in the ASM instance initialization parameter file？（）

    • A、 INSTANCE_TYPE
    • B、 DB_UNIQUE_NAME
    • C、 ASM_DISKSTRING
    • D、 ASM_POWER_LIMIT

    正确答案:A

  • 第16题：

    Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyzeimpact on the performance of SQL statements.（）

    • A、Change in the Oracle Database version
    • B、Change in your network infrastructure
    • C、Change in the hardware configuration of the database server
    • D、Migration of database storage from non-ASM to ASM storage
    • E、Database and operating system upgrade

    正确答案:A,C,E

  • 第17题：

    Your database is configured on non-ASM disk storage. You need to migrate your database to ASM disk storage.  Which statement is true about migrating from non-ASM disk storage to ASM disk storage？（） 

    • A、 You can use the operating system utility to migrate from non-ASM disk storage to ASM disk storage.
    • B、 You cannot perform a database backup from non-ASM disk storage to tape and then move it to ASM disk storage.
    • C、 You can use the SWITCH DATABASE TO COPY Recovery Manager （RMAN） command to switch back to non-ASM disk storage if you have not deleted your original datafiles.
    • D、 You cannot use Recovery Manager （RMAN） to migrate from non-ASM disk storage to ASM disk storage if you are not using RMAN for your backup and recovery strategies.

    正确答案:C

  • 第18题：

    单选题
    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


    正确答案： D
    解析： 暂无解析

  • 第19题：

    多选题
    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？（）
    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


    正确答案： D,A
    解析： 暂无解析

  • 第20题：

    单选题
    Your database is configured on non-ASM disk storage. You need to migrate your database to ASM disk storage.  Which statement is true about migrating from non-ASM disk storage to ASM disk storage？（）
    A

     You can use the operating system utility to migrate from non-ASM disk storage to ASM disk storage.

    B

     You cannot perform a database backup from non-ASM disk storage to tape and then move it to ASM disk storage.

    C

     You can use the SWITCH DATABASE TO COPY Recovery Manager （RMAN） command to switch back to non-ASM disk storage if you have not deleted your original datafiles.

    D

     You cannot use Recovery Manager （RMAN） to migrate from non-ASM disk storage to ASM disk storage if you are not using RMAN for your backup and recovery strategies.


    正确答案： B
    解析： 暂无解析

  • 第21题：

    单选题
    Your production database uses an Automatic Storage Management （ASM） instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）
    A

    mount the new disk group in the ASM instance

    B

    restart the ASM instance and the production database instance

    C

    register the new disk groups in the production database instance

    D

    restart the ASM instance without restarting the production database instance

    E

    include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance


    正确答案： D
    解析： 暂无解析

  • 第22题：

    单选题
    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
    解析： 暂无解析

  • 第23题：

    单选题
    You are migrating your production database from non-ASM to ASM storage. You used the RMAN utility to migrate the database from non-ASM to ASM storage. Which type of backup command script will you use for migrating the database from non-ASM to ASM storage？（）
    A

     BACKUP AS BACKUPSET

    B

     BACKUP AS COPY

    C

     BACKUP AS COMPRESSED BACKUPSET

    D

     BACKUP INCREMENTAL LEVEL n CUMULATIVE


    正确答案： B
    解析： 暂无解析

相关内容