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?()
第1题
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题
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题
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题
ethevalueoftheLOG_BUFFERinitializationparameter:ALTERSYSTEMSETLOG_BUFFER=32MSCOPE=BOTH;Whatwouldbetheoutcomeofthiscommand()
A.ThecommandsucceedsonlyifAutomaticMemoryManagementisnotenabled.
B.Thecommandsucceeds,butyouneedtorestartthedatabaseforchangestotakeeffect.
C.Thecommandreturnsanerrorbecausethesizeoftheredologbuffercannotbechangeddynamically.
D.TheparametervalueischangedanditcomesintoeffectassoonasspacebecomesavailableintheSystemGlobalArea(SGA)
第5题
E=512MSHARED_POOL_SIZE=128MLOG_BUFFER=10MDB_8K_CACHE_SIZE=50MWhatisthetotalmemorythatcanbedistributedacrosstheauto-tunedmemorycomponents?()
A.940M
B.990M
C.690M
D.1000M
第6题
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题
anceaborted.Afterinspectingthealertlogfile,youexecutetheSTARTUPcommandinSQL*Plustobringtheinstanceup.Whatstatementistrue?()
A.PMONcoordinatesmediarecovery.
B.SMONcoordinatesinstancerecovery.
C.PMONcoordinatesinstancerecovery.
D.UndoAdvisorwouldrollbackalluncommittedtransactions.
E.SQL*PLUSreportsanerrorwiththemessageaskingyoutoperforminstancerecovery.
第8题
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题
A.ThesourcePL/SQLcodewillbestoredinnativemachinecode.
B.ThesourcePL/SQLcodewillbestoredininterpretedbytecode.
C.ThecompiledPL/SQLcodewillbestoredinnativemachinecode.
D.ThecompiledPL/SQLcodewillbestoredininterpretedbytecode.
第10题
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?()
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!