找考题网-背景图
单项选择题

A.Pingsareallowedonlytospecificdevices.B.CDPinformation……

WhichstatementistruewhenICMPechoandecho－replyaredisabledonedgedevices？（）

A.Pingsareallowedonlytospecificdevices.
B.CDPinformationisnotexchanged.
C.Portscanscannolongerberun.
D.Somenetworkdiagnosticdataislost.
E.Wirelessdevicesneedtobephysicallyconnectedtotheedgedevice.
F.OSPFroutingneedsthecommandipospfnetworknon-broadcastenabled.
<上一题 目录 下一题>
热门试题

单项选择题WhichstatementcorrectlydescribesenablingBPDUguardonanaccessportthatisalsoenabledforPortFast？（）

A.Uponstartup，theporttransmits10BPDUs.IftheportreceivesaBPDU，PortFastandBPDUguardaredisabledonthatportanditassumesnormalSTPoperation.
B.TheaccessportignoresanyreceivedBPDU.
C.IftheportreceivesaBPDU，itisplacedintotheerror-disablestate.
D.BPDUguardisonlyconfiguredgloballyandtheBPDUfilterisrequiredforport-levelconfiguration.

单项选择题Inyourdatabase，youdiscoveredthatatempfileinalocallymanagedtemporarytablespacehasbeendeletedattheoperatingsystemlevel.Howwouldyourecoverthetablespace？（）

A.flashbackthedatabase
B.performpoint-in-timerecovery
C.performafulldatabaserecovery
D.dropandre-createthetablespace
E.useRecoveryManager（RMAN）torecoverthedatabase

单项选择题本地电子商务指的是().

A.在全世界范围内进行的电子交易活动,交易各方通过网络做生意
B.指利用本地区或者本城市的信息网络实现的电子商务活动
C.就是利用EDI网络进行电子交易
D.利用Internet网络进行电子交易

单项选择题Theaccountingmanagerwantsyoutocreateaformthatwhenqueriedwilldisplayacalculatedtotalofyear-to-dateactualexpendituresforthefundcodeentered.Thevalueneededtogeneratethissummarydataarestoredinmultipletables.HowwouldyoudefinethedatasourceforthisdatablockwithouthavingtheDBAcreateadatabaseobject?（）A.ChooseTools->DataBlockWizard,selectViewasthedatasourcetype,andbasetheblockonthecolumnsfromthebales.B.ChooseTools->DataBlockWizard,selectTableasthedatasourcetype,andbasetheblockonthecolumnsfromthetables.C.SelecttheDataBlocksnodeintheObjectNavigatorandclicktheCreatebutton.ChoosetobuildthedatablockmanuallyandaltertheQueryDataSourceColumnsandQueryDataSourceArgumentspropertiestoentertheSELECTstatement.D.SelecttheDataBlocksnodeintheObjectNavigatorandclicktheCreatebutton.Choosetobuildthedatablockmanually,altertheQueryDataSourceTypepropertyto‘Table‘,andentertheSELECTstatementintheQueryDataSourceNameproperty.E.ChooseTools->DataBlockWizard,selectStoredProcedureasthedatasourcetype,andbasetheblockonthecolumnsthetables.F.SelecttheDataBlocksnodeintheObjectNavigatorandclicktheCreatebutton.Choosetobuildthedatablockmanually.AltertheQueryDataSourceTypeto‘FROM‘clausequery‘,andentertheSELECTstatementintheQueryDataSourceNameproperty.

A.Thevalueneededtogeneratethissummarydataarestoredinmultipletables.HowwouldyoudefinethedatasourceforthisdatablockwithouthavingtheDBAcreateadatabaseobject?（）
A.ChooseTools->DataBlockWizard,selectViewasthedatasourcetype,andbasetheblockonthecolumnsfromthebales.
B.ChooseTools->DataBlockWizard,selectTableasthedatasourcetype,andbasetheblockonthecolumnsfromthetables.
C.SelecttheDataBlocksnodeintheObjectNavigatorandclicktheCreatebutton.ChoosetobuildthedatablockmanuallyandaltertheQueryDataSourceColumnsandQueryDataSourceArgumentspropertiestoentertheSELECTstatement.
D.SelecttheDataBlocksnodeintheObjectNavigatorandclicktheCreatebutton.Choosetobuildthedatablockmanually,altertheQueryDataSourceTypepropertyto‘Table‘,andentertheSELECTstatementintheQueryDataSourceNameproperty.
E.ChooseTools->DataBlockWizard,selectStoredProcedureasthedatasourcetype,andbasetheblockonthecolumnsthetables.
F.SelecttheDataBlocksnodeintheObjectNavigatorandclicktheCreatebutton.Choosetobuildthedatablockmanually.AltertheQueryDataSourceTypeto‘FROM‘clausequery‘,andentertheSELECTstatementintheQueryDataSourceNameproperty.

单项选择题WhichcomponentoftheSGAstoresparsedSQLstatementsisusedforprocesssharing?（）

A.Buffercache
B.Redologbuffer
C.PrivateSQLarea
D.Librarycache
E.Rowcache

单项选择题Managementhasdecidedthatthedatabasemustbeavailable24hoursaday，7daysaweek.Giventhisrequirement，whichtypeofbackupisrequired？（）

A.user-managedbackups.
B.partialdatabasebackups.
C.consistentdatabasebackups.
D.inconsistentdatabasebackups.

单项选择题OnswitchR1youissuethe udldenable globalcommand.Whatdoesthiscommandaccomplish？（）

A.Enablesallfiber-opticLANportsforUnidirectionalLINKDetection（UDLD）
B.EnablesallcoppermediaLANportsUnidirectionalLinkDetection（UDLD）
C.OverridesthedefaultUDLSsettingforallports
D.GloballyenablesallportsonthedeviceforUnidirectionalLinkDetection（UDLS）
E.Noneoftheotheralternativesapply

单项选择题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.