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

[主观题]

YouexecutethefollowingcommandtochangethestatusoftheSALEStablespace：SQL＞ALTERTABLESPACEsalesOFFLINE；Whichstatementsdescribetheeffectofthecommand（）

A.Thetablespacewouldrequirerecoverytogobackonline.

B.AcheckpointistakenonalldatafilesthatareassociatedwiththeSALEStablespace.

C.ThesessionsthatsubsequentlytrytoaccesstheobjectsintheSALEStablespacereceiveanerror

D.ThenewstatusoftheSALEStablespaceisrecordedinthecontrolfilewhenthedatabaseinstanceisclosed

查看答案

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

您可能会需要：

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

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

更多“Youexecutethefollowingcommandt…”相关的问题

第1题

YouexecutedthefollowingcommandinRecoveryManager（RMAN）：RMAN>REPORTNEEDBACKUPdays3；Whatistheoutputofthiscommand？（）

A.alistoffilesthatrequireabackupwithinthreedays

B.alistoffilesrequiringmorethan3daysofarchivelogstoapply

C.alistoffilesthatRMANrecommendsbebackeduponlyonceineverythreedays，basedonlowvolatility

D.alistoffilesforwhichabackuphasalreadybeenperformedinthelastthreedaysandwhichisrequiredtobebackedupagainbasedonthehighnumberoftransactionsperformedonthem

点击查看答案

第2题

ViewtheExhibitandexaminethepropertiesoftheUSERStablespace.Youexecutethefollowingstatementt

oshrinktheTRANStableexistingontheUSERStablespace：SQL>ALTERTABLEtransSHRINKSPACECASCADEWhichobjectswouldbeaffectedbythiscommand？（）

A.theTRANStable

B.theB*TreeindexesontheTRANStable

C.thematerializedviewslogoftheTRANStable

D.thematerializedviewsbasedontheTRANStable

E.thelargeobject（LOB）segmentsoftheTRANStable

点击查看答案

第3题

Whiledesigningyourdatabase，youhavecreatedtheEMPLOYEEStableasanindexorganizedtable（IOT）.You

wanttocreateabitmapindexontheJOB_IDcolumntomakequeriesfaster.Whichtaskmusthavebeencompletedsothatyouareabletocreatethebitmapindex？（）

A.Aprimarykeymusthavebeencreated.

B.Amappingtablemusthavebeencreated.

C.Anoverflowtablespacemusthavebeenspecified.

D.ThePCTTHRESHOLDoptionmusthavebeenspecified.

点击查看答案

第4题

Youhaveconfiguredflashrecoveryareainyourda

tabaseandyousetthefollowingInitializationparametersforyourdatabaseinstance：

LOG_ARCHIVE_DEST1=，，LOCATION=/disk1/archMANDATORY’

LOG_ARCHIEVE_DEST2=，，LOCATION=/disk2/arch’

LOG_ARCHIVK_DEST_3=，，LOCATION=/diSk3/arch

LOG_ARCH1VK_DEST_4=’LOCATION=/disk4/arch’

LOG_ARCHIVE_MIN-SUCCEED_DEST=2

Whilethedatabaseinstanceisfunctional，yourealizedthatthedestinationsetbythe

LOG_ARCHIVE_DEST_IparameterIsnotavailableforthearchivedredologfiletobecreatedin.Allredologgroupshavebeenused.

Whathappensinaneventoflogswitch？（）

点击查看答案

第5题

You are working on a CATDB database that contains an Oracle Database version 11.1 catalog

schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10, into the recovery catalog owned by RCO11.You executed the following RMAN commands:RMAN> CONNECT CATALOG rco11/password@catdbRMAN> IMPORT CATALOG rcat10/oracle@inst1;What happens when you execute the above commands?（）

A. They deregister all databases registered in the RCAT10 catalog.

B. They import metadata for all registered databases in the RCAT10 database.

C. They register all the RCAT10-catalog registered databases in the RCO11 catalog.

D. They overwrite all stored scripts in the RCO11 catalog with the same name as that in the RCAT10 catalog.

点击查看答案

第6题

Inyourdatawarehousingapplication，yougeneratereportsfrequently.Thedataisstaticinthetablesbe

ingusedtogeneratereports.Youarecurrentlyusingjoins，resultinginalargeperformanceoverhead.Whatkindofdatabasestructurewouldyouusetoreducetheresponsetimeofthequery？（）

A.hashclusters

B.indexclusters

C.partitionedtables

D.indexorganizedtable（IOT）

点击查看答案

第7题

WhatRMANcommandisusedtoexecuteatablespacepoint-in-timerecovery？（）

A.recover

B.duplicate

C.restore

D.copy

E.Noneoftheabove

点击查看答案

第8题

Inyourtestdatabase，youhavecreatedtheORDERStableasanindexorganizedtable（IOT）.To facilitatef

asterquerying，youhavecreatedamappingtableandabitmapindexontheORDER_FILLEDcolumn.Youobservethatthequeryperformancedegradeswhenusersperformalargevolumeoftransactions.Whileinvestigatingthereason，youfindthatthemappingtablesegmentisfragmented，leadingtopoorperformance.Whichoptionwouldyouusetodefragmentthemappingtablewithoutaffectingtheoriginaltabledata？（）

A.exportandimportthemappingtable

B.dropandrecreatethemappingtable

C.truncatethemappingtableandreinsertthevalues

D.usetheALTERTABLE..REBUILDcommandtodefragmentthemappingtable

点击查看答案

第9题

Auserperformsanupdateonatable.Shortlyaftercommittingthetransaction，theyrealizethattheyhada

nerrorintheirWHEREclausecausingthewrongrowstobeupdated.WhichFlashbackoptionwouldallowyoutoundothistransactionandrestorethetabletoitspreviousstate？（）

A.FlashbackDrop

B.FlashbackQuery

C.FlashbackVersionsQuery

D.FlashbackTransactionQuery

E.FlashbackTable

点击查看答案

第10题

Inoneofyouronlinetransactionprocessing（OLTP）applications，mostusersfrequentlymodifythevalue

s，includingthekeyvalues，oftheapplicationtables.Someusersgenerateapplicationreportsbyusingmultipleapplicationtables.Whatisthebesttablestructurethatyoucanusetogainoptimalperformance？（）

A.heaptable

B.objecttable

C.externaltable

D.clusteredtable

E.globaltemporarytable

F.indexorganizedtable（IOT）

点击查看答案