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

[主观题]

Inyourtestdatabase，youhavecreatedtheORDERStableasanindexorganizedtable（IOT）.To facilitatef

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

A.exportandimportthemappingtable

B.dropandrecreatethemappingtable

C.truncatethemappingtableandreinsertthevalues

D.usetheALTERTABLE..REBUILDcommandtodefragmentthemappingtable

查看答案

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

您可能会需要：

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

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

更多“Inyourtestdatabase，youhavecrea…”相关的问题

第1题

Auserperformsanupdateonatable.Shortlyaftercommittingthetransaction，theyrealizethattheyhada

nerrorintheirWHEREclausecausingthewrongrowstobeupdated.WhichFlashbackoptionwouldallowyoutoundothistransactionandrestorethetabletoitspreviousstate？（）

A.FlashbackDrop

B.FlashbackQuery

C.FlashbackVersionsQuery

D.FlashbackTransactionQuery

E.FlashbackTable

点击查看答案

第2题

Inoneofyouronlinetransactionprocessing（OLTP）applications，mostusersfrequentlymodifythevalue

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

A.heaptable

B.objecttable

C.externaltable

D.clusteredtable

E.globaltemporarytable

F.indexorganizedtable（IOT）

点击查看答案

第3题

Adevelopercallsandreportsthatheaccidentallydroppedanimportantlookuptablefromaproductiondatabase.Heneedsthetabletoberecovered.Whatactionwouldyoutake？（）

A.InitiateanincompleterecoveryoperationusingRMAN.

B.Copythetablefromadevelopmentdatabase.

C.Advisetheusertorekeythedata.

D.PerformaFlashbackDropoperation.

E.PerformaFlashbackRecoveryoperation.

点击查看答案

第4题

You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL p

lan baseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile. Which statement is true when you accept the suggested SQL profile?（）

A. The tuned plan is not added to the SQL plan baseline.

B. The tuned plan is added to the fixed SQL plan baseline as a fixed plan.

C. The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan.

D. The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.

点击查看答案

第5题

InaDatabaseReplayworkloadcapture，whatclientrequestinformationisgathered？（）

A.SQLtext

B.Sharedserverrequests（OracleMTS）

C.Bindvariablevalues

D.Informationabouttransactions

E.RemoteDESCRIBEandCOMMIToperations

点击查看答案

第6题

Yousetthefollowingparametersintheparameterfileandrestartedthedatabase：MEMORY_MAX_TARGET=0M

EMORY_TARGET=500MPGA_AGGREGATE_TARGET=90MSGA_TARGET=270MWhichtwostatementsaretrueabouttheseparametersafterthedatabaseinstanceisrestarted（）

A.TheMEMORY_MAX_TARGETparameterisautomaticallysetto500mb.

B.Thepga_AGGREGATE_TARGETandsga_TARGETparametersareautomaticallysettozero.

C.ThevalueoftheMEMORY_MAX_TARGETparameterremainszerountilitischangedmanually.

D.Thelowerboundsofpga_AGGREGATE_TARGETandsga_TARGETparametersaresetto90nband270mb，respectively

点击查看答案

第7题

Usersinyourproductiondatabasecomplainthattheyaregettingthefollowingerrormessagewhiletrying

toinsertrowsintotheORDERStable：ERRORatline1：ORA01654：unabletoextendindexUSERS.ORDERS_INDby8intablespaceINDEXESWhileinvestigating，youfindthattheINDEXEStablespacehasrunoutofspaceandthereisnomorefreespaceonthediskwherethedatafilesareavailable.Whichtwoactionscouldyouperformtoovercomethiserrorwithoutaffectingthequeriesthatarecurrentlybeingexecuted？（）

A.dropandrecreatetheindex

B.coalescetheORDERS_INDindex

C.coalescetheINDEXEStablespace

D.dropandrecreatetheORDERStable

E.rebuildtheindexonlineandmoveittoanothertablespace

点击查看答案

第8题

Which three statements correctly describe the features of the I/O calibration process?（）

A. Only one I/O calibration process can run at a time.

B. It automates the resource allocation for the Automated Maintenance Tasks.

C. It improves the performance of the performance-critical sessions while running.

D. It can be used to estimate the maximum number of I/Os and maximum latency time for the system.

E. The latency time is computed only when the TIMED_STATISTICS initialization parameter is set to TRUE.

点击查看答案

第9题

Youhavemanyuserscomplainingaboutslowinsertsintoalargetable.Whileinvestigatingthereason，you

findthatthenumberofindexesonthetableishigh.Youwanttofindoutwhichindexesarenotbeingused.Whichmethodwouldyoufollowtoachievethis？（）

A.enableindexmonitoringandquerytheDBA_OBJECTSview

B.enableindexmonitoringandquerytheDBA_INDEXESview

C.enableindexmonitoringandquerytheV$OBJECT_USAGEview

D.enableindexmonitoringandviewtheDBA_INDEXTYPE_COMMENTSview

点击查看答案

第10题

Which two statements about the SQL Management Base (SMB) are true?（）

A. It contains only SQL profiles generated by SQL Tuning Advisor.

B. It stores plans generated by the optimizer using a stored outline.

C. It is part of the data dictionary and stored in the SYSAUX tablespace.

D. It is part of the data dictionary and stored in the SYSTEM tablespace.

E. It contains the statement log, the plan history, plan baselines, and SQL profiles.

点击查看答案