网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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 group
B. all disks that are currently in OFFLINE mode
C. all disks that are not currently in OFFLINE mode
D. 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 ” 相关考题
考题
You are maintaining the SALES database.You have added a new disk to a disk group. Automatic Storage Management performs the rebalancing activity. You want to speed up the rebalancing activity.Which parameter should you specify to control the speed of the rebalancing activity?（）A. ASM_POWER_LIMITB. ASM_DISKSTRINGC. ASM_DISKGROUPSD. INSTANCE_TYPE
考题
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
考题
InyourAutomaticStorageManagement（ASM）instance，oneofthenonemptydiskgroups，DGROUP1，isnolongerrequiredandyouwantthisdiskgrouptoberemoved.Youexecutethefollowingcommandtoachievethisobjective：DROPDISKGROUPdgroup1EXCLUDINGCONTENTS；Whatwouldbetheresultofthiscommand？（）A.Thiscommandwouldresultinanerrorbecausethediskgroupisnotempty.B.Thecommandwoulddropthediskgroup，ignoringtheEXCLUDINGCONTENTSoption.C.ThecommandwouldresultinthediskgroupbeingmarkedasINVALIDbecauseitcannotbedropped.D.Thecommandwouldresultinthecontentsbeingmovedtotheparentdiskgroupanddroppingofthediskgroup.E.Thecommandwoulddistributethecontentsofthespecifieddiskgroupamongallotherdiskgroupsandthendropthespecifieddiskgroup.
考题
Which two statements are true regarding an Automatic Storage Management (ASM) instance? ()
A. As ASM instance mounts an ASM control fileB. An ASM instance uses the ASMB process for rebalancing of disks within a disk groupC. Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitlyD. An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started
考题
ImmediatelyafteraddinganewdisktoorremovinganexistingdiskfromanAutomaticStorageManagement（ASM）instance，youfindthattheperformanceofthedatabasedecreasesinitially，untiltheadditionorremovalprocessiscompleted.Performancethengraduallyreturnstonormallevels.Whichtwoactivitiescouldyouperformtomaintainaconsistentperformanceofthedatabasewhileaddingorremovingdisks？（）A.increasethenumberofcheckpointprocessesB.definethePOWERoptionwhileaddingorremovingthedisksC.increasethenumberofDBWRprocessesbysettingupahighervalueforDB_WRITER_PROCESSESD.increasethenumberofslavedatabasewriterprocessesbysettingupahighervaluefor DBWR_IO_SLAVESE.increasethenumberofASMRebalanceprocessesbysettingupahighervalueforASM_POWER_LIMITduringthediskadditionorremovalprocess
考题
Which two statements are true regarding an Automatic Storage Management (ASM) instance?() (Choosetwo.)
A. As ASM instance mounts an ASM control fileB. An ASM instance uses the ASMB process for rebalancing of disks within a disk groupC. Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitlyD. An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started
考题
WhichofthefollowingoptionsistrueaboutshuttingdownanAutomaticStorageManagement(ASM)instance?()
A.IftheSHUTDOWNIMMEDIATEcommandisissuedtotheASMinstance，theASMinstanceimmediatelyshutsdown.B.IftheSHUTDOWNABORTcommandisissuedtotheASMinstance，theASMinstancewillshutdownallthedatabaseinstancesandthenshutdownimmediately.C.IftheSHUTDOWNNORMALcommandisissuedtotheASMinstance，beforeshuttingdown，theASMinstancewaitsforthedependentdatabaseinstancestoshutdown.D.IftheSHUTDOWNTRANSACTIONALcommandisissuedtotheASMinstance，theASMinstancepassesthesameSHUTDOWNcommandtothedependentdatabaseinstances，butdoesnotwaitforanyactivetransactionstocompletebeforeitshutsdown.
考题
YouhaveasingleAutomaticStorageManagement（ASM）instancerunningonthenodeonwhichyourOracleDatabase10gresides.WhichASMinstanceinitializationparametersmustbeincludedintheASMinstanceinitializationparameterfile？（）A.INSTANCE_TYPEB.DB_UNIQUE_NAMEC.ASM_DISKSTRINGD.ASM_POWER_LIMIT
考题
YouexecutethefollowingcommandtostartanAutomaticStorageManagement(ASM)instance:SQLSTARTUP;InwhichofthefollowingmodeswilltheASMinstancestart?()
A.OPENB.MOUNTC.NORMALD.NOMOUNT
考题
Inwhichsituationwillyourunthescriptcontainingthefollowingstatement？（）CREATECONTROLFILEREUSEDATABASESALESNORESETLOGSARCHIVELOGMAXLOGFILES20MAXLOGMEMBERS3MAXDATAFILES30MAXINSTANCES10MAXLOGHISTORY1200LOGFILEGROUP1（’/disk1/prod/orders/db/log1a.dbf’，’/disk2/prod/orders/db/log1b.dbf’）SIZE100KGROUP2（’/disk1/prod/orders/db/log2a.dbf’，’/disk2/prod/orders/db/log2b.dbf’）SIZE100K，DATAFILE’/disk1/prod/orders/db/database1.dbf’，’/disk2/prod/orders/db/file1.dbf’；
热门标签
最新试卷
