单项选择题

WhichisthecorrectdescriptionofthesignificanceoftheORACLE_HOMEenvironmentalvariable？（）

A.ItspecifiesthedirectorycontainingtheOraclesoftware.
B.ItspecifiesthedirectorycontainingtheOracle-ManagedFiles.
C.Itspecifiesthedirectoryfordatabasefiles，ifnotspecifiedexplicitly.
D.ItspecifiesthebasedirectoryofOptimalFlexibleArchitecture（OFA）.

<上一题目录下一题>

热门试题

单项选择题

YourdatabaseisinARCHIVELOGmode.OnFridayevening，youperformanonlinedatabasebackupbyusingtheBACKUPDATABASEcommandattheRecoveryManager（RMAN）promptandclosethedatabase.OnMonday，theSystemAdministratorinformsyouaboutthefailureoftwoharddisks.Oneofthelostdiskscontainstwodatafiles，HR1.DBFandHR2.DBF，bothofwhichbelongtoaread writetablespacenamedHR.Thediskalsocontainsadatafile，USERS.DBF，whichbelongstoaread writetablespacenamedUSERS.YouneedtorestoreandrecoverthedatabasebackupthatwasperformedonFridayevening.Aftermountingthedatabase，youissuethefollowingRMANcommands：RMAN>RESTOREDATABASE；RMAN>RECOVERDATABASE；AftersuccessfullyexecutingtheseRMANcommands，youissuethefollowingstatementusingSQL*Plus：SQL>ALTERDATABASEOPEN；Youreceivethefollowingerrorswhenattemptingtoopenthedatabase：ORA-01157：cannotidentify lockdatafile10seeDBWRtracefileORA-01110：datafile10：’D： USERS.DBF’Whatisthecauseoftheseerrors？（）

A.OnFridayevening，youperformanonlinedatabasebackupbyusingtheBACKUPDATABASEcommandattheRecoveryManager（RMAN）promptandclosethe
B.OnMonday，theSystemAdministratorinformsyouaboutthefailureoftwoharddisks.Oneofthelostdiskscontainstwodatafiles，HR1.DBFandHR2.DBF，bothofwhichbelongtoaread/writetablespacenamedHR.Thediskalsocontainsadatafile，USERS.DBF，whichbelongstoaread/writetablespacenamedUSERS.YouneedtorestoreandrecoverthedatabasebackupthatwasperformedonFridayevening.Aftermountingthedatabase，youissuethefollowingRMANcommands：
C.DBF’

单项选择题

Youhavecreatedadatabaselink，devdb.us.oracle.com，betweenthedatabasesPRODDBandDEVDB.YouwanttoimportschemaobjectsoftheHRuserusingOracleDataPumpfromthedevelopmentdatabase，DEVDB，totheproductiondatabase，PRODDB.Youexecutethefollowingcommandonthetargetdatabaseserver：$impdpsystem managerdirectory=DB_DATAdumpfile=schemas.datschemas=hrflashback_time=2004-02-0309：00Thecommandfails，displayingthefollowingerror：ORA-39001：invalidargumentvalueORA-39000：baddumpfilespecificationORA-31640：unabletoopendumpfile home oracle schema schemas.dat”forreadORA-27037：unabletoobtainfilestatusWhatwouldyoudotoovercometheerror（）

A.us.oracle.com，betweenthedatabasesPRODDBandDEVDB.YouwanttoimportschemaobjectsoftheHRuserusingOracleDataPumpfromthedevelopmentdatabase，DEVDB，totheproductiondatabase，PRODDB.Youexecutethefollowingcommandonthetargetdatabaseserver：
B.datschemas=hr