Oralcle数据库技术培训考题Word格式文档下载.docx

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