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

[主观题]

Thewarninglevelthresholdvalueforatablespace，&ens

Thewarninglevelthresholdvalueforatablespace，DATA1，issetto60%andthecriticallevelthresholdvalueissetto80%.Thetablespace，DATA1，isinfrequentlyusedandisnotapartoftheproductionenvironment.Youissuedthefollowingcommand：

SQL＞EXECUTE

DBMS_SERVER_ALERT.SET_THRESHOLD

（dbms_server_alert.tablespace_pct_full，

dbms_server_alert.operator_ge，80，

dbms_server_alert.operator_ge，90，

1，1，NULL，

dbms_server_alert.object_type_tablespace，’DATA’）；

Whatwillbetheresultofthecommand？（）

查看答案

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

您可能会需要：

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

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

更多“Thewarninglevelthresholdvaluef…”相关的问题

第1题

TheAutomaticSharedMemoryManagementfeatureisenabledforthePRODdatabase.Currently，alotofinser

tactivityistakingplaceinthedatabase，andthememorystructuresareallocatedaccordingtothedatabaseworkload.Astheworkloadreduces，youdecidetoperformbatchjobsinthedatabase.WhichofthefollowinginitializationparametersareNOTautomaticallyresizedaccordingtothenewworkloadandcontinuetoremainunchanged？（）

A.LOG_BUFFER

B.DB_CACHE_SIZE

C.JAVA_POOL_SIZE

D.LARGE_POOL_SIZE

E.SHARED_POOL_SIZE

F.STREAMS_POOL_SIZE

点击查看答案

第2题

Which of the following NLS_SORT parameter values would result in case-insensitive and accent-insensitive binary sorts?（）

A. NLS_SORT = BINARY

B. NLS_SORT = BINARY_AI

C. NLS_SORT = BINARY_CI

D. NLS_SORT = BINARY_AI_CI

E. Binary sorts are case insensitive and accent insensitive by default.

点击查看答案

第3题

Examine the structure if the EMPLOYEES table:Column name Data Type RemarksEMPLOYEE_ID NUMB

ER NOT NULL, Primary KeyEMP_NAME VARCHAR2(30)JOB_ID VARCHAR2(20) NOT NULLSAL NUMBERMGR_ID NUMBER References EMPLOYEE_ID columnDEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS tableYou need to create a view called EMP_VU that allows the user to insert rows through the view. Which SQL statement, when used to create the EMP_VU view, allows the user to insert rows? （）

A. CREATE VIEW emp_Vu AS SELECT employee_id, emp_name, department_id FROM employees WHERE mgr_id IN (102, 120);

B. CREATE VIEW emp_Vu AS SELECT employee_id, emp_name, job_id department_id FROM employees WHERE mgr_id IN (102, 120);

C. CREATE VIEW emp_Vu AS SELECT department_id, SUM(sal) TOTALSAL FROM employees WHERE mgr_id IN (102, 120) GROUP BY department_ id;

D. CREATE VIEW emp_Vu AS SELECT employee_id, emp_name, job_id, DISTINCT department_id FROM employees;

点击查看答案

第4题

ourdatabaseinstanceisstartedusingtheserverparameterfile（SPFILE）.Youexecutedacommandtochang

ethevalueoftheLOG_BUFFERinitializationparameter：ALTERSYSTEMSETLOG_BUFFER=32MSCOPE=BOTH；Whatwouldbetheoutcomeofthiscommand（）

A.ThecommandsucceedsonlyifAutomaticMemoryManagementisnotenabled.

B.Thecommandsucceeds，butyouneedtorestartthedatabaseforchangestotakeeffect.

C.Thecommandreturnsanerrorbecausethesizeoftheredologbuffercannotbechangeddynamically.

D.TheparametervalueischangedanditcomesintoeffectassoonasspacebecomesavailableintheSystemGlobalArea（SGA）

点击查看答案

第5题

TheSPFILEforyourdatabasecontainsthefollowingparametersettings：SGA_TARGET=1000MDB_CACHE_SIZ

E=512MSHARED_POOL_SIZE=128MLOG_BUFFER=10MDB_8K_CACHE_SIZE=50MWhatisthetotalmemorythatcanbedistributedacrosstheauto-tunedmemorycomponents？（）

A.940M

B.990M

C.690M

D.1000M

点击查看答案

第6题

YoucreateanOracle10gdatabaseandconfiguretheSPFILEasfollows：SGA_TARGET=2GDB_CACHE_SIZE=512M

LOG_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

点击查看答案

第7题

YouworkasadatabaseadministratorforSupportcenter.cn.OnaMondaymorning，youfindthedatabaseinst

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

A.PMONcoordinatesmediarecovery.

B.SMONcoordinatesinstancerecovery.

C.PMONcoordinatesinstancerecovery.

D.UndoAdvisorwouldrollbackalluncommittedtransactions.

E.SQL*PLUSreportsanerrorwiththemessageaskingyoutoperforminstancerecovery.

点击查看答案

第8题

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

点击查看答案

第9题

InyourSupportcenter.cndatabaseservertheparameterPLSQL_CODE_TYPEhasbeensettoNATIVE.Whichobjectwouldbeachievedbythesetting？（）

A.ThesourcePL/SQLcodewillbestoredinnativemachinecode.

B.ThesourcePL/SQLcodewillbestoredininterpretedbytecode.

C.ThecompiledPL/SQLcodewillbestoredinnativemachinecode.

D.ThecompiledPL/SQLcodewillbestoredininterpretedbytecode.

点击查看答案

第10题

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？（）

点击查看答案