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

[主观题]

Which Oracle Database component is audited by default if the unified Auditing option is enabled？（）

A. Oracle Data Pump

B. Oracle Recovery Manager (RMAN)

C. Oracle Label Security

D. Oracle Database Vault

E. Oracle Real Application Security

查看答案

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

您可能会需要：

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

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

更多“Which Oracle Database componen…”相关的问题

第1题

YouworkasadatabaseadministratorforCertkiller.com.OnaMondaymorning，youfindthedatabaseinstan

ceaborted.Afterinspectingthealertlogfile，youexecutetheSTARTUPcommandinSQL*Plustobringtheinstanceup.Whatstatementistrue？（）

A.PMONcoordinatesmediarecovery.

B.SMONcoordinatesinstancerecovery.

C.PMONcoordinatesinstancerecovery.

D.UndoAdvisorwouldrollbackalluncommittedtransactions.

E.SQL*PLUSreportsanerrorwiththemessageaskingyoutoperforminstancerecovery.

点击查看答案

第2题

Exhibit，ViewtheExhibitandexaminetheResourceManagersettingsforthegroupsatdifferentlevels.Whichtwoeffectswouldbetheresultofthissetting？（）

A.ThemembersofLOW_GROUPwouldgetmoreprioritythanthoseofOTHER_GROUPS.

B.ThemembersofSYS_GROUPwouldgetmostoftheCPUallocationatlevel1.

C.ThemembersofLOW_GROUPwouldgetmostoftheCPUallocationbecauseithasCPUallocationattwodifferentlevels.

D.ThemembersofLOW_GROUPwouldgetnoCPUallocationatlevel1ifthemembersofOTHER_GROUPSareusingalltheCPUatlevel2.

E.ThemembersofSYS_GROUPwouldgetnoCPUallocationatlevel1ifthemembersofOTHER_GROUPSareusingalltheCPUatlevel2.

点击查看答案

第3题

Your multitenant container (CDB) containing three pluggable databases (PDBs) is running in

ARCHIVELOG mode. You find that the SYSAUX tablespace is corrupted in the root container.The steps to recover the tablespace are as follows:1. Mount the CDB.2. Close all the PDBs.3. Open the database.4. Apply the archive redo logs.5. Restore the data file.6. Take the SYSAUX tablespace offline.7. Place the SYSAUX tablespace online.8. Open all the PDBs with RESETLOGS.9. Open the database with RESETLOGS.10. Execute the command SHUTDOWN ABORT.Which option identifies the correct sequence to recover the SYSAUX tablespace?（）

A.6，5，4，7

B.10，1，2，5，8

C.10，1，2，5，4，9，8

D.10，1，5，8，10

点击查看答案

第4题

InyourCertkiller.comdatabaseservertheparameterPLSQL_CODE_TYPEhasbeensettoNATIVE.Whichobjectwouldbeachievedbythesetting？（）

A.ThesourcePL/SQLcodewillbestoredinnativemachinecode.

B.ThesourcePL/SQLcodewillbestoredininterpretedbytecode.

C.ThecompiledPL/SQLcodewillbestoredinnativemachinecode.

D.ThecompiledPL/SQLcodewillbestoredininterpretedbytecode.

点击查看答案

第5题

Evaluatethefollowingstatement：WhichstatementistrueregardingtheevaluationofrowsreturnedbythesubqueryintheINSERTstatement？（）

A.TheyareevaluatedbyallthethreeWHENclausesregardlessoftheresultsoftheevaluationofanyotherWHENclause.

B.TheyareevaluatedbythefirstWHENclause.Iftheconditionistrue，thentherowwouldbeevaluatedbythesubsequentWHENclauses.

C.TheyareevaluatedbythefirstWHENclause.Iftheconditionisfalse，thentherowwouldbeevaluatedbythesubsequentWHENclauses.

D.TheINSERTstatementwouldgiveanerrorbecausetheELSEclauseisnotpresentforsupportincasenoneoftheWHENclausesaretrue.

点击查看答案

第6题

Thecurrenttimezoneforoneoftheusersessionsissettothedatabaselocaltimezone.Foroneapplication

，theusersessionrequiresthetimezonetobesettothelocaloperatingsystemtimezonewithoutaffectingotherusersessions.Whichtwosolutionscouldtheuserimplementtoachievethisobjective？（）

A.usetheALTERSYSTEMcommandtochangethetimezone

B.usetheALTERSESSIONcommandtochangethetimezone

C.usetheALTERDATABASEcommandtochangethetimezone

D.setthevaluefortheoperatingsystemvariableORA_SDTZontheclientmachine

E.setthevaluefortheoperatingsystemvariableORA_SDTZonthedatabaseservermachine

点击查看答案

第7题

YouworkasadatabaseadministratorforCertkiller.com.WhileloadingdataintotheCertkillerSTAFFtab

leusingOracleEnterpriseManager10gDatabaseControl，youfindthestatusofthejobasfailed.Onfurtherinvestigation，youfindthefollowingerrormessageintheoutputlog：ORA-01653unabletoextendtableHR.CertkillerSTAFFby8intablespaceUSERSWhichtaskwouldyouperformtoloadthedatasuccessfullywithoutaffectingtheuserswhoareaccessingthetable？（）

A.Restartthedatabaseinstanceandrunthejob

B.TruncatetheCertkillerSTAFFtableandrunthejob

C.DeleteallrowsfromtheCertkillerSTAFFtableandrunthejob

D.IncreasethesizeoftheUSERStablespacetheandrunthejob

E.Increasethesizeofthedatabasedefaultpermanenttablespaceandrunthejob

点击查看答案

第8题

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

点击查看答案

第9题

YouworkasadatabaseadministratorforCertkiller.com.UsersintheCertkiller.comPRODdatabasecompl

ainabouttheslowresponseoftransactions.Whileinvestigatingthereasonyoufindthatthetransactionsarewaitingfortheundosegmentstobeavailable，andundoretentionhasbeensettozero.Whatwouldyoudotoovercomethisproblem？（）

A.Increasetheundoreturn

B.Createmoreundosegments

C.Createanotherundotablespace

D.Increasethesizeoftheundotablespace

点击查看答案

第10题

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.

点击查看答案