网友您好，请在下方输入框内输入要搜索的题目：

搜题

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

[主观题]

Your multitenant container database, CDB1, is running in ARCHIVELOG mode and has two plugg

able databases, HR_PDB and ACCOUNTS_PDB. An RMAN backup exists for the database.You issue the command to open ACCOUNTS_PDB and find that the USERDATA.DBF data file for the default permanent tablespace USERDATA belonging to ACCOUNTS_PDB is corrupted.What should you do before executing the commands to restore and recover the data file in ACCOUNTS_PDB？（）

A. Place CDB1 in the mount stage and then the USERDATA tablespace offline in ACCOUNTS_PDb.

B. Place CDB1 in the mount stage and issue the ALTER PLUGGABLE DATABASE accounts_pdb CLOSE IMMEDIATE command.

C. Issue the ALTER PLUGGABLE DATABASE accounts_pdb RESTRICTED command.

D. Take the USERDATA tablespace offline in ACCOUNTS_PDb.

查看答案

更多“Your multitenant container database, CDB1, is running in ARCHIVELOG mode and has two plugg”相关的问题

第1题

YourbossatCertkiller.comwantsyoutoclarifyOracle10g.WhatstatementabouttheSharedServerconfigurationisvalid？（）

A.A

B.B

C.C

D.D

点击查看答案

第2题

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

点击查看答案

第3题

YouworkasadatabaseadministratorforCertkiller.com.OnaMondaymorning，youfindthedatabaseinstan

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

A.PMONcoordinatesmediarecovery.

B.SMONcoordinatesinstancerecovery.

C.PMONcoordinatesinstancerecovery.

D.UndoAdvisorwouldrollbackalluncommittedtransactions.

E.SQL*PLUSreportsanerrorwiththemessageaskingyoutoperforminstancerecovery.

点击查看答案

第4题

Exhibit，ViewtheExhibitandexaminetheResourceManagersettingsforthegroupsatdifferentlevels.Whichtwoeffectswouldbetheresultofthissetting？（）

A.ThemembersofLOW_GROUPwouldgetmoreprioritythanthoseofOTHER_GROUPS.

B.ThemembersofSYS_GROUPwouldgetmostoftheCPUallocationatlevel1.

C.ThemembersofLOW_GROUPwouldgetmostoftheCPUallocationbecauseithasCPUallocationattwodifferentlevels.

D.ThemembersofLOW_GROUPwouldgetnoCPUallocationatlevel1ifthemembersofOTHER_GROUPSareusingalltheCPUatlevel2.

E.ThemembersofSYS_GROUPwouldgetnoCPUallocationatlevel1ifthemembersofOTHER_GROUPSareusingalltheCPUatlevel2.

点击查看答案

第5题

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

点击查看答案

第6题

InyourCertkiller.comdatabaseservertheparameterPLSQL_CODE_TYPEhasbeensettoNATIVE.Whichobjectwouldbeachievedbythesetting？（）

A.ThesourcePL/SQLcodewillbestoredinnativemachinecode.

B.ThesourcePL/SQLcodewillbestoredininterpretedbytecode.

C.ThecompiledPL/SQLcodewillbestoredinnativemachinecode.

D.ThecompiledPL/SQLcodewillbestoredininterpretedbytecode.

点击查看答案

第7题

Evaluatethefollowingstatement：WhichstatementistrueregardingtheevaluationofrowsreturnedbythesubqueryintheINSERTstatement？（）

A.TheyareevaluatedbyallthethreeWHENclausesregardlessoftheresultsoftheevaluationofanyotherWHENclause.

B.TheyareevaluatedbythefirstWHENclause.Iftheconditionistrue，thentherowwouldbeevaluatedbythesubsequentWHENclauses.

C.TheyareevaluatedbythefirstWHENclause.Iftheconditionisfalse，thentherowwouldbeevaluatedbythesubsequentWHENclauses.

D.TheINSERTstatementwouldgiveanerrorbecausetheELSEclauseisnotpresentforsupportincasenoneoftheWHENclausesaretrue.

点击查看答案

第8题

Thecurrenttimezoneforoneoftheusersessionsissettothedatabaselocaltimezone.Foroneapplication

，theusersessionrequiresthetimezonetobesettothelocaloperatingsystemtimezonewithoutaffectingotherusersessions.Whichtwosolutionscouldtheuserimplementtoachievethisobjective？（）

A.usetheALTERSYSTEMcommandtochangethetimezone

B.usetheALTERSESSIONcommandtochangethetimezone

C.usetheALTERDATABASEcommandtochangethetimezone

D.setthevaluefortheoperatingsystemvariableORA_SDTZontheclientmachine

E.setthevaluefortheoperatingsystemvariableORA_SDTZonthedatabaseservermachine

点击查看答案

第9题

YouworkasadatabaseadministratorforCertkiller.com.WhileloadingdataintotheCertkillerSTAFFtab

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

A.Restartthedatabaseinstanceandrunthejob

B.TruncatetheCertkillerSTAFFtableandrunthejob

C.DeleteallrowsfromtheCertkillerSTAFFtableandrunthejob

D.IncreasethesizeoftheUSERStablespacetheandrunthejob

E.Increasethesizeofthedatabasedefaultpermanenttablespaceandrunthejob

点击查看答案

第10题

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

点击查看答案

账号：尚未登录

登录没有账号？去注册

我要提问

联系客服

购买搜题卡

题库练习

课程学习

功能	扣减规则
功能	基础费（查看答案）	加收费（AI功能）
文字搜题、查看答案	1/每题	0/每次
语音搜题、查看答案	1/每题	2/每次
单题拍照识别、查看答案	1/每题	2/每次
整页拍照识别、查看答案	1/每题	5/每次