Testinside
| English | Chinese(Traditional) | Chinese(Simplified) | 2 TestInside Information Co., Ltd. All rights reserved.
ImportantNote,PleaseReadCarefully
OtherTestInsideproducts
OfflineTestingEngine
UsetheofflineTestingengineproducttopracticethequestionsinanexamenvironment.
Buildafoundationofknowledgewhichwillbeusefulalsoafterpassingtheexam.
DownloadtheTestingEngineVersionof1Z0042
More TestInside Oracle 10gDBA Products
LatestVersion
We are constantly reviewing our products. New material is added and old material is revised. Free
updatesareavailablefor90daysafterthepurchase.YoushouldcheckyourmemberzoneatTestInside
andupdate34daysbeforethescheduledexamdate.
Hereistheproceduretogetthelatestversion:
1:Goto http://www.TestInside.com
2:LogintheUserCenter
3:Thelatestversionsofallpurchasedproductsaredownloadablefromhere.Justclickthelinks.
Feedback
Ifyouspotapossibleimprovementthenpleaseletusknow.Wealwaysinterestedinimprovingproduct
quality.
Feedbackshouldbesendtosales@TestInside.com.Youshouldincludethefollowing:Examnumber,
version,pagenumber,questionnumber,andyourlogin Account.
Ourexpertswillansweryourmailpromptly.
Explanations
Thisproductdoesnotincludeexplanationsatthemoment.Ifyouareinterestedinprovidingexplanations
forthisexam,pleasecontactsales@TestInside.com.
Testinside
| English | Chinese(Traditional) | Chinese(Simplified) | 3 TestInside Information Co., Ltd. All rights reserved.
1.InyourOracle10gdatabase,youhavescheduledajobtoupdatetheoptimizerstatisticsat05:00pm
everyFriday.Thejobhassuccessfullycompleted.Whichthreepiecesofinformationwouldyoucheckto
confirmthatthestatisticshavebeencollected?(Choosethree.)
A.averagerowsize
B.lastanalyzeddate
C.sizeoftableinbytes
D.sizeoftableindatabaseblocks
E.numberoffreeblocksinthefreelist
F.numberofextentspresentinthetable
Answer: 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.
Answer: AD
3. You are using the backup scheduler in Enterprise Manager (EM) to schedule a backup of your
database.
Whichtypeofscriptdoesthebackupschedulergenerate?
A.SQLscript
B.PL/SQLscript
C.OperatingSystem(OS)script
D.EnterpriseManager(EM)script
E.RecoveryManager(RMAN)script
Answer:E
4.YouexecutedthefollowingcommandtoexporttheEMPLOYEEStablefromaremotemachine:
$EXPDPhr/hr@data.us.oracle.com
DUMPFILE=my_dir:exp_hr.log
Testinside
| English | Chinese(Traditional) | Chinese(Simplified) | 4 TestInside Information Co., Ltd. All rights reserved.
LOGFILE=data_pump_dir:log_hr.log
TABLES=employees
Whatwouldbetheoutcomeofthiscommand?
A.Thecommandwouldexecutesuccessfullyandtheexportdumpfilewouldbecreatedinthedestination
ofthedirectoryobjectMY_DIR.
B.The commandwouldexecute successfully. But log filewouldnotbe created asDATA_PUMP_DIR
directoryisonlyaccessibletouserwithSYSDBAprivilege.
C.ThecommandfailswithanerrorbecauseDATA_PUMP_DIRdirectoryhavehigherprecedenceover
theperfiledirectory.
D.Thecommandfailswithanerrorbecausenoabsolutepathisspecifiedforlogfileanddumpfile.
Answer: A
5.WhichstepdoyouneedtoperformtoenableauserwiththeSYSDBAprivilegetologinasSYSDBAin
iSQL*Plus?
A.Theusermustbegrantedthedatabaseadministrator(DBA)privilege.
B.Theusermustbelistedinthepasswordfilefortheauthentication.
C.NospecialsetupisneededfortheusertoconnectasSYSDBAiniSQL*Plus.
D.SetupauserintheOracleApplicationServerContainersforJ2EE(OC4J)usermanager,andgrant
thewebDbaroletotheuser.
Answer:D
6.WhichtwostatementsregardingtheLOGGINGclauseoftheCREATETABLESPACE...statementare
correct?(Choosetwo.)
A.Thisclauseisnotvalidforatemporaryorundotablespace.
B.IfthetablespaceisintheNOLOGGINGmode,nooperationonthetablespacewillgenerateredo.
C. The tablespace will be in the NOLOGGING mode by default, if not specified while creating a
tablespace.
D.Thetablespacelevelloggingattributecanbeoverriddenbyloggingspecificationsatthetable,index,
materializedview,materializedviewlog,andpartitionlevels.
Answer: AD
7.Whichtwostatementsaretrueabouttheprimarykeyconstraintinatable?(Choosetwo.)
A.Itisnotpossibletodisabletheprimarykeyconstraint.
B.Itispossibletohavemorethanoneprimarykeyconstraintinasingletable.
C.Theprimarykeyconstraintcanbereferredbyonlyoneforeignkeyconstraint.
Testinside
| English | Chinese(Traditional) | Chinese(Simplified) | 5 TestInside Information Co., Ltd. All rights reserved.
D.Theprimarykeyconstraintcanbeimposedbycombiningmorethanonecolumn.
E.Thenondeferrableprimarykeyconstraintcreatesanuniqueindexontheprimarykeycolumnifitisnot
alreadyindexed.
Answer:DE
8.YouwanttheuserAPP_DBAtoadministertheOracledatabasefromaremotemachine.APP_DBAis
grantedtheSYSDBAprivilegetoperformadministrativetasksonthedatabase.
WhichfileisusedbytheOracledatabaseservertoauthenticateAPP_DBA?
A.controlfile
B.passwordfile
C.listenercontrollerfile
D.controlfileandpasswordfile
Answer:B
9. Which three statements are true regarding the logical structure of the Oracle database? (Choose
three.)
A.Eachsegmentcontainsoneormoreextents.
B.Multipletablespacescansharesingledatafile.
C.AdatablockisthesmallestunitofI/Ofordatafiles.
D.Itispossibletohavetablespacesofdifferentblocksizesinadatabase.
E.EachdatablockinthedatabasealwayscorrespondstooneOSblock.
Answer: ACD
10.Whichisthememoryareathatiscreatedwhenadedicatedserverprocessisstarted,andcontains
dataandcontrolinformationforthatserverprocess?
A.SGA
B.PGA
C.SharedPool
D.StreamsPool
Answer:B
11. You find that the database performance degrades while you backup the PROD database using
Recovery Manager (RMAN). The PROD database is running in shared server mode. The database
instance is currently using 60% of total operating system memory. You suspect the shared pool
fragmentationtobethereason.
