oracle 10g 1z0042Word下载.docx

oracle 10g 1z0042Word下载.docx

《oracle 10g 1z0042Word下载.docx》由会员分享，可在线阅读，更多相关《oracle 10g 1z0042Word下载.docx（57页珍藏版）》请在冰豆网上搜索。

ABD

2.Youareinthemiddleofatransactionandverycrucialdatahasbeenmodified.Becauseofahardware

failure,theinstancehasshutdownbeforesynchronizingallthedatabasefiles.

Whichtwostatementsaretrue?

（Choosetwo.）

A.Onstartup,SMONcoordinatesinstancerecovery.

B.Onstartup,CKPTcoordinatesinstancerecovery.

C.Onstartup,useRMANtoperforminstancerecovery.

D.Uncommittedchangeswillberolledbackafterthedatabaseisopened.

E.Onstartup,performmediarecoveryandtheninstancerecovery.

F.Onstartup,allthefileswillbesynchronizedandyougetbothcommittedanduncommitteddata.

AD

3.YouareusingthebackupschedulerinEnterpriseManager（EM）toscheduleabackupofyour

database.

Whichtypeofscriptdoesthebackupschedulergenerate?

A.SQLscript

B.PL/SQLscript

C.OperatingSystem（OS）script

D.EnterpriseManager（EM）script

E.RecoveryManager（RMAN）script

E

4.YouexecutedthefollowingcommandtoexporttheEMPLOYEEStablefromaremotemachine:

$EXPDPhr/hr@

DUMPFILE=my_dir:

exp_hr.log

LOGFILE=data_pump_dir:

log_hr.log

TABLES=employees

Whatwouldbetheoutcomeofthiscommand?

A.Thecommandwouldexecutesuccessfullyandtheexportdumpfilewouldbecreatedinthedestination

ofthedirectoryobjectMY_DIR.

B.Thecommandwouldexecutesuccessfully.ButlogfilewouldnotbecreatedasDATA_PUMP_DIR

directoryisonlyaccessibletouserwithSYSDBAprivilege.

C.ThecommandfailswithanerrorbecauseDATA_PUMP_DIRdirectoryhavehigherprecedenceover

theperfile

directory.

D.Thecommandfailswithanerrorbecausenoabsolutepathisspecifiedforlogfileanddumpfile.

A

5.WhichstepdoyouneedtoperformtoenableauserwiththeSYSDBAprivilegetologinasSYSDBAin

iSQL*Plus?

A.Theusermustbegrantedthedatabaseadministrator（DBA）privilege.

B.Theusermustbelistedinthepasswordfilefortheauthentication.

C.NospecialsetupisneededfortheusertoconnectasSYSDBAiniSQL*Plus.

D.SetupauserintheOracleApplicationServerContainersforJ2EE（OC4J）usermanager,andgrant

thewebDbaroletotheuser.

D

6.WhichtwostatementsregardingtheLOGGINGclauseoftheCREATETABLESPACE...statementare

correct?

A.Thisclauseisnotvalidforatemporaryorundotablespace.

B.IfthetablespaceisintheNOLOGGINGmode,nooperationonthetablespacewillgenerateredo.

C.ThetablespacewillbeintheNOLOGGINGmodebydefault,ifnotspecifiedwhilecreatinga

tablespace.

D.Thetablespacelevel

loggingattributecanbeoverriddenbyloggingspecificationsatthetable,index,

materializedview,materializedviewlog,andpartitionlevels.

7.Whichtwostatementsaretrueabouttheprimarykeyconstraintinatable?

A.Itisnotpossibletodisabletheprimarykeyconstraint.

B.Itispossibletohavemorethanoneprimarykeyconstraintinasingletable.

C.Theprimarykeyconstraintcanbereferredbyonlyoneforeignkeyconstraint.

D.Theprimarykeyconstraintcanbeimposedbycombiningmorethanonecolumn.

E.Thenondeferrable

primarykeyconstraintcreatesanuniqueindexontheprimarykeycolumnifitisnot

alreadyindexed.

DE

8.YouwanttheuserAPP_DBAtoadministertheOracledatabasefromaremotemachine.APP_DBAis

grantedtheSYSDBAprivilegetoperformadministrativetasksonthedatabase.

WhichfileisusedbytheOracledatabaseservertoauthenticateAPP_DBA?

A.controlfile

B.passwordfile

C.listenercontrollerfile

D.controlfileandpasswordfile

B

9.WhichthreestatementsaretrueregardingthelogicalstructureoftheOracledatabase?

（Choose

three.）

A.Eachsegmentcontainsoneormoreextents.

B.Multipletablespacescansharesingledatafile.

C.AdatablockisthesmallestunitofI/Ofordatafiles.

D.Itispossibletohavetablespacesofdifferentblocksizesinadatabase.

E.EachdatablockinthedatabasealwayscorrespondstooneOSblock.

ACD

10.Whichisthememoryareathatiscreatedwhenadedicatedserverprocessisstarted,andcontains

dataandcontrolinformationforthatserverprocess?

A.SGA

B.PGA

C.SharedPool

D.StreamsPool

11.YoufindthatthedatabaseperformancedegradeswhileyoubackupthePRODdatabaseusing

RecoveryManager（RMAN）.ThePRODdatabaseisrunninginsharedservermode.Thedatabase

instanceiscurrentlyusing60%oftotaloperatingsystemmemory.Yoususpectthesharedpool

fragmentationtobethereason.

Whichactionwouldyouconsidertoovercometheperformancedegradation?

A.ConfigureJavaPooltocachethejavaobjects.

B.ConfigureStreamsPooltoenableparallelprocessing.

C.IncreaseSharedPoolsizetocachemorePL/SQLobjects.

D.IncreaseDatabaseBufferCachesizetoincreasecachehits.

E.ConfigureLargePooltobeusedbyRMANandsharedserver.

F.IncreasethetotalSystemGlobalArea（SGA）sizetoincreasememoryhits.

12.Youexecutethefollowingcommandtoauditthedatabaseactivities:

SQL>

AUDITDROPANYTABLEBYscottBYSESSIONWHENEVERSUCCESSFUL;

Whatistheeffectofthiscommand?

A.OneauditrecordiscreatedforthewholesessionifuserSCOTTsuccessfullydropsoneormoretables

inhissession.

B.Oneauditrecordiscreatedforeverysessionwhenanyusersuccessfullydropsatableownedby

SCOTT.

C.OneauditrecordiscreatedforeachsuccessfulDROPTABLEcommandexecutedbyanyusertodrop

tablesownedbySCOTT.

D.OneauditrecordisgeneratedforthesessionwhenSCOTTgrantstheDROPANYTABLEprivilegeto

otherusersinhissession.

E.OneauditrecordiscreatedforeachsuccessfulDROPTABLEcommandexecutedinthesessionof

13.TheSAVE_AMTcolumnintheACCOUNTStablecontainsthebalancedetailsofcustomersinabank.

Aspartoftheyearend

taxandinterestcalculationprocess,alltherowsinthetableneedtobeaccessed.

Thebankauthoritieswanttotrackaccesstotherowscontainingbalanceamountsexceeding$200,000,

andthensendanalertmessagetotheadministrator.

Whichmethodwouldyousuggesttothebankforachievingthistask?

A.implementingvaluebased

auditingbyusingtriggers

B.implementingfinegrained

auditingwithauditconditionandeventhandler

C.performingstandarddatabaseauditingtoauditobjectprivilegesbysettingtheAUDIT_TRAIL

parametertoEXTENDED

D.performingstandarddatabaseauditingtoauditSQLstatementswithgranularitylevelsettoACCESS

14.Whichthreestatementsaretrueregardingthefinegrained

auditing（FGA）?

A.FGAispossibleonSELECTstatementsonly.

B.TheaudittrailforFGAisstoredintheFGA_LOG$table.

C.TheaudittrailforFGAisstoredintheAUD_LOG$table.

D.FGAenablesaSQLpredicatetodefinewhentoauditanevent.

E.FGAauditsDELETEstatementsonlywhenauditcolumnsarespecified.

F.FGAincludestheSQLstatementusedbytheuseraspartoftheauditevententry.

BDF

15.Youplantousestaticdatabaseregistrationforanewlistenerwhenyoucreateit.Whatcouldbethe

tworeasonsforthis?

A.Morethanonedatabaseistoberegisteredwiththelistener.

B.Theuserswillconnectthedatabasebyusingthehostnamingmethod.

C.TheOracleEnterpriseManageristobeusedtomonitoranOracle9idatabase.

D.Thedatabasethatistoberegisteredwiththelistenerisconfiguredinsharedservermode.

E.Thelistenerisnotconfiguredonthedefaultportof1521andtheinstanceisnotconfiguredtoregister

withanondefaultport.

CE

16.Whichthreepiecesofinformationaretobemandatorilyprovidedwhilecreatinganewlistenerusing

EnterpriseManagerDatabaseControl?

A.theportusedbythelistener

B.theprotocolusedbythelistener

C.theservernamewherethelistenerruns

D.thelogfileandtracefiledestinationforthelistener

E.thedatabaseservicestoberegisteredwiththelistener

ABC

17.Youhavebeenrecentlyhiredasadatabaseadministrator.Yourseniormanagerasksyoutostudythe

productiondatabaseserverandsubmitareportonthesettingsdonebythepreviousDBA.While

observingtheserversettings,youfindthatthefollowingparameterhasbeensetintheparameterfileof

thedatabase:

REMOTE_OS_AUTHENT=TRUE

WhatcouldhavebeenthereasontosetthisparameterasTRUE?

A.toenableoperatingsystemauthenticationforaremoteclient

B.torestrictthescopeofadministrationtoidenticaloperatingsystems

C.toallowthestartupandshutdownofthedatabasefromaremoteclient

D.toenabletheadministrationoftheoperatingsystemfromaremoteclient

E.todisabletheadministrationoftheoperatingsystemfromaremoteclient

18.Whichnamingmethodusesthetnsnames.orafiletostoretheconnectdescriptorusedbytheclient

whileconnectingtothedatabaseinstancefromaremotemachine?

A.hostnamingmethod

B.localnamingmethod

C.externalnamingmethod

D.directorynamingmethod

19.Yourtnsnames.orafilehasthefollowingentryfortheservicealiasORCL:

ORCL=

（DESCRIPTION=

（ADDRESS=（PROTO