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

[主观题]

Your database is running in ARCHIVELOG mode. One of the data files, USERDATA01.dbf, in the

USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available.Which three files would be used in the user-managed recovery process performed by the database administrator （）(DBA)？ (Choose Three)

A. Redo logs

B. Control file

C. The latest backup of only the damaged data file

D. The latest backup of all the data file in the USERS tablespace

E. Temporary files of temporary tablespace

F. Archive Logs since the latest backup to point of failure

查看答案

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

您可能会需要：

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

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

更多“Your database is running in AR…”相关的问题

第1题

FlashbackDatabaseisenabledinyourOracle10gdatabase.Oneofyourdatabaseuserserroneouslypurgeda

nimportanttableresidinginhisschema.Thetablewaspurgedsometimebetween10：00P.M.and10：30P.M.Thenextday，youdecidetoflashbackthedatabase.Beforeyouflashbackthedatabase，youwanttoensurethatyouhaveallthenecessaryflashbackdata.Whichdynamicperformanceviewmustyouusetodeterminewhetheryouhavetherequiredflashbackdatatorecoverthepurgedtable？（）

A.V$DATABASE

B.V$UNDOSTAT

C.V$FLASHBACK_DATABASE_LOG

D.V$FLASHBACK_DATABASE_STAT

点击查看答案

第2题

YouaremanaginganOracleDatabase11gASMinstancewithadiskgroupdg01havingthreedisks.Oneofthedis

ksinthediskgroupbecomesunavailablebecauseofpowerfailure.YouissuedthefollowingcommandtochangetheDISK_REPAIR_TIMEattributefrom3.6hoursto5hours：ALTERDISKGROUPdg01SETATTRIBUTE’disk_repair_time’=’5h’；Towhichdisksinthediskgroupwillthenewvaluebeapplicable？（）

A.alldisksinthediskgroup

B.alldisksthatarecurrentlyinOFFLINEmode

C.alldisksthatarenotcurrentlyinOFFLINEmode

D.alldisksinthediskgrouponlyifallofthemareONLINE

点击查看答案

第3题

Which three statements describe how the strict SQL mode provides added security?（）

A.It rejects statements that try to insert out-of-range values

B.It rejects invalid dates

C.It limits the operations that the server can perform

D.It rejects queries that produce out-of-range values

E.It rejects dates with zero day or month values

点击查看答案

第4题

Theapplicationworkloadonyourdatabaseissamebetween10a.m.and11a.m.onweekdays.Suddenlyyouobse

rvepoorperformancebetween10a.m.and11a.m.inthemiddleoftheweek.Howwouldyouidentifythechangesinconfigurationsettings，workloadprofile，andstatisticstodiagnosethepossiblecausesoftheperformancedegradation？（）

A.byusingtheSQLaccessadvisor

B.byusingtheAutomaticWorkloadRepositoryreport

C.byrunningtheAutomaticDatabaseDiagnosticMonitor（ADDM）

D.byusingtheAutomaticWorkloadRepositoryComparePeriodreport

E.byanalyzingtheoutputoftheV$ACTIVE_SESSION_HISTORYview

点击查看答案

第5题

WhichstatementistrueregardingtheeffectofthiscommandonthetransactioninScott’ssession（）

A.Thecommandfailsasatransactionisstillpending.

B.ThetransactioninScott’ssessionisrolledbackandthetablespacebecomesread-only.

C.ThecommandwaitsandtheuserSCOTTcanexecutedatamanipulationlanguage（DML）statementsonlyaspartofthecurrenttransaction.

D.Thecommandhangsuntilalltransactionsontheobjectsinthetablespacecommitorrollback，andthenthetablespaceisplacedinread-onlymode.

点击查看答案

第6题

Exhibit:Examine the data in the EMPLOYEES table.Examine the subquery:SELECT last_nameFROM employeesWHERE salary IN (SELECT MAX(salary)FROM employeesGROUP BY department_id);Which statement is true?（）

A. The SELECT statement is syntactically accurate.

B. The SELECT statement does not work because there is no HAVING clause.

C. The SELECT statement does not work because the column specified in the GROUP BY clause is not in the SELECT list.

D. The SELECT statement does not work because the GROUP BY clause should be in the main query and not in the subquery.

点击查看答案

第7题

Animportanttablespaceofyourdatabaseisdropped&ens

Animportanttablespaceofyourdatabaseisdroppedbymistake.YouusetheFlashbackDatabasefeaturetoretrievethetablespace.Youperformthefollowingstepstoretrievethetablespace：

1.YoulogontoEnterpriseManagerasSYSDBA.

2.Youselectthemaintenancescreen.

3.YouchoosePerformRecoveryoptiononthemaintenancescreen.

4.YouchooseWholeDatabaseintheObjectTypedrop-downlistPerformRecovery：Typescreen.5.YouchooseRecovertoCurrentTimefromtheOperationTypeonthePerformRecovery：Typescreen.

6.YouprovidetheHostCredentialsforadatabaseuser.onthePerformRecovery：Typescreen.

7.Youclickthecontinuebutton.

Aninformationscreenappearssayingthatthedatabaseisunavailable.Whatisthisinformationscreen？（）

点击查看答案

第8题

Youexecuteacommandtoresizeadatafile，sales.dbf，ofsize200MBinyourdatabase：ALTERDATABASEDATAFILE’/remorse/sales.dbf’RESIZE150M；Whichstatementistrueaboutthiscommand（）

A.ThecommandmustbeissuedinMOUNTstate.

B.Thecommandsucceedsonlyifthedatafileisoffline.

C.Thecommandmustbeissuedwhenthedatabaseisinthearchivelogmode.

D.Thecommandsucceedsifnoextentinthetablespaceiscurrentlyallocatedabovethe150MBboundaryofthefile.

点击查看答案

第9题

WhichthreepiecesofinformationaretobemandatorilyprovidedwhilecreatinganewlistenerusingEnterpriseManagerDatabaseControl？（）

A.theportusedbythelistener

B.theprotocolusedbythelistener

C.theservernamewherethelistenerruns

D.thelogfileandtracefiledestinationforthelistener

E.thedatabaseservicestoberegisteredwiththelistener

点击查看答案

第10题

InwhichscenariodoyouusetheFlashbackDatabasefeature？（）

A.whenatableisdroppedandyourestoreitfromtheRecycleBin

B.whenauser’sschemaisdroppedandyourecovertheuser’sschema

C.whensomeincorrectdataisinsertedinthetableandyouretrievethetabletoastatethatwasatacertaintimestamp

D.whenarowofatableisupdatedfrequentlyandcommitted，andyouviewalltheversionsoftherowwithinaspecificduration

点击查看答案