oracle OPC 题库 1z0042Word文档格式.docx
《oracle OPC 题库 1z0042Word文档格式.docx》由会员分享,可在线阅读,更多相关《oracle OPC 题库 1z0042Word文档格式.docx(46页珍藏版)》请在冰点文库上搜索。
C.undoblocksgeneratedpersecond
E.thevalueoftheUNDO_RETENTIONparameter
2:
YouexecutedtheSTARTUPMOUNTcommandtostartyourdatabase.ForwhichdatabaseoperationdoyouneedtostartthedatabaseintheMOUNTstate?
C.enablingordisablingredologarchiving
3:
Youwanttocreateanewoptimizeddatabaseforyourtransactionalproductionenvironmenttobeusedbyafinancialapplication.Whilecreatingthedatabase,youwanttheOraclesoftwaretotakecareofallbasicsettingstooptimizethedatabaseperformance.Whichmethodwouldyouusetoachievethisobjective?
D.UseDatabaseConfigurationAssistant(DBCA)tocreatethedatabasewithTransactionProcessingtemplate.
4:
Whichthreestatementsaretrueaboutthestagesofdatabasestartup?
A.DatafilesandredologfilescanberenamedattheMOUNTstage.
D.DatafilesandredologfilesaremadeavailabletousersattheOPENstage.
E.Datafilesandonlineredologfilesarecheckedforconsistencywhileopeningthedatabase.
5:
AconstraintinatableisdefinedwiththeINITIALLYIMMEDIATEclause.YouexecutedtheALTERTABLEcommandwiththeENABLEVALIDATEoptiontoenabletheconstraintthatwasdisabled.Whatarethetwoeffectsofthiscommand?
(Choosetwo.)
A.Itfailsifanyexistingrowviolatestheconstraint.
D.Itpreventsinsert,update,anddeleteoperationsonthetablewhiletheconstraintisintheprocessofbeingenabled.
6:
YoureceivedcomplaintsaboutthedegradationofSQLqueryperformance.YouidentifiedtopSQLqueriesthatconsumetime.WhatwouldbeyournextsteptofindoutrecommendationsaboutstatisticscollectionandrestructuringoftheSQLstatementtoimprovequeryperformance?
B.runSQLTuningAdvisorontopSQLstatements
7:
TheUNDO_RETENTIONparameterinyourdatabaseissetto1000andundoretentionisnotguaranteed.Whichstatementregardingretentionofundodataiscorrect?
D.Committedundodatawouldberetainedfor1,000secondsiffreeundospaceisavailable.
8:
ViewtheExhibit.
Whichstatementregardingthedeptandemptablesistrue?
D.Whenyoudeletearowfromthedepttable,automaticallythecorrespondingrowsaredeletedfromtheemptable.
9:
Whichthreestatementsarecorrectabouttemporarytables?
A.Indexesandviewscanbecreatedontemporarytables.
C.Temporarytablesarealwayscreatedinauser'
stemporarytablespace.
E.Datamanipulationlanguage(DML)locksareneveracquiredonthedataoftemporarytables.
10:
WhichstatementregardingthecontentsoftheV$PARAMETERviewistrue?
C.displaysthecurrentlyineffectparametervalues
11:
Accordingtoyourbackupstrategy,youperformedanincrementallevel0backupofyourdatabase.Whichstatementregardingthisbackupistrue?
B.Thebackupcontainsalluseddatablocks.
12:
WhichstepdoyouneedtoperformtoenableauserwiththeSYSDBAprivilegetologinasSYSDBAiniSQL*Plus?
D.SetupauserintheOracleApplicationServerContainersforJ2EE(OC4J)usermanager,andgrantthewebDbaroletotheuser.
13:
Becauseofapoweroutage,instancefailurehasoccurred.Fromwhatpointintheredologdoesrecoverybeginandwheredoesitend?
B.checkpointpositiontoendofredolog
14:
WhichtwostatementsaretrueregardingthedatabaseinARCHIVELOGmode?
C.Youcanperformcompletedatabasebackupswithoutclosingthedatabase.
E.AllthepreviousdatabasebackupsbecomeinvalidafteryouconfigurethedatabasetoARCHIVELOGmode.
15:
UserScotthasupdatedthesalaryofoneoftheemployeesintheEMPLOYEEStableandhasnotcommittedthetransaction.Whatarethetwotypesoflocksthatthisscenariowouldleadto?
D.ROWEXCLUSIVElockfortherowbeingupdated
F.ashareabletablelockforthetablecontainingtherow
16:
Younoticethiswarninginthealertlogfile:
ORA-19815:
WARNING:
db_recovery_file_dest_sizeof3221225472bytesis100.00%used,andhas0remainingbytesavailable.
WhatwouldyoudotoreclaimtheusedspaceintheFlashRecoveryArea?
A.BackuptheFlashRecoveryArea.
C.Decreasetheretentiontimeforthefiles.
17:
ViewtheExhibitandexaminetheoutput.
Whichstatementdescribestheconclusion?
A.Theusersshouldusebindvariablesinsteadofliteralsinthequery.
18:
Whichtwooperationsrequireundodata?
B.rollingbackatransaction
C.recoveringfromfailedtransactions
19:
YourdatabaseisconfiguredinNOARCHIVELOGmode.Allthecontrolfileshavebeenlostduetoaharddiskfailurebutthedatafilesarenotlost.Youhavetheclosedwholedatabasebackupavailabletoyou.Whichtwostatementsaretrueinthisscenario?
A.Theinstanceaborts.
E.Thedatabasecanberestoredtillthepointofthelastclosedwholedatabasebackup.
20:
WhichisthecorrectdescriptionofthesignificanceoftheORACLE_HOMEenvironmentalvariable?
A.ItspecifiesthedirectorycontainingtheOraclesoftware.
21:
WhilerunningtheOracleUniversalInstalleronaUnixplatformtoinstallOracleDatabase10gsoftware,youarepromptedtorunorainstRoot.shscript.Whatdoesthisscriptaccomplish?
C.ItcreatestheInventorypointerfile.
22:
YoufindthatthedatabaseperformancedegradeswhileyoubackupthePRODdatabaseusingRecoveryManager(RMAN).ThePRODdatabaseisrunninginsharedservermode.Thedatabaseinstanceiscurrentlyusing60%oftotaloperatingsystemmemory.Yoususpectthesharedpoolfragmentationtobethereason.Whichactionwouldyouconsidertoovercometheperformancedegradation?
E.ConfigureLargePooltobeusedbyRMANandsharedserver.
23:
YourdatabaseisstartedwithSPFILE.YouwantthedatabaseinstancetobedynamicallyregisteredwithalistenerL2withthefollowingdetails:
Protocol:
TCP
Host:
indl151e
Port:
1525
Whichisthecorrectorderofthestepsthatyouwouldfollowtoachievethis?
1.SettheLOCAL_LISTENERparametertoL2dynamically.
2.MakeanentryforL2intnsnames.oraonthedatabaseserver.
3.RestartL2.
4.Modifythelistener.orafiletoaddtheinstancenameinSID_LISTofL2.
C.2,1;
3and4arenotrequired.
24:
ThejuniorDBAinyourorganizationhasaccidentallydeletedthealertlogfile.Whatwillyoudotocreatenewalertlogfile?
D.Noactionrequired.Thefilewouldbecreatedautomaticallybytheinstance.
25:
AusercomplainsthathegetsthefollowingerrormessagerepeatedlyafterexecutingsomeSQLstatements.Theerrormessageforcestheusertologofffromandlogontothedatabasetocontinuehiswork.
ORA-02392:
exceededsessionlimitonCPUusage,youarebeingloggedoff
WhichactionwouldyoutaketoincreasethesessionlimitonCPUusage?
A.Modifytheprofileassignedtotheuser.
26:
WhilesettingupanOracledatabaseforoneofyourcriticalapplications,youwanttoensurethatthedatabaseisbackedupatregularintervalswithoutyourintervention.Whatshouldyoudotoachievetheobjective?
E.schedulethedatabasebackupusingDatabaseConfigurationAssistant(DBCA)whilecreatingthedatabase
27:
WhichtwostatementsaboutFlashbackQueryaretrue?
B.Ithelpsinrow-levelrecoveryfromusererrors.
D.Itfailswhenundodatapertainingtothetransactionisoverwritten.
28:
Asaresultofperformanceanalysis,youcreatedanindexontheprod_namecolumnoftheprod_dettable,whichcontainsabouttenthousandrows.Later,youupdatedaproductnameinthetable.Howdoesthischangeaffecttheindex?
D.Aleafrowintheindexwillbedeletedandinserted.
29:
YourOracle10gdatabasehas6tablespacesinwhich:
-TEMPisthedefaulttemporarytablespace
-UNDOTBS1isthedefaultundotablespace
-USERSisthedefaultpermanenttablespace
Inthisdatabase,whichtwotablespacescanbemadereadonly?
B.PROD
C.USERS
30:
Yoususpectunauthorizeddatamanipulationlanguage(DML)operationsonaparticulartable.Youwanttotrackuserswhoareperformingthetransactionsandthevaluesusedinthetransactions.Also,youplantotransferthesevaluestoanothertableforanalysis.Howwouldyouachievethis?
A.byusingtriggers
31:
YouareusingthebackupschedulerinEnterpriseManager(EM)toscheduleabackupofyourdatabase.Whichtypeofscriptdoesthebackupschedulergenerate?
E.RecoveryManager(RMAN)script
32:
ViewtheExhibittoobservethemessagereceivedwhiletryingtodroptheSL_REPuserinOracleEnterpriseManager.
TheSL_REPuserownsobjectsandiscurrentlyconnectedtothedatabaseinstance.WhatwouldhappenifyouclickYESintheExhibit?
A.Anerrorisreturned,andtheuserisnotdropped.
33:
UserSCOTTexecutesthefollowingcommandontheEMPtablebuthasnotissuedCOMMIT,ROLLBACK,oranydatadefinitionlanguage(DDL)command:
SQL>
SELECTjobFROMemp
2WHEREjob='
CLERK'
FORUPDATEOFempno;
SCOTThasopenedanothersessiontoworkwiththedatabase.WhichthreeoperationswouldwaitwhenissuedinSCOTT'
ssecondsession?
A.LOCKTABLEempINSHAREMODE;
B.LOCKTABLEempINEXCLUSIVEMODE;
E.SELECTjobFROMempWHEREjob='
34:
Youhaveatextfilethatmaintainsinformationonthousandsofitems.Theend-userapplicationrequiresthetransferofthatinformationintoatableinthedatabase.Whatwouldyouusetoachievethistask?
C.SQL*Loader
E.Externaltable
35:
TheSAVE_AMTcolumnintheACCOUNTStablecontainsthebalancedetailsofcustomersinaba