YouareworkingasaDBAinanorganization.Theflashrecoveryareafilesarecreatedin’+disk1’.Youwanttocreatenewflashrecoveryareafilesinthe’+disk2’location.Thenewlocationoftheflashrecoveryareafilesshouldbewritteninthecontrolfileandthespfile.Whichcommandwillyouissuetochangethelocationoftheflashrecoveryareafiles?()A.ALTERSYSTEMSETDB_RECOVERY_FILE_DEST=’+disk2’;B.ALTERSYSTEMSETDB_RECOVER_FILE_DEST=’+disk2’SCOPE=BOTH;C.ALTERSYSTEMSETDB_CREATE_FILE_DEST=’+disk2’;D.ALTERSYSTEMSETDB_CREATE_ONLINE_LOG_DEST_n=’+disk2’;

YouareworkingasaDBAinanorganization.Theflashrecoveryareafilesarecreatedin’+disk1’.Youwanttocreatenewflashrecoveryareafilesinthe’+disk2’location.Thenewlocationoftheflashrecoveryareafilesshouldbewritteninthecontrolfileandthespfile.Whichcommandwillyouissuetochangethelocationoftheflashrecoveryareafiles?()

A.ALTERSYSTEMSETDB_RECOVERY_FILE_DEST=’+disk2’;

B.ALTERSYSTEMSETDB_RECOVER_FILE_DEST=’+disk2’SCOPE=BOTH;

C.ALTERSYSTEMSETDB_CREATE_FILE_DEST=’+disk2’;

D.ALTERSYSTEMSETDB_CREATE_ONLINE_LOG_DEST_n=’+disk2’;


相关考题:

Youwanttosetthefollowinginitializationparametersforyourdatabaseinstance:LOG_ARCHIVE_DEST_1=’LOCATION=/disk1/arch’LOG_ARCHIVE_DEST_2=’LOCATION=/disk2/arch’LOG_ARCHIVE_DEST_3=’LOACTION=/disk3/arch’LOG_ARCHIVE_DEST_4=’LOCATION=/disk4/archMANDATORY’Identifythestatementthatcorrectlydescribesthissetting.()A.TheMANDATORYlocationmustbeaflashrecoveryarea.B.Theoptionaldestinationsmaynotusetheflashrecoveryarea.C.ThissettingisnotallowedbecausethefirstdestinationisnotsetasMANDATORY.D.Theonlineredologfileisnotallowedtobeoverwrittenifthearchivedlogcannotbecreatedinthefourthdestination.

YouwanttosetthefollowingInitializationparametersforyourdatabaseInstanceLOG_ARCHIVE_DEBT_1=,,LOCATION=/disk1/archLOG_ARCHIVE_DBST_2=,,LOCATION=/disk2/archLOC_ARCHIVBDBST_3=,,LOCATION=/disk3/archLOG_ARCHIVEDBST_=,,LOCATION=/disk3/archIdentifythestatementthatcorrectlydescribesthissetting.()A.TheMANDATORYlocationmustbeaflashrecoveryarea.B.Theoptionaldestinationsmaynotusetheflashrecoveryarea.C.ThissettingisnotallowedbecausethefirstdestinationisnotsetasMANDATORY.D.Theonlineredologfileisnotallowedtobeoverwrittenifthearchivedlogcannotbecreatedinthefourthdestination.

Youhavethefollowingonlineredologconfiguration:GroupMember1’/disk1/oradata/redo01a.log’2’/disk2/oradata/redo02a.log’3’/disk3/oradata/redo03a.log’Youdecidetomultiplextheonlineredologgroupsforrecoveryofredologfilesincaseofanydisaster.WhichtwostatementswillyouNOTissuetomultiplextheonlineredologfiles?()A.ALTERDATABASEADDLOGFILEMEMBER’/disk1/oradata/redo01b.log’TOGROUP1;B.ALTERDATABASEADDLOGFILEMEMBER’/disk2/oradata/redo01b.log’TOGROUP1;C.ALTERDATABASEADDLOGFILEMEMBER’/disk1/oradata/redo02b.log’TOGROUP2;D.ALTERDATABASEADDLOGFILEMEMBER’/disk2/oradata/redo02b.log’TOGROUP2;E.ALTERDATABASEADDLOGFILEMEMBER’/disk1/oradata/redo3b.log’TOGROUP3;F.ALTERDATABASEADDLOGFILEMEMBER’/disk2/oradata/redo3b.log’TOGROUP3;

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’;

Youdecidedtochangethelocationoftheflashrecoveryarea.Youexecutedthefollowingcommand:ALTERSYSTEMSETDB_RECOVERY_FILE_DEST=’+disk1’SCOPE=BOTHSID=’*’;Whichstatementistrue?() A.Thelocationcanbechangedonlyiftheflashrecoveryareaisempty.B.Afterexecutingthecommand,allnewflashrecoveryareafileswillbecreatedinthenewlocation.C.Thecommandwillgenerateanerrorbecauseyoucannotchangetheflashrecoveryareawhilethedatabaseisopen.D.AlltheexistingfilesintheflashrecoveryareawillbemovedtothenewlocationandallnewFlashRecoveryAreafileswillbecreatedinthenewlocation.

YouareconfiguringyourcomputertousebothWindows2000ProfessionalandWindows98.Yourcomputerhasthree8GBharddisks:Disk0,Disk1,andDisk2.Youwanttoconfigureeachharddisktohavean8GBpartition.YouwanttoinstallWindows98onDisk0andWindows2000ProfessionalonDisk1.YouwanttostoreyourworkfilesonDisk2.YouwanttoimplementfilelevelsecurityonDisk1.Youwanttobeabletoaccessyourworkfilewhenusingeitheroperatingsystem.Whatshouldyoudo?Toanswer,dragthecorrectfilesystemfromtheFileSystemTypeareaanddropthefilesystemintotheappropriatePartitiontypeforreachharddisk.

Youacquireapcwith3harddrives:Disk0,Disk1,Disk2.Eachphysicaldiskhasacapacityof6GB.Youwanteachdisktoconsistofonepartition.Youwanttoconfigurethecomputertodual-bootWin98andWin2KPRO.YouwanttosaveyourdocumentstoDisk1andhavetheabilitytoaccessthemundereitherOS.YoualsowanttoinstallWin2KPROandhavetheabilitytosecureindividualfilesonDisk2.

你公司有一个单一ActiveDirectory域。所有服务器运行windowsserver2008.你有一个名为FS1的服务器,安装有文件服务角色。下图展示了磁盘配置。你需要创建一个新的卷来支持具有奇偶校验的数据条带化。怎么做?() A.添加一个磁盘,创建一个新的RAID-5卷B.用disk1和disk2创建一个带区卷C.用disk1和disk2创建一个镜像卷D.用disk1和disk2创建一个跨区卷

YouexperiencealossofthediskonwhichtheUSER_DATAtablespacedatafilesarestored.Youattempttorecoverthedatafilesbutdiscoverthatthearchivedredologfilewithsequencenumber45,whichisneededtoperformcompleterecovery,isinvalid.Youthenbeginincompleterecovery-Youreceivethisprompt:ORA-00279:change309012...03/09/0111:33:56neededforthreadORA-00289:suggestion:/disk1/archive/arch_45.rdoORA-00280:change309012forthread1isinsequence#45Specifylog:{=suggested|filename|AUTO|CANCEL}Whatisthecorrectresponse?()