|
158.Youwanttocreateatablespacewiththefollowingspecifications:,皇冠新网址 答案：D
SQL>ALTERSESSIONRECYCLEBIN=ON; D)restorethedatafilesfrombackupandperformcancel-basedrecovery D)functionbased 2.Copythecontrolfiletonewlocation. C)Viewscanbecreatedonthebasisofmorethanonetable. A)Theoperationwouldfailiftbs_1werearead-onlytablespace. 166.AusercomplainsaboutgettingthiserrorafterissuingacertainSQLstatement: D)multiplexingofcontrolfiles TheSCOTTuserhasbeengrantedtheCONNECTandRESOURCErolesonly.Thedatabaseadministrator(DBA)grantsMGR_ROLEtotheSCOTTuserbyusingthiscommand: B)SCHEMAS B)Setthelimitsintheprofilesusedbyusers. A)RuntheSQLAccessAdvisor. IDENTIFIEDBYoracle B)Onlythetimedoperatingsystem(OS)statisticsandplanexecutionstatisticsarecollected.
E)configuringthedatabaseinARCHIVELOGmode SQL>GRANTMGR_ROLETOSCOTTWITHADMINOPTION; 答案：A
B)Whenyoudeletearowfromthedepttable,youwouldreceiveaconstraintviolationerror. WhichstatementistrueabouttheSCOTTuserafterheisgrantedthisrole? A)ThetablespaceTBS1isfull.
B)HRcangranttheprivilegetoJIMbecauseHRistheowneroftheview. 谜底：BD 答案：D C)GiveanalystsDBAprivilege,sothattheycanqueryDBA_EXTERNAL_TABLES. D)2,3,1,4 164.ViewtheExhibit. C)ItcreatestheInventorypointerfile.
ORA-02393:exceededcalllimitonCPUusage
B)LoadthedataintoyourdatabasebyusingthePARALLELclause. A)usetheexternaltablepopulation Selectthecorrectorderinwhichthesetasksneedtobeperformed. B)Theusermustbelistedinthepasswordfilefortheauthentication. A)recoverusingOracleFlashbackDatabasetechnology E)Whenyoudeletearowfromthedepttable,automaticallythecorrespondingrowsareupdatedwithnullvaluesintheemptable. Tablecreated. 相干视频：http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
C)Onstartup,useRMANtoperforminstancerecovery.
答案：A B)TheSCOTTusercangranttheprivilegesintheMGR_ROLEroletootherusersbutnotwithADMIN_OPTION.
/u01/app/oracle/admin/ORCL/udump/orcl_ora_3173.trc.
Inwhichtablespacewillthematerialtablebecreated?
C)ComparethecontentsoftheinstallActions.logfilewiththatoftheresponsefile.
B)Thedictionarycacheisconsumingmorespacethanthelibrarycache. 128.YourdatabaseisstartedwithSPFILE.Youwantthedatabaseinstancetobedynamicallyregisteredwitha B)droppingthedatabaseuser 130.ViewtheExhibit. 答案：AC limitinthesubsequentsessionsoftheuser? F)Onstartup,allthefileswillbesynchronizedandyougetbothcommittedanduncommitteddata. C)UseEnterpriseManagertocreateanewdatabasewiththeOnlineTransactionProcessing(OLTP)option. A)configurethedatabasetoruninARCHIVELOGmode 答案：AE D)HRneedstheSELECTprivilegeontheEMPtablewithGRANTOPTIONfromSCOTTforthisoperation.
答案：C E)schedulethedatabasebackupusingDatabaseConfigurationAssistant(DBCA)whilecreatingthedatabase
147.Youhavealargeamountofhistoricaldatainanoperatingsystemfile.Someanalystsinyourorganizationneedtoquerythisdata.Thefileistoolargetoloadintoyourcurrentdatabase.Whichisthemosteffectivemethodtoaccomplishthetask? 1.Thetablespaceextendsautomatically. C)TheuserdoesnothavequotaontheTBS1tablespace. A)FULL
A)DROPUSERSMITH; C)Thetableisremovedfromthedatabasepermanently. A)renamingofdatafiles B)LoadthedataintoyourdatabasebyusingthePARALLELclause. D)usethedirectpathdataloadofOracleexportandimportutility TheDBAcreatesanewuserasfollows:
答案：D 138.Whichnamingmethodusesthetnsnames.orafiletostoretheconnectdescriptorusedbytheclientwhileconnectingtothedatabaseinstancefromaremotemachine? -USERSisthedefaultpermanenttablespace C)useDBCAtocreateatemplatefromtheexistingdatabasetocontainthedatabasestructureandthenmanuallycopythedatausingOracleDataPump -UNDOTBS1isthedefaultundotablespace E)tablespacewithsegmentspacemanagementasautomatic ORA-01950:noprivilegesontablespace 4.Restarttheinstance. 134.Youareworkingonanonlinetransactionprocessing(OLTP)system.YounoticethataPL/SQLproceduregotexecutedtwiceat2:00p.m.ThishasincorrectlyupdatedtheEMP_SALtable.Howwouldyourevertthetabletoitsstateat2:00p.m.? B)DROPTABLEEMPLOYEES;
A)Modifytheresourcelimitintheprofileusedbytheuser. 162.Examinethefollowingcommandsexecutedinyourdatabase: C)TheSCOTTusercangrantonlytheMGR_ROLEroletootherusersbutnottheprivilegesinit. D)Thetablespace-levelloggingattributecanbeoverriddenbyloggingspecificationsatthetable,皇冠足球吧,index,materializedview,materializedviewlog,andpartitionlevels. Whathappensinthisscenario? 答案：ACD WhatwouldhappenifyouchangethevalueofDesiredMeanTimeToRecoverto30? 129.ThejuniorDBAinyourorganizationhasaccidentallydeletedthealertlogfile.Whatwillyoudotocreatenewalertlogfile? A)CreatethenewtextfilefileasALERT.LOG. SQL>CREATEUSERmanfusIDENTIFIEDBYmanfusTEMPORARYTABLESPACEtemp; Becauseoftheerror,theSQLstatementgetsaborted.WhatactionwouldyoutaketoincreasetheCPUusage
答案：E
答案：D B)Theoperationwouldfailiftbs_1werearead/writetablespace. A)Upgradethehardware/memorytoaccommodatethedata. Tabledropped. C)GiveanalystsDBAprivilege,sothattheycanqueryDBA_EXTERNAL_TABLES. B)useDatabaseConfigurationAssistant(DBCA)tocreateatemplatefromtheexistingdatabasetocontainthedatabasestructure
答案：C D)ThesnapshotsfortheAutomaticWorkloadRepository(AWR)arenotgeneratedautomatically. NowHRwantstogranttheSELECTprivilegeontheEMP_VviewtotheJIMuser.Whichstatementistrueinthisscenario?
D)runtheAutomaticDatabaseDiagnosticMonitor(ADDM)ontopSQLstatements 答案：DF C)Restoretheentiredatabasefromtherecentbackupandopenit. 答案：B 131.YouareusingthebackupschedulerinEnterpriseManager(EM)toscheduleabackupofyourdatabase.Whichtypeofscriptdoesthebackupschedulergenerate?
144.WhichtwostatementsregardingtheLOGGINGclauseoftheCREATETABLESPACE...statementarecorrect?(Choosetwo.) C)ThesharedpoolsizeshouldbeincreasedtoaccommodatetheSQLstatements. B)ThetableismovedtotheSYSTEMtablespace. B)Itcreatesthebasedirectory. A)B-tree
141.Youhavealargeamountofhistoricaldatainanoperatingsystemfile.Someanalystsinyourorganizationneedtoquerythisdata.Thefileistoolargetoloadintoyourcurrentdatabase.Whichisthemosteffectivemethodtoaccomplishthetask? 154.WhichtwooperationscanbeflashedbackusingtheFlashbacktechnology?(Choosetwo.) B)restorethedatafilesfrombackupandperformacompleterecovery Further,youexecutedthefollowingcommandtodropthetable: -TEMPisthedefaulttemporarytablespace DBA3群：63306533;聊天群：40132017 D)EnterpriseManager(EM)script
B)UsetheDatabaseConfigurationAssistant(DBCA)tocreatethedatabasewithOracle-managedfiles. A)HRcangranttheprivilegetoJIMbutwithoutGRANTOPTION. D)Datamanipulationlanguage(DML)operationscannotbeperformedonviews. A)Itcreatesthepointerfile. 答案：D 123.ViewtheExhibit. A)runSegmentAdvisor C)ChangethevaluefortheBACKGROUND_DUMP_DESTparameter.
C)REMAP_SCHEMA 160.Youareusingflatfilesasthedatasourceforoneofyourdatawarehousingapplications.YouplantomovethedatafromtheflatfilestructurestoanOracledatabasetooptimizetheapplicationperformance.Inyourdatabaseyouhaveclusteredtables.Whilemigratingthedata,youwanttohaveminimalimpactonthedatabaseperformanceandoptimizethedataloadoperation.WhichmethodwouldyouusetoloaddataintoOracledatabase? C)examinethetracefilefordetailsandasktheuserwhocausedthedeadlocktorollbackthetransaction A)Onstartup,SMONcoordinatesinstancerecovery. E)LD_LIBRARY_PATH C)ItcanbeperformedtorecoverALTERTABLEstatements Port:1525
D)TheuserdoesnothavesufficientsystemprivilegestocreatetableintheTBS1tablespace. A)createadatabasebyusingCREATEDATABASE..commandandmanuallycopythedata 答案：D TZsettoAmerica/New_york 答案：CD
149.Youexecutethefollowingsetofcommandstocreateadatabaseuserandtograntthesystemprivilegesinyourproductionenvironment. A)SQLscript E)sharedrow-exclusivelockfortherowbeingupdated
D)directorynamingmethod 答案：B TEMPORARYTABLESPACEtemp C)usetheconventionalpathdataloadofSQL*Loaderutility A)TEMP
D)Noactionrequired.Thefilewouldbecreatedautomaticallybytheinstance. 1.Shutdownthedatabaseinstance.
C)externalnamingmethod
SQL>CREATETABLEempTABLESPACEtbsfdASSELECT*FROMhr.employees; A)TheMTTRAdvisorwouldbeenabled. Whatcouldbethepossiblereasonforthiserrormessage?
G)exclusivetable-levellockforthetablecontainingtherow
163.WhenyoutrytostarttheDatabaseControlbyusingtheemctlstartdbconsolecommandthefollowingerrorisdisplayed: C)USERS B)nulllockonthetablecontainingtherow A)Performpoint-in-timerecoveryto2:00p.m. Whileexecutingthecommandtocreateatable,theusergetsthefollowingerrormessageandtheCREATE E)OracleDataPumpwouldexportallofthetablestructuresandtheviewdefinitionswithdatawhereviewnamecontainsastringnamedDEPARTMENTS. 答案：AB Sessionaltered 3.RestartL2. B)RuntheSQLTuningAdvisor(STA). C)runtheAutomaticWorkloadRepository(AWR)report 答案：E C)ORACLE_HOME 152.TheST_INFOmastertablehasmillionsofrowsthatareupdatedveryrarely.IthasaSTATE_CODEcolumnthatcontainsthevaluefor25states.ThetableisfrequentlyqueriedontheSTATE_CODEcolumn.Whichtypeofindexwouldyousuggesttoimprovethequeryperformance?
答案：D 132.Youareinthemiddleofatransactionandverycrucialdatahasbeenmodified.Becauseofahardwarefailure,theinstancehasshutdownbeforesynchronizingallthedatabasefiles.Whichtwostatementsaretrue?(Choosetwo.) D)Itfailswhenundodatapertainingtothetransactionisoverwritten. Usermanfuscreatesatableasfollows: A)nulllockontherowbeingupdated 答案：D ------------------------------------------------------------------------------ $expdpscott/tiger C)SCOTThastogranttheSELECTprivilegeontheEMPtabletoJIMbeforethisoperation. D)PreparingindexesonthetablesusedintheSQLstatementswouldimprovethelibrarycacheperformance. D)Theredologfromlogbufferswouldbewrittentoredologfilesataslowerrate. B)RefertothecontentsoftheoraInst.locfiletoverifythestepsperformedbyOUI.
B)bitmap content=DATA_ONLY Blog：http://blog.csdn.net/tianlesoftware E)REMAP_TABLESPACE
D)Useanexternaltablesoyoucanhavethemetadataavailableinyourdatabase,butleavethedataintheoperatingsystemfiles. A)Theinstanceaborts.
A)Itisgeneratedbyusingtheredologfiles.
151.Youralertlogfilehasthefollowinginformation: B)ItcanbeconvertedtoaB-treeindexbyusingtheALTERINDEXcommand. F)UNDOTBS1
答案：A A)Itisrecommendedforthecolumnsthathaveuniquevalues. A)Whenyoudeletearowfromtheemptable,youwouldreceiveaconstraintviolationerror. B)localnamingmethod C)Theoperationwouldfailiftbs_1werethedefaulttablespaceforthedatabase. C)Automaticcheckpointtuningwouldbedisabled. E)restoretheentiredatabasefromthemostrecentbackupandstarttheinstanceandopenthedatabase
B)Thedatabasecannotberecovered. 2.MakeanentryforL2intnsnames.oraonthedatabaseserver.
D)IncreasethevalueoftheSESSION_MAX_OPEN_FILESinitializationparameter.
B)usetheOracleDataPumpexportandimportutility 3.DefaultPCTUSEDattributeissetto60. B)Ithelpsinrow-levelrecoveryfromusererrors. 161.Youwanttoprotectyourdatabasefromsinglepointoffailurebymultiplexingthecontrolfile.YourdatabaseisstartedusingSPFILE.Youhavetoperformthefollowingtasks: 135.ViewtheExhibit. E)SYSTEM F)Whenyoudeletearowfromtheemptable,automaticallythecorrespondingrowsareupdatedwithnullvaluesinthedepttable. A)hostnamingmethod E)Iftheaboveoperationweresuccessful,instancerecoverywouldberequiredtobringthetablespaceonline.
A)1,2,4,3 153.YourdatabaseisinNOARCHIVELOGmodeandalogswitchhappensevery20minutes.OnThursdaymorning,mediafailureresultedincorruptionofadatafilebelongingtotheTOOLStablespace.BackupsaretakenoneverySunday.Whatwouldyoudointhissituation?
A)TheSCOTTusercangranttheMGR_ROLEroleandtheprivilegesinittootherusers. D)examinethetracefilefordetailsandrememberthatdeadlocksareresolvedautomaticallybyOracledatabase E)Theuserdoesnothavesufficientprivilegestocreatetableonthedefaultpermanenttablespace. D)1,hg0088.com,2;3and4arenotrequired.
C)schedulethedatabasebackupusingDBMS_JOBpackageaftercreatingthedatabase B)TheuserisnottheowneroftheSYSTEMtablespace.
答案：A Whatwouldyoudotoensurethatdatabaseisstillrunningcorrectly? Protocol:TCP C)ModifytheSESSIONSinitializationparameter. 146.Inyourdatabase,theSTATISTICS_LEVELinitializationparameterissettoBASIC.Whatistheimpactofthissetting? B)PROD 2.Usedandfreeextentsshouldbemanagedbybitmaps. TueMay2517:43:382004 答案：D A)Theusersshouldusebindvariablesinsteadofliteralsinthequery. A)OracleDataPumpwouldexportonlythedataofallofthetablesandviews. 答案：C B)TheRedoLogAdvisorwouldbedisabled. 答案：C 网上资源：http://tianlesoftware.download.csdn.net E)examinethetracefilefordetailsandusetheUndoAdvisortorollbackthetransactionthatcausedthedeadlock E)SnapshotscannotbecollectedmanuallybyusingDBMS_WORKLOAD_REPOSITORYPACKAGE. D)ROWEXCLUSIVElockfortherowbeingupdated 4.Modifythelistener.orafiletoaddtheinstancenameinSID_LISTofL2. B)SettheRESOURCE_LIMITinitializationparametertoFALSE. D)Iftheaboveoperationweresuccessful,皇冠走地,mediarecoverywouldberequiredtobringthetablespaceonline.
Whichthreeoptionswouldyouchoosetocreatethetablespace?(Choosethree.) 136.ViewtheExhibittoobservetheprivilegesgrantedtotheMGR_ROLErole. C)2,1;3and4arenotrequired. SQL>GRANTcreatesession,皇冠足球网址导航,createtableTOuser01; B)Viewsaredatasegmentsliketables. 155.WhilesettingupanOracledatabaseforoneofyourcriticalapplications,youwanttoensurethatthedatabaseisbackedupatregularintervalswithoutyourintervention.Whatshouldyoudotoachievetheobjective? 150.WhichtwostatementsaboutFlashbackQueryaretrue?(Choosetwo.) 答案：C
C)reversekey 127.WhilerunningtheOracleUniversalInstalleronaUnixplatformtoinstallOracleDatabase10gsoftware,youarepromptedtorunorainstRoot.shscript.Whatdoesthisscriptaccomplish? dumpfile=scott.dmp
C)RuntheAutomaticWorkloadRepository(AWR)report. C)OperatingSystem(OS)script A)UsetheCREATEDATABASE..commandtocreatethedatabasewithOracle-managedfiles. 答案：D D)Updatingthekeycolumnlocksthewholebitmapsegmentthatcontainsthebitforthekeyvaluetobeupdated. D)Whenyoudeletearowfromthedepttable,automaticallythecorrespondingrowsaredeletedfromtheemptable.
A)tablespacewithAUTOEXTENDenabled
125.ViewtheExhibitandexaminetheoutput. 答案：AD C)OracleDataPumpwouldexportthetabledataandtheviewdefinitionswheretheviewnamecontainsastringnamedDEPARTMENTS. Whichstatementregardingthedeptandemptablesistrue? C)TheOracleserverdynamicallygeneratesthenecessarystatisticsontablesaspartofqueryoptimization.
C)ThetablespacewillbeintheNOLOGGINGmodebydefault,ifnotspecifiedwhilecreatingatablespace. A)Thisclauseisnotvalidforatemporaryorundotablespace. 答案：B ERRORatline1: 142.Whichtwostatementsaretrueaboutabitmapindex?(Choosetwo.) 答案：C
B)ORACLE_SID C)IncreasethevalueoftheSESSION_CACHED_CURSORSinitializationparameter. A)Theoptimizerstatisticsarecollectedautomatically.
WhichtwoenvironmentvariablesdoyouneedtosetappropriatelytoavoidsucherrorsandstarttheDatabaseControlsuccessfully?(Choosetwo.) 4.Alltheextentswouldbeofsize1MB. 124.UserScotthasupdatedthesalaryofoneoftheemployeesintheEMPLOYEEStableandhasnotcommittedthetransaction.Whatarethetwotypesoflocksthatthisscenariowouldleadto?(Choosetwo.) 148.TheHRusercreatesaviewwiththiscommand: D)RuntheAutomaticDatabaseDiagnosticMonitor(ADDM).
126.YourdatabaseisconfiguredinNOARCHIVELOGmode.Allthecontrolfileshavebeenlostduetoaharddiskfailurebutthedatafilesarenotlost.Youhavetheclosedwholedatabasebackupavailabletoyou.Whichtwostatementsaretrueinthisscenario?(Choosetwo.)
B)Youhavetorecoverthealertlogfilefromthevalidbackup. include=view："like'%DEPARTMENTS%'" 答案：BC C)tablespacewithauniformextentallocationof1MB B)runSQLTuningAdvisorontopSQLstatements D)ThetableisrenamedandremainsintheTBSFDtablespace. B)IfthetablespaceisintheNOLOGGINGmode,nooperationonthetablespacewillgenerateredo. 答案：B Whichtaskwouldthecommandaccomplish? 1.SettheLOCAL_LISTENERparametertoL2dynamically. D)RefertothealertlogfileforinformationregardingtheactionsperformedbyOUIduringinstallation. D)Issuetherollbackstatementwithsystemchangenumber(SCN). C)renamingofcontrolfiles A)examinethetracefileandkillthesessionthatcausedthedeadlock D)schedulethedatabasebackupusingRecoveryManager(RMAN)commandsaftercreatingthedatabase A)UsetheDatabaseResourceManager. Whichstatementdescribestheconclusion? D)REMAP_DATAFILES E)UsetheCREATEDATABASE..commandtocreatethedatabasewithAutomaticStorageManagement(ASM)filesystem. DEFAULTTABLESPACEtbs1 答案：AE A)ThetableismovedtotheSYSAUXtablespace.
D)useDBCAtocreateatemplatefromtheexistingdatabasetocontainthedatabasestructurewithdatafilesandthenusethesametemplatetocreatethedatabaseinthenewlocation YourOracle10gdatabasehas6tablespacesinwhich) B)Onstartup,CKPTcoordinatesinstancerecovery. 答案：C 答案：C D)TheSCOTTusercangranttheprivilegesintheMGR_ROLEroletootherusersbutcannotrevokeprivilegesfromthem. E)SYSTEM C)Ithasabitmapsegmentforeachdistinctvalueinthekeycolumn,containingastringofbitsinwhicheachbitrepresentsthepresenceorabsenceofakeycolumnvalue.
D)ALTERTABLESALES_REPDROPPARTITIONP1; 3.ConfiguretheCONTROL_FILESparameter. B)examinethetracefileandkillboththesessionsresponsibleforthedeadlock D)OracleDataPumpwouldexportthetabledataandtheviewdefinitionswithdatawhereviewnamecontainsastringnamedDEPARTMENTS. 答案：C /u01/app/oracle/product/10.1.0/db_1/oc4j/j2ee/OC4J_DBConsole_orcl.us.oracle.comnotfound.
/ listenerL2withthefollowingdetails: DBA1群：62697716(满);DBA2群：62697977
答案：D 122.YoureceivedcomplaintsaboutthedegradationofSQLqueryperformance.YouidentifiedtopSQLqueriesthatconsumetime.WhatwouldbeyournextsteptofindoutrecommendationsaboutstatisticscollectionandrestructuringoftheSQLstatementtoimprovequeryperformance? 答案：D D)SYSAUX include=table E)Onstartup,performmediarecoveryandtheninstancerecovery. 121.Youwanttocreateanewoptimizeddatabaseforyourtransactionalproductionenvironmenttobeusedbyafinancialapplication.Whilecreatingthedatabase,youwanttheOraclesoftwaretotakecareofallbasicsettingstooptimizethedatabaseperformance.Whichmethodwouldyouusetoachievethisobjective?
A)Comparethecontentsoftheinstall.logfilewiththeresponsefile. 答案：D C)restoreonlythecorrupteddatafileandperformtablespacerecovery ORA-00060:Deadlockdetected.Moreinfoinfile TABLE..commandfails. C)3,1,皇冠足球投注网,2,4 137.Whichtwostatementsaretrueaboutsimpleviews?(Choosetwo.) 140.Youworkinadatawarehouseenvironmentthatinvolvestheexecutionofcomplexqueries.ThecurrentcontentoftheSQLcacheholdstheidealworkloadforanalysis.Youwanttoanalyzeonlyfewmostresource-intensivestatements.Whatwouldbeyoursuggestiontoreceiverecommendationsontheefficientuseofindexesandmaterializedviewstoimprovequeryperformance?
D)SYSAUX D)ThedatabaseremainsopenedandyouhavetoshutitdownwiththeABORToption. 145.Youwanttomonitorandcontroltheresourceusagebysessions.Youwanttobewarnedautomaticallywhenmorethan100sessionsareopenedwithyourdatabase.Whatactionwouldyoutaketoachievethis? Whichisthecorrectorderofthestepsthatyouwouldfollowtoachievethis?
E)ALTERTABLEEMPLOYEESDROPCOLUMNDESIG_ID; 答案：BC A)Theusermustbegrantedthedatabaseadministrator(DBA)privilege. D)tablespacewithsegmentspacemanagementasmanual 159.WhichtwodatabaseoperationscanbeperformedattheMOUNTstageofdatabasestartup?(Choosetwo.)
SQL>CREATEUSERuser01 A)Upgradethehardware/memorytoaccommodatethedata. PROFILEdefault B)1,2,3;4isnotrequired. A)NLS_LANG A)1,2,3,4 D)Useanexternaltablesoyoucanhavethemetadataavailableinyourdatabase,butleavethedataintheoperatingsystemfiles. D)Uncommittedchangeswillberolledbackafterthedatabaseisopened. B)tablespacewithdictionary-managedextents E)ItmodifiestheUnixkernelparameterstomatchOracle'srequirement.
139.YourdatabaseisrunningintheARCHIVELOGmode.Youplacedatablespace,tbs_1,offlinewiththeimmediateoption.Whichstatementiscorrectinthisscenario? B)PROD 答案：E E)Thedatabasecanberestoredtillthepointofthelastclosedwholedatabasebackup. E)ThedatabasehastobeopenedwiththeresetlogsoptionafterperformingFlashbackQuery.
D)ORACLE_BASE
答案：AD C)DROPTABLESPACEUSERS; SQL>DROPTABLEemp;
143.UserSCOTTwantstoexporthisobjectsusingOracleDataPumpandexecutesthefollowingcommand:
B)configuretheFlashRecoveryAreatoenableautomaticdatabasebackup
OC4JConfigurationissue. 133.Afterbeinghiredasadatabaseadministrator,youfindthatthereisonlyonedatabasethatisfunctionalandthatisbeingaccessedbytheapplications.Youwanttocreateareplicaofthedatabase,皇冠搏彩,tobeusedfortestingpurposes.Whatisthebestmethodtocreatethereplica? C)NospecialsetupisneededfortheusertoconnectasSYSDBAiniSQL*Plus.
C)ROWSHARElockfortherowbeingupdated A)Viewscanbecreatedasreadonly. SQL>CREATEVIEWemp_vASSELECT*FROMscott.emp; B)PL/SQLscript B)UseFlashbackTablefeaturetorevertthechanges. B)OracleDataPumpwouldexportallofthetablestructuresalongwithdataandalltheviews. 157.WhichstepdoyouneedtoperformtoenableauserwiththeSYSDBAprivilegetologinasSYSDBAiniSQL*Plus? E)RecoveryManager(RMAN)script directory=EXPORT_DIR D)UseDatabaseConfigurationAssistant(DBCA)tocreatethedatabasewithTransactionProcessingtemplate. SQL>CREATETABLEmaterial(idNUMBER(3)); B)3,2,1,4 C)USERS 答案：C C)Thedatabasecanberecoveredbyrestoringthecontrolfilesfromthebackup. F)ashareabletablelockforthetablecontainingtherow 156.Youcreatedaresponsefileandwanttocheckitbeforestartinginstallationsinsilentmode.YoustartedinstallationofOraclesoftwareininteractivemodebyprovidingtheresponsefile.Inthemiddleoftheinstallation,yourealizethatthebehavioroftheOracleUniversalInstaller(OUI)isnotconsistentwiththeresponsefile.Whatactionwouldyoutaketodetectthecauseofthisbehavior? A)TEMP C)Whenyoudeletearowfromtheemptable,automaticallythecorrespondingrowsaredeletedfromthedepttable. D)ItcreatestheOracleuserforinstallation. Inthisdatabase,whichtwotablespacescanbemadereadonly?(Choosetwo.)
Host:indl151e D)SetupauserintheOracleApplicationServerContainersforJ2EE(OC4J)usermanager,andgrantthewebDbaroletotheuser. D)SetthewarningthresholdfortheCurrentLogonsCountmetric. 165.YouwanttomovealltheobjectsoftheAPPSuserinthetestdatabasetotheDB_USERschemaoftheproductiondatabase.WhichoptionofIMPDPwouldyouusetoaccomplishthistask? (责任编辑：admin) |
