单项选择题Managementhasdecidedthatthedatabasemustbeavailable24hoursaday,7daysaweek.Giventhisrequirement,whichtypeofbackupisrequired?()
单项选择题OnswitchR1youissuethe udldenable globalcommand.Whatdoesthiscommandaccomplish?()
单项选择题Whiledesigningyourdatabase,youhavecreatedtheEMPLOYEEStableasanindex-organizedtable(IOT).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.
单项选择题WhichofthefollowingisaprerequisiteforrunningDBMS_TDB.CHECK_DBtoasuccessfulcompletion?()
单项选择题YouaremaintainingyourOLTPdatabaseinOracle10g.YouhavenotsetthewarninglevelandcriticallevelthresholdvaluesforspaceusageoftheDATA1tablespace.Whatwillbetheimpact?()
单项选择题Whichisthememoryareathatiscreatedwhenadedicatedserverprocessisstarted,andcontainsdataandcontrolinformationforthatserverprocess?()
单项选择题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
单项选择题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.
单项选择题YourdatabaseisrunninginNOARCHIVELOGmodewith&ensp
单项选择题Whenyoucreateabackupcontrolfile,whereistheresultingfilewrittento?()
单项选择题WhatOracleprocessrunswhenthedatabaseisinARCHIVELOGmodebutnotwhenitisinNOARCHIVELOGmode?()
单项选择题Anadministratorneedstoreplaceafailedinternaldiskinamirroredrootvg.Whichofthefollowingisoneofthestepsthatmustbefollowed()
单项选择题ACustomerhasafunctionalserverdeploymentsolutionthatusesacombinationofdiskimagingandapplicationpushingtechnology.TheyneedtogetaworkingWindows2003imagefortheirnewserversassoonaspossible.Whatmethodcanachievethis?()A.InstallWindows2003usingtheF6supplyMassStorageControlleroptionB.ReplaceCustomer’sdeploymentsolutionwithTivoliProvisioningManagerforOS DeploymentDirectorEditionC.DeployCustomer’sexistingimageanduseUXSPitoupdateIBMspecificdriversD.UseServerGuidetoinstallWindows2003
单项选择题Duringreboot,thesystemhangswithanLED0554messagethatmeans,'Thebootdevicecouldnotbeopenedorareadfailed.'Whichofthefollowingrecoveryproceduresshouldbetaken()