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

[主观题]

Younoticedthattheindextablespaceinyourdatabaserequiresarecovery.However，insteadofperformin

gamediarecovery，youdecidedtorecreatetheindexesinanewtablespace.Whichtwooptionswouldyouusetoreducethetimeittakestorecreatetheindexes？（）

A.ONLINE

B.REVERSE

C.PARALLEL

D.COMPRESS

E.NOLOGGING

F.COMPUTESTATISTICS

查看答案

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

您可能会需要：

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

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

更多“Younoticedthattheindextablespa…”相关的问题

第1题

YourARCHIVELOG-modedatabasehaslostthreedatafiles

andshutdown.OneisassignedtotheSYSTEMtablespaceandtwoareassignedtotheUSERStablespace.Youcanchoosefromthefollowingstepstorecoveryourdatabase：

a.Restorethethreedatabasedatafilesthatwerelost.

b.IssuetheStartupMountcommandtomountthedatabase.

c.Issuethealterdatabaseopencommand.

d.Issuethealterdatabaseopenresetlogscommand.

e.Recoverthedatabaseusingtherecoverdatabasecommand.

f.Recoverthedatafileswiththerecoverdatafilecommand.

g.Takethedatafilesoffline.

Whichisthecorrectorderofthesestepsinthiscase？（）

点击查看答案

第2题

The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log

files are stored on three locations. The Flash Recovery Area is one of the locations. The details are given below:Which statement is true regarding what this command accomplishes?（）

A. All archived redo log files backed up at least twice to tape are deleted.

B. All archived redo log files backed up at least once to tape are eligible for deletion.

C. All archived redo log files backed up at least twice to tape are deleted from the flash recovery area.

D. All archived redo log files in local archiving destinations and the flash recovery area backed up at least twice to tape are eligible for deletion.

点击查看答案

第3题

YoulostthePRODSTDtablespace，whichwasread/write.Thetablespacewasreadonlywhenthelastbackupwasperformed.Howwouldyourecoverthetablespace？（）

A.restorethetablespacefromthebackupthereisnoneedtoapplytheredoinformation

B.restorethefulldatabasetorecoverthedatauptothepointwhenyouperformedthebackup

C.restorethetablespacefromthebackup，andthenperformarecoveryusingthebackupcontrolfile

D.restorethetablespacefromthebackup，andthenrecoverthetablespacealltheredoinformationfromthepointwhenthetablespacewasmaderead/writeisapplied

点击查看答案

第4题

Oneofthetablespacesisreadonlyinyourdatabase.Thelossofallcontrolfilesforcedyoutorecreatethecontrolfile.Whichoperationdoyouneedtoperformafterrecreatingthecontrolfileandopeningthedatabase？（）

A.dropandrecreatethereadonlytablespaces

B.renamethereadonlydatafilestotheircorrectfilenames

C.changethetablespacestatusfromread/writetoreadonly

D.recreatethereadonlytablespacebecauseitisautomaticallyremoved

点击查看答案

第5题

Youhaveareadonlytablespaceonreadonlymedia.Youwanttoperformamediarecoveryontheexistingdataf

iles，butusingabackupcontrolfile.Thebackupcontrolfileindicatesthatthestatusofthereadonlytablespacewasread/writewhenthecontrolfilewasbackedup.Whatshouldyouconsider？（）

A.dropthereadonlytablespaceandrecreatethetablespaceafterrecovery

B.takedatafilesfromthereadonlytablespaceofflinebeforeperformingarecovery

C.performarecoverystatusofthetablespaceincontrolfilewillbechangedautomatically

D.recoveryusingbackupcontrolfileisnotpossible，sorestoreallthefilesfromthelastfulldatabasebackup，andthenopenthedatabase

点击查看答案

第6题

Evaluate the following command:Which statement is true regarding the above command?（）

A. The LOB matically compressed.

B. The LOB values are cached bvalues are autoy default in the buffer cache.

C. The LOB values are automatically stored in encrypted mode.

D. All LOB data that is identical in two or more rows in a LOB column share the same data blocks.

点击查看答案

第7题

Youhavelostallyouronlineredologs.Asa

result，yourdatabasehascrashed.Youhavetriedtorestartthedatabaseandcleartheonlineredologfiles，butwhenyoutrytoopenthedatabaseyougetthefollowingerror.

SQL>startupORACLEinstancestarted.

TotalSystemGlobalArea167395328bytesFixedSize1298612bytesVariableSize142610252bytesDatabaseBuffers20971520bytesRedoBuffers2514944bytesDatabasemounted.

ORA-00313：openfailedformembersofloggroup2ofthread1ORA-00312：onlinelog2thread1：，，/oracle01/oradata/orcl/redo02a.logORA-27037：unabletoobtainfilestatusLinuxError：2：NosuchfileordirectoryAdditionalinformation：3

ORA-00312：onlinelog2thread1：，，/oracle01/oradata/orcl/redo02.logORA-27037：unabletoobtainfilestatusLinuxError：2：NosuchfileordirectoryAdditionalinformation：3

SQL>alterdatabaseclearlogfilegroup2；alterdatabaseclearlogfilegroup2*ERRORatline1：

ORA-01624：log2neededforcrashrecoveryofinstanceorcl（thread1）ORA-00312：onlinelog2thread1：，，/oracle01/oradata/orcl/redo02.logORA-00312：onlinelog2thread1：，，/oracle01/oradata/orcl/redo02a.log

Whatstepsmustyoutaketoresolvetheerror？（）

a.Issuetherecoverdatabaseredologscommand.

b.IssuetheStartupMountcommandtomountthedatabase.

c.Restorethelastfulldatabasebackup.

d.Performapoint-in-timerecovery，applyingallarchivedredologsthatareavailable.

e.Restoreallarchivedredologsgeneratedduringandafterthelastfulldatabasebackup.

f.Openthedatabaseusingthealterdatabaseopenresetlogscommand.

g.Issuethealterdatabaseopencommand.

点击查看答案

第8题

Click the Exhibit button. Given: ClassA a = new ClassA(); a.methodA(); What is the result? （）

A.Compilation fails.

B.ClassC is displayed.

C.The code runs with no output.

D.An exception is thrown at runtime.

点击查看答案

第9题

Thelossofthecontrolfileforcedyoutorecreatethecontrolfile.Afterrecreatingitandopeningthedat

abase，youfindthatsomeofthedatafilesarenamedasMISSINGnnnnn，wherennnnnisafivedigitnumberstartingwith0.Whatcouldbethepossiblereason？（）

A.Thesearethedatafilesthatarecorrupted.

B.ThereisnoSYSAUXtablespaceinyourdatabase

C.Thereisareadonlytablespaceinyourdatabase.

D.Thesearethedatafilesthatcannotberecovered.

点击查看答案

第10题

You are maintaining the SALES database.You have added a new disk to a disk group. Automati

c Storage Management performs the rebalancing activity. You want to speed up the rebalancing activity.Which parameter should you specify to control the speed of the rebalancing activity?（）

A. ASM_POWER_LIMIT

B. ASM_DISKSTRING

C. ASM_DISKGROUPS

D. INSTANCE_TYPE

点击查看答案