![](https://lstatic.shangxueba.com/sxbzda/h5/images/m_q_title.png)
A.A
B.B
C.C
D.D
![](https://lstatic.shangxueba.com/sxbzda/h5/images/tips_org.png)
第1题
A. Oracle Data Pump
B. Oracle Recovery Manager (RMAN)
C. Oracle Label Security
D. Oracle Database Vault
E. Oracle Real Application Security
第2题
ceaborted.Afterinspectingthealertlogfile,youexecutetheSTARTUPcommandinSQL*Plustobringtheinstanceup.Whatstatementistrue?()
A.PMONcoordinatesmediarecovery.
B.SMONcoordinatesinstancerecovery.
C.PMONcoordinatesinstancerecovery.
D.UndoAdvisorwouldrollbackalluncommittedtransactions.
E.SQL*PLUSreportsanerrorwiththemessageaskingyoutoperforminstancerecovery.
第3题
A.ThemembersofLOW_GROUPwouldgetmoreprioritythanthoseofOTHER_GROUPS.
B.ThemembersofSYS_GROUPwouldgetmostoftheCPUallocationatlevel1.
C.ThemembersofLOW_GROUPwouldgetmostoftheCPUallocationbecauseithasCPUallocationattwodifferentlevels.
D.ThemembersofLOW_GROUPwouldgetnoCPUallocationatlevel1ifthemembersofOTHER_GROUPSareusingalltheCPUatlevel2.
E.ThemembersofSYS_GROUPwouldgetnoCPUallocationatlevel1ifthemembersofOTHER_GROUPSareusingalltheCPUatlevel2.
第4题
ARCHIVELOG mode. You find that the SYSAUX tablespace is corrupted in the root container.The steps to recover the tablespace are as follows:1. Mount the CDB.2. Close all the PDBs.3. Open the database.4. Apply the archive redo logs.5. Restore the data file.6. Take the SYSAUX tablespace offline.7. Place the SYSAUX tablespace online.8. Open all the PDBs with RESETLOGS.9. Open the database with RESETLOGS.10. Execute the command SHUTDOWN ABORT.Which option identifies the correct sequence to recover the SYSAUX tablespace?()
A.6,5,4,7
B.10,1,2,5,8
C.10,1,2,5,4,9,8
D.10,1,5,8,10
第5题
A.ThesourcePL/SQLcodewillbestoredinnativemachinecode.
B.ThesourcePL/SQLcodewillbestoredininterpretedbytecode.
C.ThecompiledPL/SQLcodewillbestoredinnativemachinecode.
D.ThecompiledPL/SQLcodewillbestoredininterpretedbytecode.
第6题
A.TheyareevaluatedbyallthethreeWHENclausesregardlessoftheresultsoftheevaluationofanyotherWHENclause.
B.TheyareevaluatedbythefirstWHENclause.Iftheconditionistrue,thentherowwouldbeevaluatedbythesubsequentWHENclauses.
C.TheyareevaluatedbythefirstWHENclause.Iftheconditionisfalse,thentherowwouldbeevaluatedbythesubsequentWHENclauses.
D.TheINSERTstatementwouldgiveanerrorbecausetheELSEclauseisnotpresentforsupportincasenoneoftheWHENclausesaretrue.
第7题
,theusersessionrequiresthetimezonetobesettothelocaloperatingsystemtimezonewithoutaffectingotherusersessions.Whichtwosolutionscouldtheuserimplementtoachievethisobjective?()
A.usetheALTERSYSTEMcommandtochangethetimezone
B.usetheALTERSESSIONcommandtochangethetimezone
C.usetheALTERDATABASEcommandtochangethetimezone
D.setthevaluefortheoperatingsystemvariableORA_SDTZontheclientmachine
E.setthevaluefortheoperatingsystemvariableORA_SDTZonthedatabaseservermachine
第8题
leusingOracleEnterpriseManager10gDatabaseControl,youfindthestatusofthejobasfailed.Onfurtherinvestigation,youfindthefollowingerrormessageintheoutputlog:ORA-01653unabletoextendtableHR.CertkillerSTAFFby8intablespaceUSERSWhichtaskwouldyouperformtoloadthedatasuccessfullywithoutaffectingtheuserswhoareaccessingthetable?()
A.Restartthedatabaseinstanceandrunthejob
B.TruncatetheCertkillerSTAFFtableandrunthejob
C.DeleteallrowsfromtheCertkillerSTAFFtableandrunthejob
D.IncreasethesizeoftheUSERStablespacetheandrunthejob
E.Increasethesizeofthedatabasedefaultpermanenttablespaceandrunthejob
第9题
A. Reduced logical I/O
B. Reduced virtual memory utilization
C. Improved parallel Execution performance
D. Improved Serial Execution performance
E. Reduced physical I/O
F. Reduced CPU utilization
第10题
ainabouttheslowresponseoftransactions.Whileinvestigatingthereasonyoufindthatthetransactionsarewaitingfortheundosegmentstobeavailable,andundoretentionhasbeensettozero.Whatwouldyoudotoovercomethisproblem?()
A.Increasetheundoreturn
B.Createmoreundosegments
C.Createanotherundotablespace
D.Increasethesizeoftheundotablespace
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!