YouareworkingasaDBAinanorganization.Theflashrecoveryareafilesarecreatedin’+disk1’.Youwanttocreatenewflashrecoveryareafilesinthe’+disk2’location.Thenewlocationoftheflashrecoveryareafilesshouldbewritteninthecontrolfileandthespfile.Whichcommandwillyouissueto

题目

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

相似考题

1.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.

2.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；

3.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’；

4.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.

参考答案和解析
参考答案：B
更多“YouareworkingasaDBAinanorganization.Theflashrecoveryareafilesarecreatedin’＋disk1’.Youwantt ”相关问题

  • 第1题：

    Youdecidedtochangethelocationoftheflashrecoveryarea.Youexecutedthefollowingcommand:ALTERSYSTEMSETDB_RECOVERY_FILE_DEST=’＋disk1’SCOPE=BOTHSID=’*’;Whichstatementistrue?()

    A.Thelocationcanbechangedonlyiftheflashrecoveryareaisempty.

    B.Afterexecutingthecommand，allnewflashrecoveryareafileswillbecreatedinthenewlocation.

    C.Thecommandwillgenerateanerrorbecauseyoucannotchangetheflashrecoveryareawhilethedatabaseisopen.

    D.AlltheexistingfilesintheflashrecoveryareawillbemovedtothenewlocationandallnewFlashRecoveryAreafileswillbecreatedinthenewlocation.


    参考答案：B

  • 第2题：

    Youacquireapcwith3harddrives：Disk0，Disk1，Disk2.Eachphysicaldiskhasacapacityof6GB.Youwanteachdisktoconsistofonepartition.Youwanttoconfigurethecomputertodual-bootWin98andWin2KPRO.YouwanttosaveyourdocumentstoDisk1andhavetheabilitytoaccessthemundereitherOS.YoualsowanttoinstallWin2KPROandhavetheabilitytosecureindividualfilesonDisk2.


    Dragtheappropriatefilesystemstothecorrectdisks.
    DragFAT32toDisk0
    DragFAT32toDisk1
    DragNTFStoDisk2

    YoushouldformatyourDisk0withFAT32filesystembecauseyouwantdualbootingofWindow98andWindows2000professional.
    YoushoulddragFAT32totheDisk1becauseyouwantdatastoredatDisk1tobeaccessiblefromeitherOS.
    YoushoulddragNTFStoDisk2becauseNTFSonlyprovideslocalfileandfolderlevelsecurity.

  • 第3题：

    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？（）


    参考答案：B

  • 第4题：

    YouareconfiguringyourcomputertousebothWindows2000ProfessionalandWindows98.Yourcomputerhasthree8GBharddisks:Disk0,Disk1,andDisk2.Youwanttoconfigureeachharddisktohavean8GBpartition.YouwanttoinstallWindows98onDisk0andWindows2000ProfessionalonDisk1.YouwanttostoreyourworkfilesonDisk2.YouwanttoimplementfilelevelsecurityonDisk1.

    Youwanttobeabletoaccessyourworkfilewhenusingeitheroperatingsystem.Whatshouldyoudo?

    Toanswer,dragthecorrectfilesystemfromtheFileSystemTypeareaanddropthefilesystem

    intotheappropriatePartitiontypeforreachharddisk.


  • 第5题：

    你公司有一个单一ActiveDirectory域。所有服务器运行windowsserver2008.你有一个名为FS1的服务器,安装有文件服务角色。下图展示了磁盘配置。你需要创建一个新的卷来支持具有奇偶校验的数据条带化。怎么做?()

    A.添加一个磁盘，创建一个新的RAID-5卷

    B.用disk1和disk2创建一个带区卷

    C.用disk1和disk2创建一个镜像卷

    D.用disk1和disk2创建一个跨区卷


    参考答案：A

相关内容