网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
You have a disk group， DGROUP1， with three disk and NORMAL redundancy. You execute the following command to create a template for the disk group： ALTER DISKGROUP dgroup1 ADD TEMPLATE my_temp ATTRIBUTES （MIRROR FINE）；Which statement is true？（）
A
When a file is created in DGROUP1 with the template， it would have three-way mirroring.
B
When a file is created in DGROUP1， the MY_TEMP template becomes the default template.
C
When a file is created in DGROUP1 with the template， it would have two-way mirroring and file striping.
D
When a file is created in DGROUP1 with the template， it would have three-way mirroring and file striping.
E
When a file is created in DGROUP1 with the template， it would have two-way mirroring but no file striping.
参考答案
参考解析
解析：
暂无解析
更多 “单选题You have a disk group， DGROUP1， with three disk and NORMAL redundancy. You execute the following command to create a template for the disk group： ALTER DISKGROUP dgroup1 ADD TEMPLATE my_temp ATTRIBUTES （MIRROR FINE）；Which statement is true？（）A When a file is created in DGROUP1 with the template， it would have three-way mirroring.B When a file is created in DGROUP1， the MY_TEMP template becomes the default template.C When a file is created in DGROUP1 with the template， it would have two-way mirroring and file striping.D When a file is created in DGROUP1 with the template， it would have three-way mirroring and file striping.E When a file is created in DGROUP1 with the template， it would have two-way mirroring but no file striping.” 相关考题
考题
Examine the CREATE DISKGROUP command used to create a disk group:In which situation would you use this method of disk group creation?()
A. When two-way disk mirroring is required for the allocation unitsB. When three-way disk mirroring is required for the allocation unitsC. When using hardware mirroring or RAIDD. When disk mirroring is required for the Automatic Storage Management (ASM) disks
考题
In your Automatic Storage Management （ASM） instance， one of the nonempty disk groups， DGROUP1， is no longer required and you want this disk group to be removed. You execute the following command to achieve this objective： DROP DISKGROUP dgroup1 EXCLUDING CONTENTS； What would be the result of this command？（）A、 This command would result in an error because the disk group is not empty.B、 The command would distribute the contents of the specified disk group among all other disk groups and then drop the specified disk group.C、 The command would result in the contents being moved to the parent disk group and dropping of the disk group.D、 The command would result in the disk group being marked as INVALID because it cannot be dropped.E、 The command would drop the disk group， ignoring the EXCLUDING CONTENTS option.
考题
Examine the following ALTER command: SQL ALTER DISKGROUP dgroup1 UNDROP DISKS; What is the purpose of the command?（）A、It cancels all pending disk drops within the disk group.B、It restores disks that are being dropped as the result of a DROP DISKGROUP operationC、It mounts disks in the disk group for which the drop-disk operation has already been co pletedD、It restores all the dropped disks in the disk group for which the drop-disk operation has already been completedE、It adds previously dropped disks back into the disk group
考题
You are an Oracle DBA responsible for an ASM instance. The disk controller on your system fails. You suspect that the disk itself is okay. You know it will take 24 hours to replace the controller and you don’t want to have to rebuild the disks from scratch. What do you do？（） A、 Take the whole disk group offline and wait for the controller card to be installed. Once it’s installed，bring the disk group online again.B、 Change the ASM parameter ASM_PREFERRED_READ_FAILURE_GROUPS to indicate that you want to read from the non-failed disk. Once the disk controller is replaced，reset the parameter to its original value.C、 You have no choice but to rebuild the disk. Drop the disk from the disk group and wait for the controller to be replaced. Once the controller is replaced， add the disk back into the disk group and allow ASM to rebuild it.D、 If you are using any setting other than REDUNDANCY EXTERNAL for your disk group，you will have to recover any data on that disk from a backup. The database will be unavailable until you can correct the problem and perform recovery.E、 Change the attribute DISK_REPAIR_TIME on the disk group to a time greater than 24 hours.
考题
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 outaC、 The ASM migrates the extents from the unavailable disk to the remaining disks.D、 The disk automatically goes offline.
考题
Examine the following ALTER command: SQL ALTER DISKGROUP dgroup1 UNDROP DISKS; What is the purpose of the command?（）A、It cancels all pending disk drops within the disk groupB、It restores disks that are being dropped as the result of a DROP DISKGROUP operationC、It mounts disks in the disk group for which the drop-disk operation has already been completedD、It restores all the dropped disks in the disk group for which the drop-disk operation has already been completedE、It adds previously dropped disks back into the disk group
考题
You have a file server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2). You need to implement a backup schedule on Server1 to meet the following requirements: ·Everyday, back up all files and folders to disk. ·Every Friday, back up all files and folders to tape. ·Every Sunday, Tuesday, and Thursday, back up only the files and folders that have changed since the previous Friday’s backup to tape. Which backup jobs should you create? （）A、·a normal backup to disk everyday ·a normal backup to tape on Friday ·a differential backup to tape on Sunday, Tuesday, and ThursdayB、·a normal backup to disk everyday ·a normal backup to tape on Friday ·an incremental backup to tape on Sunday, Tuesday, and ThursdayC、·a copy backup to disk everyday ·a normal backup to tape on Friday ·a differential backup to tape on Sunday, Tuesday and, ThursdayD、·a copy backup to disk everyday ·a normal backup to tape on Friday ·an incremental backup to tape on Sunday, Tuesday and, Thursday
考题
单选题You have a file server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2). You need to implement a backup schedule on Server1 to meet the following requirements: ·Everyday, back up all files and folders to disk. ·Every Friday, back up all files and folders to tape. ·Every Sunday, Tuesday, and Thursday, back up only the files and folders that have changed since the previous Friday’s backup to tape. Which backup jobs should you create? （）A
·a normal backup to disk everyday ·a normal backup to tape on Friday ·a differential backup to tape on Sunday, Tuesday, and ThursdayB
·a normal backup to disk everyday ·a normal backup to tape on Friday ·an incremental backup to tape on Sunday, Tuesday, and ThursdayC
·a copy backup to disk everyday ·a normal backup to tape on Friday ·a differential backup to tape on Sunday, Tuesday and, ThursdayD
·a copy backup to disk everyday ·a normal backup to tape on Friday ·an incremental backup to tape on Sunday, Tuesday and, Thursday
考题
单选题You have a disk group， DGROUP1， with three disks and NORMAL redundancy. You execute the following command to create a template for the disk group： ALTER DISKGROUP dgroup1 ADD TEMPLATE my_temp ATTRIBUTES （MIRROR FINE）; Which statement is true？（）A
When a file is created in DGROUP1 with the template， it would have threeway mirroring. B
When a file is created in DGROUP1， the MY_TEMP template becomes the default template.C
When a file is created in DGROUP1 with the template， it would have twoway mirroring and file striping.D
When a file is created in DGROUP1 with the template， it would have threeway mirroring and file striping.E
When a file is created in DGROUP1 with the template， it would have twoway mirroring but no file striping.
考题
多选题You administer an online transaction processing (OLTP) system whose database is stored in Automatic Storage Management (ASM) and whose disk group use normal redundancy. One of the ASM disks goes offline, and is then dropped because it was not brought online before DISK_REPAIR_TIME elapsed. When the disk is replaced and added back to the disk group, the ensuing rebalance operation is too slow. Which two recommendations should you make to speed up the rebalance operation if this type of failure happens again?（）AIncrease the value of the ASM_POWER_LIMIT parameter.BSet the DISK_REPAIR_TIME disk attribute to a lower value.CSpecify the statement that adds the disk back to the disk group.DIncrease the number of ASMB processes.EIncrease the number of DBWR_IO_SLAVES in the ASM instance.
考题
单选题You have a disk group， DGROUP1， with three disks and NORMAL redundancy. You execute the following command to create a template for the disk group： ALTER DISKGROUP dgroup1 ADD TEMPLATE my_temp ATTRIBUTES （MIRROR FINE）； Which statement is true？（）A
When a file is created in DGROUP1 with the template， it would have three-way mirroring.B
When a file is created in DGROUP1， the MY_TEMP template becomes the default template.C
When a file is created in DGROUP1 with the template， it would have two-way mirroring and file striping.D
When a file is created in DGROUP1 with the template， it would have three-way mirroring and file striping.E
When a file is created in DGROUP1 with the template， it would have two-way mirroring but no file Striping.
考题
多选题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.
考题
多选题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？（）AThe disk is immediately dropped from the disk group.BThe ASM tracks the extents that are modified during the outaCThe ASM migrates the extents from the unavailable disk to the remaining disks.DThe disk automatically goes offline.
考题
单选题Examine the following ALTER command: SQL ALTER DISKGROUP dgroup1 UNDROP DISKS; What is the purpose of the command?（）A
It cancels all pending disk drops within the disk groupB
It restores disks that are being dropped as the result of a DROP DISKGROUP operationC
It mounts disks in the disk group for which the drop-disk operation has already been completedD
It restores all the dropped disks in the disk group for which the drop-disk operation has already been completedE
It adds previously dropped disks back into the disk group
考题
单选题You are using an Automatic Storage Management （ASM） instance to manage the files of your production database. You have two disk groups， DG1and DG2with one device each. In the parameter file of the production database， the following parameters have been specified： DB_CREATE_ONLINE_LOG_DEST_1 = ’+dg1’ DB_CREATE_ONLINE_LOG_DEST_2 = ’+dg2’ What would be the impact of this setting？（）A
When a new log group is added， it would have one member in each disk group.B
When a new log group is added， it would have two members in each disk group.C
When a new tablespace is added， it would have one data file in each disk group.D
When a new log file is added， it would have one member spread across the disk groups.
考题
单选题Consider the following command to add a new disk group called "tdgroupA" with two failover groups： CREATE DISKGROUP tdgroupA NORMAL REDUNDANCY FAILOVERGROUP control01 DISK ’/devices/A1’， ’/devices/A2’， ’/devices/A3’ FAILOVERGROUP control02 DISK ’/devices/B1’， ’/devices/B2’， ’/devices/B3’m The disk "/devices/A1" is currently a member disk of a disk group by the name "tdgroup1". Which task would be accomplished by the command？（）A
This command would result in an error because a disk group can have only one failover group.B
This command would result in an error because the /devices/A1 disk is a member of another disk group tdgroup1.C
A new disk group called tdgroupA will be added with two failover groups and the /devices/A1 disk will get reattached to the new disk group without being detached from the existing one.D
A new disk group called tdgroupA will be added with two failover groups and the /devices/A1 disk will be ignored for the new disk group because it is a member of an existing disk group tdgroup1.E
A new disk group called tdgroupA will be added with two failover groups and the /devices/A1 disk gets detached from the existing disk group tdgroup1 and attached to the new disk group tdgroupA
考题
单选题In your Automatic Storage Management （ASM） instance， one of the nonempty disk groups， DGROUP1， is no longer required and you want this disk group to be removed. You execute the following command to achieve this objective： DROP DISKGROUP dgroup1 EXCLUDING CONTENTS； What would be the result of this command？（）A
This command would result in an error because the disk group is not empty.B
The command would distribute the contents of the specified disk group among all other disk groups and then drop the specified disk group.C
The command would result in the contents being moved to the parent disk group and dropping of the disk group.D
The command would result in the disk group being marked as INVALID because it cannot be dropped.E
The command would drop the disk group， ignoring the EXCLUDING CONTENTS option.
考题
多选题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
考题
多选题As the DBA， you run the following query on your ASM instance. What is the implication of the results of the query？（） SQL select group_number， name， state from v$ASM_DISKGROUP； GROUP_NUMBER NAME STATE 0 DGROUP1 DISMOUNTED 2 DGROUP2 MOUNTED 3 DGROUP3 MOUNTEDAThe DGROUP1 disk group was unmounted by another DBA.BA datafile has been lost， causing the ASM disk group DGROUP1 to go into the DISMOUNTED stateCOne of the redundant disks （DGROUP1） has been lost in a disk group.DThis query has no meaning in an ASM instance.EA disk associated with a disk group was discovered after the ASM instance initially opened.
考题
单选题You are using an Automatic Storage Management （ASM） instance to manage the files of your production database. You have two disk groups， DG1 and DG2， with one device each. In the parameter file of the production database， the following parameters have been specified： DB_CREATE_ONLINE_LOG_DEST_1 = ’+dg1’ DB_CREATE_ONLINE_LOG_DEST_2 = ’+dg2’ What would be the impact of this setting？（）A
When a new log group is added， it would have one member in each disk group.B
When a new log group is added， it would have two members in each disk group.C
When a new tablespace is added， it would have one data file in each disk group.D
When a new log file is added， it would have one member spread across the disk groups.
考题
单选题You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks. One of the disks in the disk group becomes unavailable because of power failure. You issued the following command to change the DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours: ALTER DISKGROUP dg01 SET ATTRIBUTE 'disk_repair_time' = '5h'; To which disks in the disk group will the new value be applicable?（）A
all disks in the disk groupB
all disks that are currently in OFFLINE modeC
all disks that are not currently in OFFLINE modeD
all disks in the disk group only if all of them are ONLINE
考题
单选题You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks. One of the disks in the disk group becomes unavailable because of power failure. You issued the following command to change the DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours： ALTER DISKGROUP dg01 SET ATTRIBUTE ’disk_repair_time’ = ’5h’； To which disks in the disk group will the new value be applicable？（）A
all disks in the disk groupB
all disks that are currently in OFFLINE modeC
all disks that are not currently in OFFLINE modeD
all disks in the disk group only if all of them are ONLINE
考题
单选题A database instance is using an Automatic Storage Management (ASM) instance, which has a disk group, DGROUP1, created as follows: SQL CREATE DISKGROUP dgroup1 NORMAL REDUNDANCY FAILGROUP controller1 DISK '/devices/diska1', '/devices/diska2' FAILGROUP controller2 DISK '/devices/diskb1', '/devices/diskb2' ; What happens when the whole CONTROLLER1 Failure group is damaged?（）A
The transactions that use the disk group will halt.B
The mirroring of allocation units occurs within the CONTROLLER2 failure group.C
The data in the CONTROLLER1 failure group is shifted to the CONTROLLER2 failure group and implicit rebalancing is triggered.D
The ASM does not mirror any data and newly allocated primary allocation units (AU) are stored in the CONTROLLER2 failure group.
考题
单选题What is the net effect of the following command？（） alter diskgroup dgroup1 drop disk abc；A
The disk ABC will be dropped from the disk group. Since you did not issue a rebalance command，the data on that disk will be lost.B
The command will raise an error indicating that you need to rebalance the disk group to remove the data from that disk prior to dropping the disk.C
The disk group will be automatically rebalanced during the drop operation. Once the rebalancing is complete，the disk will be dropped.D
This command will fail because you cannot drop a specific disk in an ASM disk group.E
The disk drop command will be suspended for a predetermined amount of time，waiting for you to also issue an alter diskgroup rebalance command. Once you have issued the rebalance command，ASM will proceed to rebalance the disk group and then drop the disk.
考题
单选题Examine the following ALTER command： SQL ALTER DISKGROUP dgroup1 UNDROP DISKS； What is the purpose of the command？（）A
It cancels all pending disk drops within the disk group.B
It restores disks that are being dropped as the result of a DROP DISKGROUP operationC
It mounts disks in the disk group for which the drop-disk operation has already been co pletedD
It restores all the dropped disks in the disk group for which the drop-disk operation has already been completedE
It adds previously dropped disks back into the disk group
热门标签
最新试卷
