网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)

You are managing an Oracle 11g database with ASM storage, for which the COMPATIBLE initialization parameter is set to 11.1.0. In the ASM instance, the COMPATIBLE.RDBMS attribute for the disk group is set to 10.2 and the COMPATIBLE.ASM attribute is set to 11.1.Which two statements are true in this scenario for the features enabled for ASM? ()

A. The ASM-preferred mirror read feature is enabled.

B. The ASM supports variable sizes for extents of 1, 8, and 64 allocation units.

C. The ASM disk is dropped immediately from a disk group when it becomes unavailable.

D. The RDBMS always reads the primary copy of a mirrored extent of the ASM disk group.


参考答案

更多 “ You are managing an Oracle 11g database with ASM storage, for which the COMPATIBLE initialization parameter is set to 11.1.0. In the ASM instance, the COMPATIBLE.RDBMS attribute for the disk group is set to 10.2 and the COMPATIBLE.ASM attribute is set to 11.1.Which two statements are true in this scenario for the features enabled for ASM? ()A. The ASM-preferred mirror read feature is enabled.B. The ASM supports variable sizes for extents of 1, 8, and 64 allocation units.C. The ASM disk is dropped immediately from a disk group when it becomes unavailable.D. The RDBMS always reads the primary copy of a mirrored extent of the ASM disk group. ” 相关考题
考题 What are the recommendations for Oracle Database 11g installation to make it Optimal Flexible Architecture (OFA)-compliant? () A. ORACLE_BASE should be set explicitly.B. An Oracle base should have only one Oracle home created in it.C. Flash recovery area and data file location should be on separate disks.D. Flash recovery area and data file location should be created under Oracle base in a non-Automatic Storage Management (ASM) setup.

考题 YoucreatedtheDEPTtablebyusingthefollowingcommand:CREATETABLEscott.dept(deptnoNUMBER(3),dnameVARCHAR2(15),locVARCHAR2(15))STORAGE(INITIAL100KNEXT50KMAXEXTENTS10PCTINCREASE5FREELISTGROUPS6FREELISTS4);YouarerequiredtoshrinktheDEPTtable.Whileperformingtheshrinkoperation,youwanttoensurethattherecoveredspaceisreturnedtothetablespaceinwhichtheDEPTtableisstored.YoudonotwanttoshrinktheindexescreatedontheDEPTtable.WhatwillyoudotoshrinktheSCOTT.EMPtable?()

考题 ViewtheExhibitandnotethefilesavailableinthe$ORACLE_HOME/dbsfolder.TheASMinstanceisalreadyrunning.Youusedthefollowingstepstostartthedatabaseinstanceandopenthedatabase:Whichfileisusedtostarttheinstanceinthiscase()A.init.oraB.spfile.oraC.initorcl.oraD.spfile+ASM.ora

考题 YouareaDatabaseAdministratorwithWonderWeb.You&en YouareaDatabaseAdministratorwithWonderWeb.YouuseapasswordfiletoestablishconnectionstotheSalesdatabaselocatedontheserver.Youcreatedthepasswordfileusingthefollowingcommand:ORAPWDfile=d:\oracle\ora9i\orapwU01password=adminentries=4Youerroneouslydeletedthepasswordfilewhilethedatabasewasrunning.Youre-createthepasswordfileusingthefollowingcommand:ORAPWDfile=d:\oracle\ora9i\orapwU01password=change_on_installentries=4However,whenyoutrytoconnectastheSYSuser,youreceivethefollowingerror:ORA-01031:insufficientprivilegesWhatshouldyoudotoresolvethiserror?()

考题 Youhavecontrol-fileautobackupsenabled.WhenstartingyourdatabasefromSQL*Plus,youreceivethefollowingerrormessage:SQLstartupORA-01078:failureinprocessingsystemparametersLRM-00109:couldnotopenparameterfile,C:\ORACLE\PRODUCT\11.1.0\DB_1\DATABASE\INITORCL.ORAUsingRMAN,howwouldyourespondtothiserror?()A.Issuethestartupnomountcommandandthenissuetherestoreparameterfilecommandfromthe RMANprompt.B.IssuethestartupnomountcommandandthenissuetherestorespfilecommandfromtheRMANprompt.C.Issuethestartupnomountcommandandthenissuetherestorespfilefromautobackupcommand fromtheRMANprompt.D.Issuethestartupnomountcommandandthenissuetherestorespfilefrombackupcommand from theRMANprompt.E.IssuetherestorespfilefromautobackupcommandfromtheRMANprompt.

考题 Whichofthefollowingisnotaconfigurableattributeforanindividualdiskgroup?() A.AU_SIZEB.COMPATIBLE·RDBMSC.COMPATIBLE·ASMD.DISK_REPAIR_TIMEE.DG_DROP_TIME

考题 ORACLE初始化参数文件的默认路径是:() A.对于UNIX,在$ORACLE_HOME/dbsB.对于UNIX,在$ORACLE_HOME/dbs/adminC.对于Linux,在%ORACLE_HOME%\databaseD.对于Windows,在%ORACLE_HOME%\dbsE.对于Windows,在%ORACLE_HOME%\database\admin

考题 当启动一个Oracle实例时,初始化参数()指出为数据文件信息保留的SGA空间的数量。 A.DB_FILESB.DB_DATAFILESC.DATABASE_FILESD.LOG_FILES

考题 Deploying the cisco unified computing system platform into the data center provides which two benefits?() A.it leverages low-speed interfacesB.only one configuration is used for all bladesC.storage, computing and networking services are combined onto one bladeD.it is A pra-as-you-go incremental deploymentE.server replacement is as easy as replacing the physical blade

考题 下面哪一个语句创建了值为storage的宏变量location? ()A.let location = storage;B.let location = storage;C.%let location = "storage";D.%let location = storage;