多选题You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server. All databases of all versions use Automatic Storage Management (ASM). Which three statements are true about the ASM disk group compatibility attributes tha

题目
多选题
You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server. All databases of all versions use Automatic Storage Management (ASM). Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group?()
A

The ASM compatibility attribute controls the format of the disk group metadata.

B

RDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group.

C

The RDBMS compatibility setting allows only databases set to the same version as the compatibility value, to mount the ASM disk group.

D

The ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group.

E

The ADVM compatibility attribute determines the ACFS features that may be used by the Oracle 10g database.


相似考题
更多“多选题You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server. All databases of all versions use Automatic Storage Management (ASM). Which three statements are true about the ASM disk group compatibility attributes tha”相关问题
  • 第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题:

    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

  • 第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 plan to use the In Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format. Which three storage options support the use of HCC?()

    • A、ASM disk groups with ASM disks consisting of Exadata Grid Disks.
    • B、ASM disk groups with ASM disks consisting of LUNS on any Storage Area Network array
    • C、ASM disk groups with ASM disks consisting of any zero padded NFS-mounted files
    • D、Database files stored in ZFS and accessed using conventional NFS mounts.
    • E、Database files stored in ZFS and accessed using the Oracle Direct NFS feature
    • F、Database files stored in any file system and accessed using the Oracle Direct NFS feature
    • G、ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays

    正确答案:A,E,G

  • 第5题:

    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

  • 第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 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.


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

  • 第8题:

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

  • 第9题:

    多选题
    You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server. All databases of all versions use Automatic Storage Management (ASM). Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group?()
    A

    The ASM compatibility attribute controls the format of the disk group metadata.

    B

    RDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group.

    C

    The RDBMS compatibility setting allows only databases set to the same version as the compatibility value, to mount the ASM disk group.

    D

    The ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group.

    E

    The ADVM compatibility attribute determines the ACFS features that may be used by the Oracle 10g database.


    正确答案: E,B
    解析: 暂无解析

  • 第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题:

    单选题
    You plan to configure the new Oracle Database 11g installation by performing these tasks: - Use Automatic Storage Management (ASM) as the storage option.  - Use Oracle Enterprise Manager Database Control to manage the database.  - Provide the same password for SYS, SYSTEM, SYSMAN, and DBSNMP accounts during theinstallation. - Configure the database to send email notifications.  Some tools available to you for installation are:  1:Oracle Universal Installer (OUI)  2:Database Configuration Assistant (DBCA)  3:Database Upgrade Assistant (DBUA)  4:Oracle Net Configuration Assistant  Which tools would you use for this installation()
    A

    2

    B

    3

    C

    1 and 2

    D

    3 and 4

    E

    1,2,and 4


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

  • 第12题:

    多选题
    You are managing an Oracle Database 11g ASM instance having three disks in a disk group with ASM compatibility attribute set to 11.1.0 and redundancy set to high. One of the disks in the disk group becomes unavailable because of power failure.  Which statements will be true in this scenario?()
    A

    The disk is immediately dropped from the disk group.

    B

    The ASM tracks the extents that are modified during the outa

    C

    The ASM migrates the extents from the unavailable disk to the remaining disks.

    D

    The disk automatically goes offline.


    正确答案: C,B
    解析: 暂无解析

  • 第13题:

    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

  • 第14题:

    You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server. All databases of all versions use Automatic Storage Management (ASM). Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group?()

    • A、The ASM compatibility attribute controls the format of the disk group metadata.
    • B、RDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group.
    • C、The RDBMS compatibility setting allows only databases set to the same version as the compatibility value, to mount the ASM disk group.
    • D、The ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group.
    • E、The ADVM compatibility attribute determines the ACFS features that may be used by the Oracle 10g database.

    正确答案:A,B,D

  • 第15题:

    Which two statements about Automatic Storage Management (ASM) are true?()

    • A、ASM provides mirroring on file by file basis.
    • B、ASM provides automatic load balancing across all ASM disks.
    • C、ASM supports the Oracle database and operating system files.
    • D、ASM can be used to store trace files, alert log files, and the server parameter file (SPFILE).

    正确答案:A,B

  • 第16题:

    You are managing an Oracle Database 11g ASM instance having three disks in a disk group with ASM compatibility attribute set to 11.1.0 and redundancy set to high. One of the disks in the disk group becomes unavailable because of power failure.  Which statements will be true in this scenario?()

    • A、 The disk is immediately dropped from the disk group.
    • B、 The ASM tracks the extents that are modified during the outa
    • C、 The ASM migrates the extents from the unavailable disk to the remaining disks.
    • D、 The disk automatically goes offline.

    正确答案:B,D

  • 第17题:

    You plan to configure the new Oracle Database 11g installation by performing these tasks: - Use Automatic Storage Management (ASM) as the storage option.  - Use Oracle Enterprise Manager Database Control to manage the database.  - Provide the same password for SYS, SYSTEM, SYSMAN, and DBSNMP accounts during theinstallation. - Configure the database to send email notifications.  Some tools available to you for installation are:  1:Oracle Universal Installer (OUI)  2:Database Configuration Assistant (DBCA)  3:Database Upgrade Assistant (DBUA)  4:Oracle Net Configuration Assistant  Which tools would you use for this installation()

    • A、2
    • B、3
    • C、1 and 2
    • D、3 and 4
    • E、1,2,and 4

    正确答案:E

  • 第18题:

    You are managing an Oracle Database 11g database with ASM storage. The ASM disk group has the COMPATIBLE.ASM attribute set to 11.1.  Which statements are true regarding extent management and allocation units in the ASM disk group?()

    • A、 The au_size disk group attribute determines the size of allocation units in the disk group. 
    • B、 The allocation unit size may vary but the extent size is fixed.
    • C、 The allocation unit size and extent size are fixed for all the disks in a disk group and cannot be changed.
    • D、 Extent management is completely automated.

    正确答案:A,D

  • 第19题:

    多选题
    You are managing an Oracle Database 11g database with ASM storage. The ASM disk group has the COMPATIBLE.ASM attribute set to 11.1.  Which statements are true regarding extent management and allocation units in the ASM disk group?()
    A

    The au_size disk group attribute determines the size of allocation units in the disk group.

    B

    The allocation unit size may vary but the extent size is fixed.

    C

    The allocation unit size and extent size are fixed for all the disks in a disk group and cannot be changed.

    D

    Extent management is completely automated.


    正确答案: C,B
    解析: 暂无解析

  • 第20题:

    多选题
    Which two statements about Automatic Storage Management (ASM) are true?()
    A

    ASM provides mirroring on file by file basis.

    B

    ASM provides automatic load balancing across all ASM disks.

    C

    ASM supports the Oracle database and operating system files.

    D

    ASM can be used to store trace files, alert log files, and the server parameter file (SPFILE).


    正确答案: D,C
    解析: 暂无解析

  • 第21题:

    多选题
    You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server. All databases of all versions use Automatic Storage Management (ASM). Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group?()
    A

    The ASM compatibility attribute controls the format of the disk group metadata.

    B

    RDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group.

    C

    The RDBMS compatibility setting allows only databases set to the same version as the compatibility value, to mount the ASM disk group.

    D

    The ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group.

    E

    The ADVM compatibility attribute determines the ACFS features that may be used by the Oracle 10g database.


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

  • 第22题:

    多选题
    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
    解析: 暂无解析

  • 第23题:

    多选题
    You plan to use the In Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format. Which three storage options support the use of HCC?()
    A

    ASM disk groups with ASM disks consisting of Exadata Grid Disks.

    B

    ASM disk groups with ASM disks consisting of LUNS on any Storage Area Network array

    C

    ASM disk groups with ASM disks consisting of any zero padded NFS-mounted files

    D

    Database files stored in ZFS and accessed using conventional NFS mounts.

    E

    Database files stored in ZFS and accessed using the Oracle Direct NFS feature

    F

    Database files stored in any file system and accessed using the Oracle Direct NFS feature

    G

    ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays


    正确答案: A,E,G
    解析: 暂无解析

  • 第24题:

    多选题
    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
    解析: 暂无解析