题目内容（请给出正确答案）

[主观题]

Youhavecontrol-fileautobackupsenabled.WhenstartingyourdatabasefromSQL*Plus，youreceivethefo

llowingerrormessage：SQL＞startupORA-01078：failureinprocessingsystemparametersLRM-00109：couldnotopenparameterfile，C：\ORACLE\PRODUCT\11.1.0\DB_1\DATABASE\INITORCL.ORAUsingRMAN，howwouldyourespondtothiserror？（）

A.Issuethestartupnomountcommandandthenissuetherestoreparameterfilecommandfromthe RMANprompt.

B.IssuethestartupnomountcommandandthenissuetherestorespfilecommandfromtheRMANprompt.

C.Issuethestartupnomountcommandandthenissuetherestorespfilefromautobackupcommand fromtheRMANprompt.

D.Issuethestartupnomountcommandandthenissuetherestorespfilefrombackupcommand from theRMANprompt.

E.IssuetherestorespfilefromautobackupcommandfromtheRMANprompt.

查看答案

如搜索结果不匹配，请联系老师获取答案

您可能会需要：

重置密码查看订单联系客服

安装上学吧APP，拍照搜题省时又省心！

更多“Youhavecontrol-fileautobackups…”相关的问题

第1题

Youneedtorestoresomefilesfromafilesystem.Thefilesystemwasbackedupfromasnapshot.Whichcommandwillcorrectlyrestorethesefiles？（）

A.fssnap-i

B.fssnap-r

C.ufsrestore-i

D.snaprestore-i

点击查看答案

第2题

Which three types of integration does the Business Event System support?（） (Choose three.)

A. point-to-point

B. parent/child messaging

C. messaging hub system

D. distributed applications messaging

E. simple object access protocol (SOAP) messaging

点击查看答案

第3题

WhichtwostatementsaretrueregardingthedatabaseinARCHIVELOGmode？（）

A.Youhavetoshutdownthedatabasetoperformthebackups.

B.Archivinginformationiswrittentothedatafilesandredologfiles.

C.Youcanperformcompletedatabasebackupswithoutclosingthedatabase.

D.OnlineredologfileshavetobemultiplexedbeforeputtingthedatabaseinARCHIVELOGmode.

E.AllthepreviousdatabasebackupsbecomeinvalidafteryouconfigurethedatabasetoARCHIVELOGmode.

点击查看答案

第4题

YouarepartoftheDBAteamworkingfora&en

YouarepartoftheDBAteamworkingforamultinationalbank.Theteamisresponsibleforperformingadministrativetasksonthedatabaseserverlocatedatthehomeoffice.ThedatabaseserveratthehomeofficehasaproductiondatabaseandatestdatabasenamedTESTDB.Thetestdatabaseisprimarilyusedfortestingdatabasecommandsandconfigurationsettingsbeforimplementingthesesettingsontheproductiondatabase.Thetestdatabaseisalsousedforthedevelopmentofdatabaseapplications.YouhavebeenaskedbytheseniorDBAtogranttheSYSDBAprivilegetoanewteammember，John，sothathecanperformsomeadministrativetasks，suchasshutdownandstartupoperations，onTESTDB.YouusethepasswordfiletoconfigureremoteauthenticationontheTESTDBdatabase.Youexecutethefollowingstatementtograntthe SYSDBAprivilegetoJohn：

SQL>GRANTSYSDBATOjohn；

However，youreceivethefollowingerror：

ORA-01996：GRANTfailed：passwordfile

’c：\oracle\ora9i\dbs\testdb.pwd’isfull

Whichactionshouldyoutaketoaddtheuserjohntothepasswordfilewithoutremovinganyoftheexistingusers？（）

点击查看答案

第5题

Anairlineisbuildingabookingsystemforitspremiumandgeneralcustomers.Thegoalistoensurepremiummembersaregivenhigheraccessprioritywhenusertrafficishigh.Whatconfigurationwillachievethisgoal?（）

A.ConfigureaWorkManagerforpremiumuserswithaMinimumThreadConstraint.

B.ConfigureaWorkManagerforpremiumuserswithahigherfair-share-request-class.

C.ConfigureaWorkManagerforpremiumuserswithahigherresponse-time-request-class.

D.ConfigureaWorkManagergeneraluserswithaMaximumThreadConstraint.

E.ConfigureaWorkManagerforpremiumuserswithacustomrequest-class.

点击查看答案

第6题

You are having problems with connections from a specific host (192.168.1.15) not closing d

own correctly.You want to find the state of the threads from that host check for long-running queries. Which statement will accomplish this?（）

A.A

B.B

C.C

D.D

点击查看答案

第7题

ViewtheExhibit.YouarecreatinganadditionaldatabasebyusingtheDatabaseConfigurationAssistant（

DBCA）.YouoptedtocreateaGeneralPurposedatabaseandduringthedatabasecreationrealizethattheBlockSizefieldisnotenabled.Whatcouldbethereasonforthis（）

A.YouhavechosentheFileSystemoptionasthestorageoption.

B.YouhavechosentheAutomaticStorageManagement（ASM）asthestorageoption.

C.ThedatablocksizecanbeincreasedonlywhenDBCAisinvokedfromOracleUniversalInstaller（OUI）.

D.YouareusingGeneralPurposetemplateandnottheCustomDatabasetemplatetocreatethedatabase.

点击查看答案

第8题

YourdatabaseisinARCHIVELOGmode.OnFridayeve

ning，youperformanonlinedatabasebackupbyusingtheBACKUPDATABASEcommandattheRecoveryManager（RMAN）promptandclosethe

database.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/lockdatafile10seeDBWRtracefile

ORA-01110：datafile10：’D：\USERS.DBF’

Whatisthecauseoftheseerrors？（）

点击查看答案

第9题

Afteryoubackup/exportusingafilesystemsnapshot，andyouhaveremovedthesnapshot，youalsoneedtore

movethebackingstore.Ifthesnapshotwascreatedwith： mkdir/var/tmp/backup-snapsfssnap-obs=/var/tmp/backup-snaps/exportWhichfiledoyouneedtoremove？（）

A.A

B.B

C.C

D.D

点击查看答案

第10题

WhataretheadvantagesofvariableextentsizesupportforlargeASMfiles?（）

A.Itimprovesresyncoperationswhenthediskcomesonlineafterbeingtakenofflineformaintenancepurposes.

B.Itimprovesperformanceintheextendedclusterconfigurationbyreadingfromalocalcopyofanextent.

C.Fewerextentpointersareneededtodescribethefileandlessmemoryisrequiredtomanagetheextentmapsinthesharedpool.

D.Thisfeatureenablesfasterfileopensbecauseofthereductionintheamountofmemorythatisrequiredtostorefileextents.

点击查看答案