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

[单选题]

YoucreateanOracle10gdatabaseandconfiguretheSPFILEasfollows：SGA_TARGET=2GDB_CACHE_SIZE=512MLOG_BUFFER=50MDB_KEEP_CACHE_SIZE=128MYoumodifytheSGA_TARGETinitializationparameterusingthefollowingstatement：SQL＞ALTERSYSTEMSETSGA_TARGET=1GSCOPE=BOTH；Whichentitydoesthisstatementaffect？（）

A.onlytheauto-tunedmemorycomponents

B.onlythememorycomponentsthatarenotauto-tuned

C.boththeauto-tunedmemorycomponentsandthenon-auto-tunedmemorycomponents

D.neithertheauto-tunedmemorycomponentsnorthenon-auto-tunedmemorycomponents

查看答案

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

您可能会需要：

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

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

更多“YoucreateanOracle10gdatabasean…”相关的问题

第1题

YouworkasadatabaseadministratorforSupportcenter.cn.OnaMondaymorning，youfindthedatabaseinst

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

A.PMONcoordinatesmediarecovery.

B.SMONcoordinatesinstancerecovery.

C.PMONcoordinatesinstancerecovery.

D.UndoAdvisorwouldrollbackalluncommittedtransactions.

E.SQL*PLUSreportsanerrorwiththemessageaskingyoutoperforminstancerecovery.

点击查看答案

第2题

Consider the following:Which statement best describes the meaning of the value for the key_len column?（）

A.It shows the total size of the index row

B.It shows how many columns in the index are examined

C.It shows the number of characters indexed in the key

D.It shows how many bytes will be used from each index row

点击查看答案

第3题

InyourSupportcenter.cndatabaseservertheparameterPLSQL_CODE_TYPEhasbeensettoNATIVE.Whichobjectwouldbeachievedbythesetting？（）

A.ThesourcePL/SQLcodewillbestoredinnativemachinecode.

B.ThesourcePL/SQLcodewillbestoredininterpretedbytecode.

C.ThecompiledPL/SQLcodewillbestoredinnativemachinecode.

D.ThecompiledPL/SQLcodewillbestoredininterpretedbytecode.

点击查看答案

第4题

YourSPFILEcontainsthefollowingparametersettings：

SGA_TARGET=8G

DB_CACHE_SIZE=4G

SHARED_POOL_SIZE=2G

LARGE_POOL_SIZE=512M

JAVA_POOL_SIZE=512M

LOG_BUFFER=100M

SGA_MAX_SIZE=10G

YouquerytheV$SGA_DYNAMIC_COMPONENTSdynamicperformanceviewanddiscoverthatthelargepoolcomponentiscurrentlysizedat1G.YouwantthevalueoftheSGA_TARGETinitializationparameterto10G，butinsteadofspecifyingavalueof10GfortheSGA_TARGETinitializationparameter，youerroneouslyexecutethefollowingstatement：

SQL>ALTERSYSTEMSETSGA_TARGET=0SCOPE=BOTH；

Whatistheresultofthisstatement？（）

点击查看答案

第5题

Which NLS parameter can be used to change the default Oracle sort method from binary to linguistic for the SQL SELECT statement?（）

A. NLS_LANG

B. NLS_COMP

C. NLS_SORT

D. None of the above

点击查看答案

第6题

YousetthevalueoftheSGA_TARGETinitializationparameterto1GtoenableOracletoautomaticallyresiz

emostofthememorycomponentsaccordingtothecurrentworkloadinthedatabase.Youissuethefollowingstatement：SQL>SELECTname，value，isdefault2FROMv$parameter3WHEREnameLIKE’%size%’；TheoutputofthisstatementdisplaysthattheDB_CACHE_SIZE，SHARED_POOL_SIZE，LARGE_POOL_SIZE，andJAVA_POOL_SIZEinitializationparameterscontainazerovalue.Whatdoesthisimply？（）

A.TheSGA_TARGETinitializationparametercannotbesettoavaluelessthan1G

B.TheSGA_TARGETinitializationparametercannotbesettoavaluegreaterthan1G

C.TheMemoryAdvisoroftheOracleEnterpriseManager10gcannotbeusedtoobtainadviceontheimportantmemorycomponentsoftheSGA

D.ThevaluesoftheDB_CACHE_SIZE，SHARED_POOL_SIZE，LARGE_POOL_SIZE，andJAVA_POOL_SIZEinitializationparameterscannotbesetmanually.

E.NominimumlimitsareimposedontheDB_CACHE_SIZE，SHARED_POOL_SIZE，LARGE_POOL_SIZE，andJAVA_POOL_SIZEinitializationparameters.

F.TheAutomaticSharedMemoryManagementfeaturecannotbedisabledunlessyouspecifyvaluesfortheDB_CACHE_SIZE，SHARED_POOL_SIZE，LARGE_POOL_SIZE，andJAVA_POOL_SIZEinitializationparametersintheinitializationparameterfile.

点击查看答案

第7题

YouworkasadatabaseadministratorforSupportcenter.cn.UsersintheSupportcenter.cnPRODdatabasec

omplainabouttheslowresponseoftransactions.Whileinvestigatingthereasonyoufindthatthetransactionsarewaitingfortheundosegmentstobeavailable，andundoretentionhasbeensettozero.Whatwouldyoudotoovercomethisproblem？（）

A.Increasetheundoreturn

B.Createmoreundosegments

C.Createanotherundotablespace

D.Increasethesizeoftheundotablespace

点击查看答案

第8题

Which of the following would be affected by setting NLS_LENGTH_SEMANTICS=CHAR?（）

A. All objects in the database

B. Tables owned by SYS and SYSTEM

C. Data dictionary tables

D. NCHAR columns

E. CHAR columns

点击查看答案

第9题

ThedatabaseinstanceiscurrentlyusingSPFILE.View&e

ThedatabaseinstanceiscurrentlyusingSPFILE.ViewtheExhibitandexaminetheerrorthatyoureceivedwhilerunningtheDBStructureIntegritycheck.Givenbelowarethestepstorecoverfromtheerrorinrandomorder：

1.Shutdowntheinstance，ifnotalreadydone.

2.Copyoneoftheremainingcontrolfilestoanewlocation.

3.ChangethevalueoftheCONTROL_FILESinitializationparametertocorrespondtothenewlocationofthecontrolfiles.

4.StartupthedatabaseinstancetotheNOMOUNTstage.

5.Recoverthedatabasetothepointoffailureofthecontrolfile.

6.Openthedatabase.

Identifythecorrectsequenceofsteps（）

点击查看答案

第10题

Which three statements are true about memory buffer allocation by a MySQL Server?（）

A.Global buffers such as the InnoDB buffer pool are allocated after the server starts, and are never freed

B.Thread buffers are allocated when a client connects, and are freed when the client disconnects

C.Buffers that are needed for certain operation are allocated when the operation starts, and freed when it ends

D.User buffers are allocated at server startup and freed when the user is dropped

E.All dynamic buffers that are set with a SET GLOBAL statement immediately get allocated globally, and are never freed

点击查看答案