Oralcle数据库技术培训考题Word格式文档下载.docx
- 文档编号:14338420
- 上传时间:2022-10-22
- 格式:DOCX
- 页数:10
- 大小:267.02KB
Oralcle数据库技术培训考题Word格式文档下载.docx
《Oralcle数据库技术培训考题Word格式文档下载.docx》由会员分享,可在线阅读,更多相关《Oralcle数据库技术培训考题Word格式文档下载.docx(10页珍藏版)》请在冰豆网上搜索。
2:
YourdatabaseisopenandtheLISTENERlistenerisrunning.ThenewDBAofthesystemstopsthelistenerbyusingthecommand:
LSNRCTL>
STOP
Whathappenstothesessionsthatarepresentlyconnectedtothedatabaseinstance?
A.Thesessionsareabletoperformonlyqueries.
B.Thesessionsarenotaffectedandcontinuetofunctionnormally.
C.Thesessionsareterminatedandtheactivetransactionsarerolledback.
D.Thesessionsarenotallowedtoperformanyoperationstillthelistenerisstarted.
3:
InwhichofthescenarioswilltheDBAperformrecovery?
(Chooseallthatapply.)
A.Thealertlogfileiscorrupted.
B.Atablespaceisaccidentallydropped.
C.Oneoftheredologmembersiscorrupted.
D.Adatabaseuserterminatesthesessionabnormally.
E.Theharddiskonwhichthedatafileisstorediscorrupted.
4:
Notethefollowingstructuresinyourdatabaseserver:
1.Extents
2.OSBlocks
3.Tablespace
4.Segments
5.OracleDataBlock
Whichoptionhasthecorrectarrangementofthesestructuresfromthesmallesttothelargest?
A.2,5,1,4,3
B.1,2,3,4,5
C.5,2,1,3,4
D.2,1,5,4,3
5:
ViewtheExhibit.
WhichstatementsaretrueregardingtheUSERStablespace?
A.Abitmapisusedtorecordfreeextents.
B.Freeextentsinformationismanagedwithinthetablespace.
C.FreeextentsinformationismanagedintheSYSAUXtablespace.
D.Thedatadictionarytablesareupdatedwhenextentsareallocatedordeallocated.
6:
Whichtwostatementsaretrueregardingundotablespaces?
A.Thedatabasecanhavemorethanoneundotablespace.
B.TheUNDO_TABLESPACEparameterisvalidinbothautomaticandmanualundomanagement.
C.Undosegmentsautomaticallygrowandshrinkasneeded,actingascircularstoragebufferfortheirassignedtransactions.
D.AnundotablespaceisautomaticallycreatediftheUNDO_TABLESPACEparameterisnotsetandtheUNDO_MANAGEMENTparameterissettoAUTOduringthedatabaseinstancestartup.
7:
YouwanttomoveallobjectsoftheAPPSuserinthetestdatabasetotheDB_USERschemaoftheproductiondatabase.WhichoptionofIMPDPwouldyouusetoaccomplishthistask?
A.FULL
B.SCHEMAS
C.TRANSFORM
D.REMAP_SCHEMA
E.REMAP_TABLESPACE
8:
Theinstanceabnormallyterminatesbecauseofapoweroutage.Whichstatementistrueaboutredologfilesduringinstancerecovery?
A.Inactiveandcurrentredologfilesarerequiredtoaccomplishrecovery.
B.Onlineandarchivedredologfilesarerequiredtoaccomplishinstancerecovery.
C.Allredologentriesafterthelastcheckpointareappliedfromredologfilestodatafiles.
D.Allredologentriesrecordedinthecurrentredologfileuntilthecheckpointpositionareappliedtodatafiles.
9:
YouhaveissuedaSHUTDOWNABORTcommandtobringdownyourdatabaseinstance.Considerthestepsthatwillbeperformedlaterwhenyouopenthedatabase:
1.SGAisallocated.
2.Controlfileisread.
3.Redologfilesareread.
4.Instancerecoveryisstarted.
5.Backgroundprocessesarestarted.
6.Datafilesarecheckedforconsistency.
7.Serverparameterfileortheinitializationparameterfileisread.
Whichoptionhasthecorrectorderinwhichthesestepsoccur?
A.7,1,5,2,3,6,4
B.1,2,3,7,5,6,4
C.7,1,4,5,2,3,6
D.1,7,5,4,2,3,6
10:
Inwhichsituationwouldyouusestaticdatabaseregistrationforalistener?
A.whenmultipledatabasesaretoberegisteredwiththelistener
B.whenDBAsneedtoconnectremotelytostartupthedatabaseinstance
C.whenusersneedtoconnectthedatabaseinstanceusingthehostnamingmethod
D.whenthedatabaseinstancethatistoberegisteredwiththelistenerisconfiguredinsharedservermode
11:
ViewtheExhibitandexaminetheundotablespaceattributes.
Yourdatabaseinstanceisexperiencingalargevolumeoftransactionsfromnon-DBAusersinthelastonehour.TheundotablespaceUNDOTBS1isfullwithtransactionsandnotransactionwascommittedmorethanonehourago.Thedatabasehastwomoreundotablespaces.
WhathappenstothenewDMLoperationsinthisscenario?
A.TheDMLcommandswillfail.
B.TheundodatageneratedbytheDML
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- Oralcle 数据库技术 培训 考题
![提示](https://static.bdocx.com/images/bang_tan.gif)