单项选择题

A.YouwanttocreateabitmapindexontheJOB_IDcolumntomakeque……

Whiledesigningyourdatabase，youhavecreatedtheEMPLOYEEStableasanindex-organizedtable（IOT）.YouwanttocreateabitmapindexontheJOB_IDcolumntomakequeriesfaster.Whichtaskmusthavebeencompletedsothatyouareabletocreatethebitmapindex？（）
A.Aprimarykeymusthavebeencreated.
B.Amappingtablemusthavebeencreated.
C.Anoverflowtablespacemusthavebeenspecified.
D.ThePCTTHRESHOLDoptionmusthavebeenspecified.

A.YouwanttocreateabitmapindexontheJOB_IDcolumntomakequeriesfaster.Whichtaskmusthavebeencompletedsothatyouareabletocreatethebitmapindex？（）
A.Aprimarykeymusthavebeencreated.
B.Amappingtablemusthavebeencreated.
C.Anoverflowtablespacemusthavebeenspecified.
D.ThePCTTHRESHOLDoptionmusthavebeenspecified.

<上一题目录下一题>

热门试题

单项选择题Whatistheimpactoftheresultsoftheoutputofthefollowingcommand？（）RMAN>reportunrecoverabledatabase；ReportoffilesthatneedbackupduetounrecoverableoperationsFileTypeofBackupRequiredName4fullorincrementalC： ORACLE ORADATA ORCL USERS01.DBFA.Therearenobackupsetswithanybackupsoftheusers01.dbfdatafile.B.Theusers01.dbfdatafilehashadunrecoverableoperationsoccurinit.Itwillneedtobebackeduporsomedatalossispossibleduringarecovery.C.Theusers01.dbfdatafileiscorrupted.D.Theusers01.dbfdatafilebackupexceedstheretentioncriteria.E.Thelastbackupoftheusers01.dbfdatafilefailedandmustbererun.

A.DBF
A.Therearenobackupsetswithanybackupsoftheusers01.dbfdatafile.
B.Theusers01.dbfdatafilehashadunrecoverableoperationsoccurinit.Itwillneedtobebackeduporsomedatalossispossibleduringarecovery.
C.Theusers01.dbfdatafileiscorrupted.
D.Theusers01.dbfdatafilebackupexceedstheretentioncriteria.
E.Thelastbackupoftheusers01.dbfdatafilefailedandmustbererun.

单项选择题WhichofthefollowingisaprerequisiteforrunningDBMS_TDB.CHECK_DBtoasuccessfulcompletion？（）

A.Thedatabasemustbeinread-writemode.
B.Thedatabasemusthavenoexternalfiles.
C.Thedatabasemustopeninread-onlymode.
D.Thedatabasemustbemountedbutnotopened.

单项选择题YouaremaintainingyourOLTPdatabaseinOracle10g.YouhavenotsetthewarninglevelandcriticallevelthresholdvaluesforspaceusageoftheDATA1tablespace.Whatwillbetheimpact？（）

A.Nowarninglevelorcriticallevelalertwillbegenerated.
B.Awarninglevelalertwillneverbegenerated，butacriticallevelalertwillbegeneratedwhen97percentspaceoftheDATA1tablespaceisused.
C.Acriticallevelalertwillneverbegenerated，butawarninglevelalertwillbegeneratedwhen85percentspaceoftheDATA1tablespaceisused.
D.Awarninglevelalertwillbegeneratedat85percentspaceusageoftheDATA1tablespace，andacriticallevelalertisgeneratedat97percentspaceusageoftheDATA1tablespace.

单项选择题Whichisthememoryareathatiscreatedwhenadedicatedserverprocessisstarted，andcontainsdataandcontrolinformationforthatserverprocess？（）

A.SGA
B.PGA
C.SharedPool
D.StreamsPool

单项选择题YouhavejustrunthissyntaxtostartthelistenerfromtheListenerControlutility：LSNRCTL>STARTStarting mstgelai oracle bin tnslsnr：pleasewait…Systemparameterfileis u01 oracle network admin listener.oraLogmessageswrittento u01 oracle network log listener.logListeningon：（DESCRIPTION=（ADDRESS=（PROTOCOL=tcp）（HOST=stc-sun01-server）（PORT=1521）））Connectingto…ThecommandcompletedsuccessfullyWhatisthenameoftheListeneryoustarted？（）A.TNSLSNRB.LISTENERC.LOCAL_LISTENERD.DEFAULT_LSRN

A.oraLogmessageswrittento/u01/oracle/network/log/listener.logListeningon：（DESCRIPTION=（ADDRESS=（PROTOCOL=tcp）（HOST=stc-sun01-server）（PORT=1521）））Connectingto…ThecommandcompletedsuccessfullyWhatisthenameoftheListeneryoustarted？（）
A.TNSLSNR
B.LISTENER
C.LOCAL_LISTENER
D.DEFAULT_LSRN

单项选择题ThedatabaseisrunninginARCHIVELOGmode.Examinetheinitializationparametersandtheirvaluessettoenablearchivingonyourdatabaseserver：LOG_ARCHIVE_FORMAT=arch_%t_%s_%r.arcLOG_ARCHIVE_DEST_1=’LOCATION= disk1 archive’DB_RECOVERY_FILE_DEST=’ u01 oradata’DB_RECOVERY_FILE_DEST_SIZE=20GWhichstatementistrueregardingthearchivedredologfiles（）A.Itwillbecreatedonthelocalfilesystem.B.ItwillbecreatedonlyintheFlashRecoveryArea.C.ItwillbecreatedinthelocationspecifiedbytheLOG_ARCHIVE_DEST_1parameterandthedefaultlocation$ORACLE_HOME dbs.D.ItwillbecreatedinthelocationspecifiedbytheLOG_ARCHIVE_DEST_1parameterandlocationspecifiedbytheDB_RECOVERY_FILE_DESTparameter.

A.Examinetheinitializationparametersandtheirvaluessettoenablearchivingonyourdatabaseserver：LOG_ARCHIVE_FORMAT=arch_%t_%s_%r.arcLOG_ARCHIVE_DEST_1=’LOCATION=/disk1/archive’DB_RECOVERY_FILE_DEST=’/u01/oradata’DB_RECOVERY_FILE_DEST_SIZE=20GWhichstatementistrueregardingthearchivedredologfiles（）
A.Itwillbecreatedonthelocalfilesystem.
B.ItwillbecreatedonlyintheFlashRecoveryArea.
C.ItwillbecreatedinthelocationspecifiedbytheLOG_ARCHIVE_DEST_1parameterandthedefaultlocation$ORACLE_HOME/dbs.
D.ItwillbecreatedinthelocationspecifiedbytheLOG_ARCHIVE_DEST_1parameterandlocationspecifiedbytheDB_RECOVERY_FILE_DESTparameter.

单项选择题YourdatabaseisrunninginNOARCHIVELOGmodewith&ensp

A.TheSALEStablecontainssalesinformationfortheorganization.TheSALEStablebelongstotheSALESTBtablespace.OnMonday，youinsert10rowsintotheSALEStable.Thecurrentlogsequencenumberis14.YouchangethetablespacestatusfromREADWRITEtoREADONLYfortheSALESTBtablespace.YoushutdownthedatabaseandtakeabackupoftheSALESTBtablespace.
B.YouchangethestatusfortheSALESTBtablespacefromREADONLYtoREADWRITE.Youinsert10morerowsintotheSALEStableandshutdownthedatabase.Thecurrentlogsequencenumberis15.

单项选择题Whenyoucreateabackupcontrolfile，whereistheresultingfilewrittento？（）

A.Thedatabaseuserdumpdestinationdirectory
B.Thedatabasediagnosticdestinationdirectory
C.To$ORACLE_HOME/rdbms
D.To$ORACLE_HOME/admin
E.Tothedirectoryandfilenameyouspecifyinthecommand

单项选择题WhatOracleprocessrunswhenthedatabaseisinARCHIVELOGmodebutnotwhenitisinNOARCHIVELOGmode？（）

A.MMON
B.LGWR
C.ARCH
D.ARWR
E.COPY

单项选择题Anadministratorneedstoreplaceafailedinternaldiskinamirroredrootvg.Whichofthefollowingisoneofthestepsthatmustbefollowed（）

A.Deallocaterootvgmirror
B.Usehotreplacemanager
C.Breakrootvgmirror
D.DeallocateLPsfromfaileddisk

单项选择题ACustomerhasafunctionalserverdeploymentsolutionthatusesacombinationofdiskimagingandapplicationpushingtechnology.TheyneedtogetaworkingWindows2003imagefortheirnewserversassoonaspossible.Whatmethodcanachievethis？（）A.InstallWindows2003usingtheF6supplyMassStorageControlleroptionB.ReplaceCustomer’sdeploymentsolutionwithTivoliProvisioningManagerforOS DeploymentDirectorEditionC.DeployCustomer’sexistingimageanduseUXSPitoupdateIBMspecificdriversD.UseServerGuidetoinstallWindows2003

A.TheyneedtogetaworkingWindows2003imagefortheirnewserversassoonaspossible.Whatmethodcanachievethis？（）
A.InstallWindows2003usingtheF6supplyMassStorageControlleroption
B.ReplaceCustomer’sdeploymentsolutionwithTivoliProvisioningManagerforOS
C.DeployCustomer’sexistingimageanduseUXSPitoupdateIBMspecificdrivers
D.UseServerGuidetoinstallWindows2003

单项选择题Duringreboot，thesystemhangswithanLED0554messagethatmeans，'Thebootdevicecouldnotbeopenedorareadfailed.'Whichofthefollowingrecoveryproceduresshouldbetaken（）

A.Bootinmaintenancemodeandusefscktocheckhd5.
B.Bootinmaintenancemode，accesstherootvgandcheckthe/etc/inittabforcorruption.
C.Bootinmaintenancemode，accesstherootvgandrebuildthebootimageusingthebosbootcommand.
D.Bootinmaintenancemode，andresettherootpassword.

单项选择题ToloadthebaseoperatingsystemonamachineusingNIM，whataretheminimumNIMresourcesthatmustbedefinedfortheinstallationtosucceed（）

A.Amksysbresource，aSPOTresource，andanlpp_sourceresource
B.ASPOTresource，anlpp_sourceresource，andamachinedefinition
C.Anlpp_sourceresource，amksysbresource，andamachinedefinition
D.ASPOTresource，anlpp_sourceresource，abosinst_dataresource，andamachinedefinition

单项选择题Youhaveacomputerthathasthefollowinghardwareconfiguration:.1.6-gigahertz(GHz)processor(64-bit).8-GBRAM.500-GBharddisk.Graphicscardthathas128-MBRAM.YouneedtoselectaneditionofWindow7tomeetthefollowingrequirements:SupportDirectAccessSupportWindowsXPModeUsealloftheinstalledmemory SupportjoininganActiveDirectorydomain.Whicheditionshouldyouchoose？（）A.Windows7Enterprise（64-bit）B.Windows7Enterprise（x86）C.Windows7Professional（64-bit）D.Windows7Ultimate（x86）

A.1.6-gigahertz(GHz)processor(64-bit).8-GBRAM.500-GBharddisk.Graphicscardthathas128-MBRAM.YouneedtoselectaneditionofWindow7tomeetthefollowingrequirements:SupportDirectAccessSupportWindowsXPModeUsealloftheinstalledmemory
B.Whicheditionshouldyouchoose？（）
A.Windows7Enterprise（64-bit）
C.Windows7Enterprise（x86）
D.Windows7Professional（64-bit）
E.Windows7Ultimate（x86）

单项选择题YourenvironmentincludesmultipleWindowsServer2008R2Hyper-Vservers.Youaredesigninganadministrativestrategyforvirtualmachines（VMs）.YouneedtoensurethatmembersoftheSecurityComplianceActiveDirectoryDomainServices（ADDS）securitygroupcanmonitorfailedlogoneventsontheVMs.Whatshouldyoudo？（）A.AddtheSecurityCompliancegrouptothelocaladministratorsgroupofeachVMB.AddtheSecurityCompliancegrouptothelocaladministratorsgroupofeachHyper-VserverC.IntheInitialStore.xmlfileofeachVM，defineanaccesspolicyfortheSecurityCompliancegroupD.intheInitialStore.xmlfileofeachHyper-Vserver，defineanaccesspolicyfortheSecurityCompliancegroup

A.Youaredesigninganadministrativestrategyforvirtualmachines（VMs）.YouneedtoensurethatmembersoftheSecurityComplianceActiveDirectoryDomainServices（ADDS）securitygroupcanmonitorfailedlogoneventsontheVMs.Whatshouldyoudo？（）
A.AddtheSecurityCompliancegrouptothelocaladministratorsgroupofeachVM
B.AddtheSecurityCompliancegrouptothelocaladministratorsgroupofeachHyper-Vserver
C.IntheInitialStore.xmlfileofeachVM，defineanaccesspolicyfortheSecurityCompliancegroup
D.intheInitialStore.xmlfileofeachHyper-Vserver，defineanaccesspolicyfortheSecurityCompliancegroup