WhichofthefollowingisaprerequisiteforrunningDBMS

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

WhichofthefollowingisaprerequisiteforrunningDBMS_TDB.CHECK_DBtoasuccessfulcompletion？（）