多选题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?()AASM disk groups with ASM disks consisting of Exadata Grid Disks.BASM disk groups with ASM disks consisting of LUNS on any Storage Area Network arrayCASM disk groups with ASM disks consisting of any zero padded NFS-mounted filesDDatabase files stored in ZFS and accessed using conventional NFS mounts.EDatabase files stored in ZFS and accessed using the Oracle Direct NFS featureFDatabase files stored in any file system and accessed using the Oracle Direct NFS featureGASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays

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


参考解析

解析: 暂无解析

相关考题:

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

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 are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories.You plan to create the database using SQL statements.Which three techniques can you use to achieve this?()A. Use Oracle Managed Files (OMF).B. Specify the SEED FILE_NAME_CONVERT clause.C. Specify the PDB_FILE_NAME_CONVERT initialization parameter.D. Specify the DB_FILE_NAMECONVERT initialization parameter.E. Specify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).

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 arrayC. ASM disk groups with ASM disks consisting of any zero padded NFS-mounted filesD. Database files stored in ZFS and accessed using conventional NFS mounts.E. Database files stored in ZFS and accessed using the Oracle Direct NFS featureF. Database files stored in any file system and accessed using the Oracle Direct NFS featureG. ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays

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、 Recovery Manager (RMAN)C、 Oracle Data Pump Export and ImportD、 conventional Oracle Export and ImportE、 operating system utilities to copy the files to the ASM instance

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.

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 AssistantB、Recovery Manager (RMAN)C、Oracle Data Pump Export and ImportD、conventional Oracle Export and ImportE、operating system utilities to copy the files to the ASM instance

You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories. You plan to create the database using SQL statements. Which three techniques can you use to achieve this?()A、Use Oracle Managed Files (OMF).B、Specify the SEED FILE_NAME_CONVERT clause.C、Specify the PDB_FILE_NAME_CONVERT initialization parameter.D、Specify the DB_FILE_NAMECONVERT initialization parameter.E、Specify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).

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 OMFC、 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.

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.

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 AssistantB、Recovery Manager (RMAN)C、Oracle Data Pump Export and ImportD、conventional Oracle Export and ImportE、operating system utilities to copy the files to the ASM instance

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 arrayC、ASM disk groups with ASM disks consisting of any zero padded NFS-mounted filesD、Database files stored in ZFS and accessed using conventional NFS mounts.E、Database files stored in ZFS and accessed using the Oracle Direct NFS featureF、Database files stored in any file system and accessed using the Oracle Direct NFS featureG、ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays

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

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 BACKUPSETB、 BACKUP AS COPYC、 BACKUP AS COMPRESSED BACKUPSETD、 BACKUP INCREMENTAL LEVEL n CUMULATIVE

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、2B、3C、1 and 2D、3 and 4E、1,2,and 4

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.

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

单选题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 Recovery Manager (RMAN)C Oracle Data Pump Export and ImportD conventional Oracle Export and ImportE operating system utilities to copy the files to the ASM instance

多选题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?()AThe ASM compatibility attribute controls the format of the disk group metadata.BRDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group.CThe RDBMS compatibility setting allows only databases set to the same version as the compatibility value, to mount the ASM disk group.DThe ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group.EThe ADVM compatibility attribute determines the ACFS features that may be used by the Oracle 10g database.

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

单选题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?()AOracle Migration AssistantBRecovery Manager (RMAN)COracle Data Pump Export and ImportDconventional Oracle Export and ImportEoperating system utilities to copy the files to the ASM instance

单选题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?()AOracle Migration AssistantBRecovery Manager (RMAN)COracle Data Pump Export and ImportDconventional Oracle Export and ImportEoperating system utilities to copy the files to the ASM instance

多选题Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyzeimpact on the performance of SQL statements.()AChange in the Oracle Database versionBChange in your network infrastructureCChange in the hardware configuration of the database serverDMigration of database storage from non-ASM to ASM storageEDatabase and operating system upgrade

单选题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()A2B3C1 and 2D3 and 4E1,2,and 4

单选题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 BACKUPSETB BACKUP AS COPYC BACKUP AS COMPRESSED BACKUPSETD BACKUP INCREMENTAL LEVEL n CUMULATIVE

多选题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?()AASM disk groups with ASM disks consisting of Exadata Grid Disks.BASM disk groups with ASM disks consisting of LUNS on any Storage Area Network arrayCASM disk groups with ASM disks consisting of any zero padded NFS-mounted filesDDatabase files stored in ZFS and accessed using conventional NFS mounts.EDatabase files stored in ZFS and accessed using the Oracle Direct NFS featureFDatabase files stored in any file system and accessed using the Oracle Direct NFS featureGASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays

多选题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?()AThe 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.BRDBMS compatibility and the database version determines whether a database instance can mount the ASM disk group.CThe RDBMS compatibility settings for a disk group control the format of data structures for ASM metadata on the disk.DASM compatibility controls which features for the ASM will be enabled.