oracle 10g 1z0042Word下载.docx
- 文档编号:16948278
- 上传时间:2022-11-27
- 格式:DOCX
- 页数:57
- 大小:40.94KB
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
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- oracle 10g 1z0042 10 z0042