网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
Which two are the uses of the ASM metadata backup and restore （AMBR） feature？（）
A
It can be used to back up all data on ASM disks.
B
It can be used to recover the damaged ASM disk group along with the data.
C
It can be used to gather information about a preexisting ASM disk group with disk paths，disk name，failure groups，attributes templates，and alias directory structure.
D
It can be used to re-create the ASM disk group with its attributes.
参考答案
参考解析
解析：
暂无解析
更多 “多选题Which two are the uses of the ASM metadata backup and restore （AMBR） feature？（）AIt can be used to back up all data on ASM disks.BIt can be used to recover the damaged ASM disk group along with the data.CIt can be used to gather information about a preexisting ASM disk group with disk paths，disk name，failure groups，attributes templates，and alias directory structure.DIt can be used to re-create the ASM disk group with its attributes.” 相关考题
考题
Examine the following command:ALTER DISKGROUP data MOUNT FORCE;In which scenario can you use the above command to mount the disk group? ()
A. when ASM disk goes offlineB. when one or more ASM files are droppedC. when some disks in a disk group are offlineD. when some disks in a failure group for a disk group are rebalancing
考题
The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration. You executed the following command to startup the Automatic Storage Management (ASM) instance.SQL STARTUP;Which two activities are performed during a successful start up operation?（）A. The databases configured to use the ASM instance are mountedB. The disk groups are mounted as per the ASM_DISKGROUPS initialization parameterC. ASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not startedD. ASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters
考题
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 company uses raw logical volumes. Which command can be used to back up the data in the raw logical volumes to a tape？（）A、ddB、tarC、cpioD、mksysb
考题
Which two are the uses of the ASM metadata backup and restore （AMBR） feature？（）A、 It can be used to back up all data on ASM disks.B、 It can be used to recover the damaged ASM disk group along with the data.C、 It can be used to gather information about a preexisting ASM disk group with disk paths，disk name，failure groups，attributes templates，and alias directory structure.D、 It can be used to re-create the ASM disk group with its attributes.
考题
The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration. You executed the following command to startup the Automatic Storage Management (ASM) instance. SQL STARTUP; Which two activities are performed during a successful start up operation? （）(Choose two.)A、The databases configured to use the ASM instance are mountedB、The disk groups are mounted as per the ASM_DISKGROUPS initialization parameterC、ASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not startedD、ASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters
考题
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.
考题
Examine the following command： ALTER DISKGROUP data MOUNT FORCE； In which scenario can you use the above command to mount the disk group？（） A、 when ASM disk goes offlineB、 when one or more ASM files are droppedC、 when some disks in a disk group are offlineD、 when some disks in a failure group for a disk group are rebalancing
考题
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）.
考题
You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure. In which three ways can you re-create the lost disk group and restore the data?（）A、Use the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as an input parameter and use RMAN to restore the data.B、Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group.C、Use the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the data.D、Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group name and same set of disks and failure group configuration, and use RMAN to restore the data.E、Use the MD_RESTORE command to restore both the metadata and data for the failed disk group.F、Use the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use RMAN to restore the data.
考题
In which situations will the ASM metadata backup help you recover the ASM disk in a disk group？（）A、 when one or more file directory paths are accidentally deleted from an ASM disk groupB、 when one of the disks in a disk group is accidentaly unpluggedC、 when the data file on an ASM disk group gets corruptedD、 when one or more disks in an ASM disk group are lost
考题
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.
考题
The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration. You executed the following command to startup the Automatic Storage Management (ASM) instance. SQL STARTUP; Which two activities are performed during a successful start up operation?（）A、The databases configured to use the ASM instance are mountedB、The disk groups are mounted as per the ASM_DISKGROUPS initialization parameterC、ASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not startedD、ASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters
考题
多选题The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration. You executed the following command to startup the Automatic Storage Management (ASM) instance. SQL STARTUP; Which two activities are performed during a successful start up operation? （）(Choose two.)AThe databases configured to use the ASM instance are mountedBThe disk groups are mounted as per the ASM_DISKGROUPS initialization parameterCASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not startedDASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters
考题
多选题You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure. In which three ways can you re-create the lost disk group and restore the data?（）AUse the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as an input parameter and use RMAN to restore the data.BUse the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group.CUse the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the data.DUse the MKDG command to restore the disk group with the same configuration as the backed-up disk group name and same set of disks and failure group configuration, and use RMAN to restore the data.EUse the MD_RESTORE command to restore both the metadata and data for the failed disk group.FUse the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use RMAN to restore the data.
考题
多选题Which two statements are true regarding the USING clause in table joins?（）AIt can be used to join a maximum of three tablesBIt can be used to restrict the number of columns used in a NATURAL joinCIt can be used to access data from tables through equijoins as well as nonequijoinsDIt can be used to join tables that have columns with the same name and compatible data types
考题
多选题Which two statements about Automatic Storage Management （ASM） are true？（）AASM provides mirroring on file by file basis.BASM provides automatic load balancing across all ASM disks.CASM supports the Oracle database and operating system files.DASM can be used to store trace files， alert log files， and the server parameter file （SPFILE）.
考题
多选题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.
考题
多选题Which three tasks can be performed using regular expression support in Oracle Database 10g？（）Ait can be used to concatenate two strings.Bit can be used to find out the total length of the string.Cit can be used for string manipulation and searching operations.Dit can be used to format the output for a column or expression having string data.Eit can be used to find and replace operations for a column or expression having string data.
考题
多选题The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration. You executed the following command to startup the Automatic Storage Management （ASM） instance. SQL STARTUP； Which two activities are performed during a successful start up operation？（）AThe databases configured to use the ASM instance are mountedBThe disk groups are mounted as per the ASM_DISKGROUPS initialization parameterCASM starts the Oracle Cluster Synchronization Services （CSS） daemon if it is not startedDASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters
考题
多选题Which two are the uses of the ASM metadata backup and restore （AMBR） feature？（）AIt can be used to back up all data on ASM disks.BIt can be used to recover the damaged ASM disk group along with the data.CIt can be used to gather information about a preexisting ASM disk group with disk paths，disk name，failure groups，attributes templates，and alias directory structure.DIt can be used to re-create the ASM disk group with its attributes.
考题
多选题Which two statements about Recovery Manager （RMAN） backups are true？ （）AOnline redo log files can be backed up.BArchived redo log files are backed up.COnly used data blocks can be backed up as backup sets.DOnly consistent database backups can be performed.ERMAN backup can be taken only if the database is configured in ARCHIVELOG mode.
考题
单选题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 are managing an Oracle 11g database with ASM storage, for which the COMPATIBLE initialization parameter is set to 11.1.0. In the ASM instance, the COMPATIBLE.RDBMS attribute for the disk group is set to 10.2 and the COMPATIBLE.ASM attribute is set to 11.1. Which two statements are true in this scenario for the features enabled for ASM? （）AThe ASM-preferred mirror read feature is enabled.BThe ASM supports variable sizes for extents of 1, 8, and 64 allocation units.CThe ASM disk is dropped immediately from a disk group when it becomes unavailable.DThe RDBMS always reads the primary copy of a mirrored extent of the ASM disk group.
考题
多选题In which situations will the ASM metadata backup help you recover the ASM disk in a disk group？（）Awhen one or more file directory paths are accidentally deleted from an ASM disk groupBwhen one of the disks in a disk group is accidentaly unpluggedCwhen the data file on an ASM disk group gets corruptedDwhen one or more disks in an ASM disk group are lost
考题
多选题Which two statements are true about the Automatic Diagnostic Repository (ADR)?（） (Choose two.)AThe ADR base keeps all diagnostic information in binary formatBSQL*Plus provides the ADRI script, which can be used to work with ADRCThe ADR can be used for problem diagnosis only when the database is openDThe ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to nullEThe ADR can be used for problem diagnosis even when the database instance is downFThe ADR base is shared across multiple instances
考题
多选题Which two statements are true about Oracle Managed Files (OMF)?（）AOMF cannot be used in a database that already has data files created with user-specified directions.BThe file system directions that are specified by OMF parameters are created automatically.COMF can be used with ASM disk groups, as well as with raw devices, for better file management.DOMF automatically creates unique file names for table spaces and control files.EOMF may affect the location of the redo log files and archived log files.
考题
多选题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.
热门标签
最新试卷