You are administering a database stored in Automatic Storage management （ASM). The files a

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.

YourproductiondatabaseusesanAutomaticStorageManagement（ASM）instancetomanageitsfiles.YouwanttoaddanewdiskgrouptotheASMinstancetomanagetheincreaseddataload.WhatactionwouldyouperformtoincludethenewdiskgroupintheASMinstancewithoutcausinganyimpactonthecurrentlyconnectedusers？（）

A.mountthenewdiskgroupintheASMinstance

B.restarttheASMinstanceandtheproductiondatabaseinstance

C.registerthenewdiskgroupsintheproductiondatabaseinstance

D.restarttheASMinstancewithoutrestartingtheproductiondatabaseinstance

E.includethenewdiskgroupintheASM_DISKSTRINGparameterintheparameterfileandrestarttheASMinstance

YourproductiondatabaseusesanAutomaticStorageManagement（ASM）instancetomanageitsfiles.YouwanttoaddanewdiskgrouptotheASMinstancetomanagetheincreaseddataload.WhatactionwouldyouperformtoincludethenewdiskgroupintheASMinstancewithoutcausinganyimpactonthecurrentlyconnectedusers？（）

A.mountthenewdiskgroupintheASMinstance

B.restarttheASMinstanceandtheproductiondatabaseinstance

C.registerthenewdiskgroupsintheproductiondatabaseinstance

D.restarttheASMinstancewithoutrestartingtheproductiondatabaseinstance

E.includethenewdiskgroupintheASM_DISKSTRINGparameterintheparameterfileandrestarttheASMinstance

YouhaveasingleAutomaticStorageManagement（ASM）instancerunningonthenodeonwhichyourOracleDatabase10gresides.WhichASMinstanceinitializationparametersmustbeincludedintheASMinstanceinitializationparameterfile？（）

A.INSTANCE_TYPE

B.DB_UNIQUE_NAME

C.ASM_DISKSTRING

D.ASM_POWER_LIMIT

YouworkasadatabaseadministratoratCertkiller.com.YourproductiondatabaseusesanAutomaticStorageManagement（ASM）instancetomanageitsfiles.YouwanttoaddanewdiskgrouptotheASMinstancetomanagetheincreaseddataload.WhatactionwouldyouperformtoincludethenewdiskgroupintheASMinstancewithoutcausinganyimpactonthecurrentlyconnectedusers？（）

A.mountthenewdiskgroupintheASMinstance

B.restarttheASMinstanceandtheproductiondatabaseinstance

C.registerthenewdiskgroupsintheproductiondatabaseinstance

D.restarttheASMinstancewithoutrestartingtheproductiondatabaseinstance

E.includethenewdiskgroupintheASM_DISKSTRINGparameterintheparameterfileandrestarttheASMinstance

TheORACLE_SIDenvironmentvariableissetto+ASM.ASMLIBisnotusedintheconfiguration.YouexecutedthefollowingcommandtostartuptheAutomaticStorageManagement（ASM）instance.SQL>STARTUP；Whichtwoactivitiesareperformedduringasuccessfulstartupoperation？（）

A.ThedatabasesconfiguredtousetheASMinstancearemounted

B.ThediskgroupsaremountedaspertheASM_DISKGROUPSinitializationparameter

C.ASMstartstheOracleClusterSynchronizationServices（CSS）daemonifitisnotstarted

D.ASMdiscoversandexaminesthecontentsofallfilesthatareinthepathsspecifiedinthe ASM_DISKGROUPSinitializationparameters

YouareusinganAutomaticStorageManagement（ASM）instancetomanagethefilesofyourproductiondatabase.WhilestudyingtheparameterfileoftheASMinstance，youfindthefollowingentry：ASM_DISKSTRING=/devices/*Whatcouldbethereasonforthissetting？（）

A.toenabletheASMinstancetoidentifythealertlogfile

B.toenabletheASMinstancetoidentifytheserverparameterfile

C.toenabletheASMinstancetodefinethelocationsforOracleManagedFiles（OMF）

D.toenabletheASMinstancetoidentifyalldisksthatcanbeaccessedbyitinthe/devicesdirectory

YouareusinganAutomaticStorageManagement（ASM）instancetomanagethefilesofyourproductiondatabase.Youhavetwodiskgroups，DG1andDG2，withonedeviceeach.Intheparameterfileoftheproductiondatabase，thefollowingparametershavebeenspecified：DB_CREATE_ONLINE_LOG_DEST_1=’+dg1’DB_CREATE_ONLINE_LOG_DEST_2=’+dg2’Whatwouldbetheimpactofthissetting？（）

A.Whenanewloggroupisadded，itwouldhaveonememberineachdiskgroup.

B.Whenanewloggroupisadded，itwouldhavetwomembersineachdiskgroup.

C.Whenanewtablespaceisadded，itwouldhaveonedatafileineachdiskgroup.

D.Whenanewlogfileisadded，itwouldhaveonememberspreadacrossthediskgroups.

YouareworkingonanewOracleDatabase11gserver，whereonlythesoftwareisinstalledandnodatabaseiscreated.YouplantocreateadatabaseonthisserverusingtheDatabaseConfigurationAssistant（DBCA）.

Someoftherequirementssetforyourdatabasecreationtaskare：

1：Configurethedatabasetooperateinsharedservermode.

2：Disableautomaticmaintenancetaskssuchasoptimizerstatisticscollection.

3：Configureanamingmethodtohelptheremoteuserconnecttothedatabaseinstance.

4：UseAutomaticStorageManagement（ASM）forstoringthedatabasefiles.

5：Configuredailydatabasebackuptoflashrecoveryarea.

6：ConfigureEnterpriseManagerDatabaseControltomanagethedatabase.

Whichoftheserequirementscanbemetwhilecreatingthedatabase（）

A.OracleMigrationAssistant

B.RecoveryManager（RMAN）

C.OracleDataPumpExportandImport

D.conventionalOracleExportandImport

E.operatingsystemutilitiestocopythefilestotheASMinstance