考题
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;