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

[单选题]

YouworkasadatabaseadministratorforCertkiller.com.WhileloadingdataintotheCertkillerSTAFFtableusingOracleEnterpriseManager10gDatabaseControl，youfindthestatusofthejobasfailed.Onfurtherinvestigation，youfindthefollowingerrormessageintheoutputlog：ORA-01653unabletoextendtableHR.CertkillerSTAFFby8intablespaceUSERSWhichtaskwouldyouperformtoloadthedatasuccessfullywithoutaffectingtheuserswhoareaccessingthetable？（）

A.Restartthedatabaseinstanceandrunthejob

B.TruncatetheCertkillerSTAFFtableandrunthejob

C.DeleteallrowsfromtheCertkillerSTAFFtableandrunthejob

D.IncreasethesizeoftheUSERStablespacetheandrunthejob

E.Increasethesizeofthedatabasedefaultpermanenttablespaceandrunthejob

查看答案

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

您可能会需要：

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

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

更多“Youworkasadatabaseadministrato…”相关的问题

第1题

Which three are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12cwhen it is enabled?（）

A. Reduced logical I/O

B. Reduced virtual memory utilization

C. Improved parallel Execution performance

D. Improved Serial Execution performance

E. Reduced physical I/O

F. Reduced CPU utilization

点击查看答案

第2题

YouworkasadatabaseadministratorforCertkiller.com.UsersintheCertkiller.comPRODdatabasecompl

ainabouttheslowresponseoftransactions.Whileinvestigatingthereasonyoufindthatthetransactionsarewaitingfortheundosegmentstobeavailable，andundoretentionhasbeensettozero.Whatwouldyoudotoovercomethisproblem？（）

A.Increasetheundoreturn

B.Createmoreundosegments

C.Createanotherundotablespace

D.Increasethesizeoftheundotablespace

点击查看答案

第3题

In order to exploit some new storage tiers that have been provisioned by a storage adminis

trator, the partitions of a large heap table must be moved to other tablespaces in your Oracle 12c database?Both local and global partitioned B-tree Indexes are defined on the table.A high volume of transactions access the table during the day and a medium volume of transactions access it at night and during weekends.Minimal disrupt ion to availability is required.Which three statements are true about this requirement?（）

A. The partitions can be moved online to new tablespaces.

B. Global indexes must be rebuilt manually after moving the partitions.

C. The partitions can be compressed in the same tablespaces.

D. The partitions can be compressed in the new tablespaces.

E. Local indexes must be rebuilt manually after moving the partitions.

点击查看答案

第4题

Which three are true about the large pool for an Oracle database instance that supports shared serverconnections?（）

A. Allocates memory for RMAN backup and restore operations

B. Allocates memory for shared and private SQL areas

C. Contains a cursor area for storing runtime information about cursors

D. Contains stack space

E. Contains a hash area performing hash joins of tables

点击查看答案

第5题

ViewtheExhibitandexaminethedatainORDERS_MASTERandMONTHLYjDRDERStables.Whatwouldbetheoutcomeoftheabovestatement？（）

A.TheORDERS_MASTERtablewouldcontaintheORDERJDs1and2.

B.TheORDERS_MASTERtablewouldcontaintheORDERJDs1，2and3.

C.TheORDERS_MASTERtablewouldcontaintheORDERJDs1，2and4.

D.TheORDERSMASTERtablewouldcontaintheORDERIDs1，2，3and4.

点击查看答案

第6题

Youareworkingonatestdatabasewhereinstancerecoverytakesaconsiderableamountoftime.Howcanreducetherecoverytime？（）

A.Bymultiplexingthecontrolfiles

B.Bymultiplexingtheredologfiles

C.Bydecreasingthesizeofredologfiles

D.Byconfiguringmeantimetorecover（MTTR）toalowervalue

E.BysettingtheUNDO_RETENTIONparametertoahighervalue

点击查看答案

第7题

What are three purposes of the RMAN “FROM” clause?（）

A. to support PUSH-based active database duplication

B. to support synchronization of a standby database with the primary database in a Data environment

C. To support PULL-based active database duplication

D. To support file restores over the network in a Data Guard environment

E. To support file recovery over the network in a Data Guard environment

点击查看答案

第8题

YouworkasadatabaseadministratoratCertkiller&ensp

YouworkasadatabaseadministratoratCertkiller.com.YourdatabaseisopenandrunninginARCHIVELOGmode.YoutakeRMANfullbackupseverySundaynight.OnMondaymorning，whilequeryingtheuser1.employeestable，youreceivethefollowingerrormessage：

01578：ORACLEdatablockcorrupted（file#5，block#51）

ORA-01110：datafile5：’/u01/app/oracle/oradata/orcl/example01.dbf’

Youneedtorectifythecorruptionwhileensuringthefollowing：

Thedatafileshouldremainonline.

Themeantimetorecover（MTTR）shouldbeminimal.

Youarenotusingabackupcontrolfileandallthearchivedlogsareaccessible.

Whichoptionwouldyouchoose？（）

点击查看答案

第9题

YouareworkingonanOracleDatabase10gdatabase.YouenabledtheFlashbackDatabasefeature.Whichtwostatementsregardingflashbacklogsaretrue？（）

A.Flashbacklogsarenotarchived.

B.Flashbacklogsaremaintainedinredologfiles.

C.FlashbacklogsaremaintainedintheFlashRecoveryArea.

D.FlashbacklogsareusedtomaintainFlashbackDatabaserelatederrors.

E.FlashbacklogsneedtobeclearedmanuallyafteryoudisableFlashbackDatabase.

点击查看答案

第10题

You notice that the performance of your production 24/7 Oracle database significantly degr

aded.Sometimes you are not able to connect to the instance because it hangs. You do not want to restart thedatabase instance.How can you detect the cause of the degraded performance?（）

A. Enable Memory Access Mode, which reads performance data from SGA.

B. Use emergency monitoring to fetch data directly from SGA analysis.

C. Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.

D. Use Active Session History (ASH) data and hang analysis in regular performance monitoring.

E. Run ADDM in diagnostic mode.

点击查看答案