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

[主观题]

以下的PL/SQL声明哪个是正确的？（）

A.v_id NUMBER(4);

B.v_x, v_y, v_z VARCHAR2(10);

C.v_birthdate DATE NOT NULL;

D.v_in_stock BOOLEAN := 1;

查看答案

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

您可能会需要：

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

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

更多“以下的PL/SQL声明哪个是正确的？（）”相关的问题

第1题

WhatcriteriondoesOracle9iusetodeterminewhetheradatabasefileisanOracleManagedFile？（）

A.Thefilenameformat.

B.Informationstoredinsideadatadictionarytable.

C.InformationstoredintheALERT.LOGfileforthecorrespondinginstance.

D.Informationstoredinsidethecorrespondinginitializationparameterfilefortheinstance.

点击查看答案

第2题

Oracle9iextendsthecursorsharingfunctionalitywiththenewvalueofSIMILARfortheCURSOR_SHARINGparameter.WithCURSOR_SHARING=SIMILAR，cursorsaresharedforsafeliteralsonly.Whatismeantby‘safeliteralsonly’？（）

A.Noliteralvalueissubstitutedforasharedcursor.

B.Differentexecutionplansaregeneratedforsubstitutedliteralvalues.

C.Thesubstitutionofaliteralvaluewillproducedifferentexecutionplans.

D.Thesubstitutionofanyliteralvaluewillproduceexactlythesameexecutionplan.

点击查看答案

第3题

heDynamicSGAfeatureallowstheSGAtogrowandshrinkdynamicallyaccordingtoanALTERSYSTEMcommand.T

hisavoidsthepreviousneedofshuttingdowntheinstanceinordertomodifythecomponentsoftheSGA，namelythebuffercacheandsharedpoolcomponents.WhichthreestatementsaretruefortheDynamicSGAfeature？（）

A.A

B.B

C.C

D.D

E.E

点击查看答案

第4题

Thereismorethanonewaytosettheservertodetectandaffectlongrunningoperationsautomatically.Wha

tisthebestchoiceofyouwanttoreducetheimpactoflongrunningoperationsonotheruserswithoutabortingthelongrunningoperations？（）

A.DefineuserprofilesandsettheCPU_PER_CALLlimit.

B.DefineaSWITCH_TIMEforaplanintheResourceManager.

C.CreateabatchjobthatchecksV$SESSION_LONGOPS；thebatchjobaltersthesessionpriorityofthelongrunningoperations.

D.CreateauserdefinedeventintheOracleEnterpriseManager，whichmonitors V$SESSION_LONGOPS.

点击查看答案

第5题

Whatarethreebenefitsofperformingdatadefinitionlanguage（DDL）statementsagainstapartitionedtablewiththeUPDATEGLOBALINDEXESclause？（）

A.GlobalindexesarerebuiltautomaticallyattheendoftheDDLoperationtherebyavoidingproblemswiththeUNUSABLEstatus.

B.YoudonothavetosearchforinvalidglobalindexesaftertheDDLcommandcompletesandrebuildthemindividually.

C.GlobalindexesaremaintainedduringtheoperationoftheDDLcommandandthereforecanbeusedbyanyconcurrentquery.

D.Globalindexesremainintactandavailableforusebydatamanipulationlanguage（DML）statementsevenforsessionsthathavenotenabledtheskippingofunusableindexes.

点击查看答案

第6题

TheuseristryingtoexecuteaSELECTstatement.Whichofthefollowingbackgroundprocesseswillobtaindatafromadiskfortheuser?（）

A.DISPATCHER

B.USER

C.SERVER

D.LGWR

E.DBW0

点击查看答案

第7题

WhichstatementcorrectlydescribesthefunctionofOracle9iCacheFusionfeature？（）

A.Itprovideseachsessionwithitsownviewofthedatabaseatadifferentpointinthepast.

B.Itenablesyoutoexecutescalableapplicationsonaclustereddatabasewithouthavingtopartitiontheusersorthedatabasetables.

C.Itletsyoudynamicallyreassignmemoryinyourdatabasebuffercachetodifferentblockbuffersizes.

D.Itallowsyoutoaddnewsitestomultimasterreplicationenvironmentwithoutquiescingthemasterdefinitionsite.

点击查看答案

第8题

WhichcomponentoftheSGAstoresparsedSQLstatementsisusedforprocesssharing?（）

A.Buffercache

B.Redologbuffer

C.PrivateSQLarea

D.Librarycache

E.Rowcache

点击查看答案

第9题

Whatistrueifyouwanttoswitchundotablespacesfromthecurrentone，calledUNDO1，toanewonecalledUNDO2？（）

A.ItisNOTpossibletoswitchunlessnoactivetransactionexistinUNDO1.

B.ItispossibletoswitchtoUNDO2；butcurrentactivetransactionswillabort.

C.ItispossibletoswitchtoUNDO2；currentactivetransactionswillbeautomaticallymigratedtoUNDO2.

D.ItispossibletoswitchtoUNDO2；onlycurrentactivetransactionswillcontinuetoexecuteinsideUNDO1.

点击查看答案

第10题

Flushingdirtybuffersoutofthebuffercacheisinfluencedtothegreatestextentbywhichofthefollowingprocess?（）

A.ARCH

B.SMON

C.LGWR

D.SERVER

点击查看答案

谢谢您的反馈

您认为本题答案有误，我们将认真、仔细核查，
如果您知道正确答案，欢迎您来纠错

开始纠错>>>

警告：系统检测到您的账号存在安全风险

为了保护您的账号安全，请在“上学吧”公众号进行验证，点击“官网服务”-“账号验证”后输入验证码“”完成验证，验证成功后方可继续查看答案！

微信搜一搜

上学吧

点击打开微信

警告：系统检测到您的账号存在安全风险

抱歉，您的账号因涉嫌违反上学吧购买须知被冻结。您可在“上学吧”微信公众号中的“官网服务”-“账号解封申请”申请解封，或联系客服。

微信搜一搜

上学吧

点击打开微信