oracle OPC 题库 1z0042.docx
- 文档编号:10329268
- 上传时间:2023-02-10
- 格式:DOCX
- 页数:46
- 大小:941.28KB
oracle OPC 题库 1z0042.docx
《oracle OPC 题库 1z0042.docx》由会员分享,可在线阅读,更多相关《oracle OPC 题库 1z0042.docx(46页珍藏版)》请在冰豆网上搜索。
oracleOPC题库1z0042
Vendor:
1z0-042
ExamCode:
oracledatabase10g:
administrationi
ExamName:
Oracle
Version:
3.00
分卷:
A
1:
Whichthreepiecesofinformationareconsideredwhiledecidingthesizeoftheundotablespaceinyourdatabase?
(Choosethree.)
A.thesizeofanundoblock
C.undoblocksgeneratedpersecond
E.thevalueoftheUNDO_RETENTIONparameter
2:
YouexecutedtheSTARTUPMOUNTcommandtostartyourdatabase.ForwhichdatabaseoperationdoyouneedtostartthedatabaseintheMOUNTstate?
C.enablingordisablingredologarchiving
3:
Youwanttocreateanewoptimizeddatabaseforyourtransactionalproductionenvironmenttobeusedbyafinancialapplication.Whilecreatingthedatabase,youwanttheOraclesoftwaretotakecareofallbasicsettingstooptimizethedatabaseperformance.Whichmethodwouldyouusetoachievethisobjective?
D.UseDatabaseConfigurationAssistant(DBCA)tocreatethedatabasewithTransactionProcessingtemplate.
4:
Whichthreestatementsaretrueaboutthestagesofdatabasestartup?
(Choosethree.)
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?
(Choosethree.)
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?
(Choosetwo.)
C.Youcanperformcompletedatabasebackupswithoutclosingthedatabase.
E.AllthepreviousdatabasebackupsbecomeinvalidafteryouconfigurethedatabasetoARCHIVELOGmode.
15:
UserScotthasupdatedthesalaryofoneoftheemployeesintheEMPLOYEEStableandhasnotcommittedthetransaction.Whatarethetwotypesoflocksthatthisscenariowouldleadto?
(Choosetwo.)
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?
(Choosetwo.)
B.rollingbackatransaction
C.recoveringfromfailedtransactions
19:
YourdatabaseisconfiguredinNOARCHIVELOGmode.Allthecontrolfileshavebeenlostduetoaharddiskfailurebutthedatafilesarenotlost.Youhavetheclosedwholedatabasebackupavailabletoyou.Whichtwostatementsaretrueinthisscenario?
(Choosetwo.)
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?
(Choosetwo.)
B.Ithelpsinrow-levelrecoveryfromusererrors.
D.Itfailswhenundodatapertainingtothetransactionisoverwritten.
28:
Asaresultofperformanceanalysis,youcreatedanindexontheprod_namecolumnoftheprod_dettable,whichcontainsabouttenthousandrows.Later,youupdatedaproductnameinthetable.Howdoesthischangeaffecttheindex?
D.Aleafrowintheindexwillbedeletedandinserted.
29:
ViewtheExhibit.
YourOracle10gdatabasehas6tablespacesinwhich:
-TEMPisthedefaulttemporarytablespace
-UNDOTBS1isthedefaultundotablespace
-USERSisthedefaultpermanenttablespace
Inthisdatabase,whichtwotablespacescanbemadereadonly?
(Choosetwo.)
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?
(Choosethree.)
A.LOCKTABLEempINSHAREMODE;
B.LOCKTABLEempINEXCLUSIVEMODE;
E.SELECTjobFROMempWHEREjob='CLERK'FORUPDATEOFempno;
34:
Youhaveatextfilethatmaintainsinformationonthousandsofitems.Theend-userapplicationrequiresthetransferofthatinformationintoatableinthedatabase.Whatwouldyouusetoachievethistask?
(Choosetwo.)
C.SQL*Loader
E.Externaltable
35:
TheSAVE_AMTcolumnintheACCOUNTStablecontainsthebalancedetailsofcustomersinaba
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- oracle OPC 题库 1z0042 z0042