与你交往的人中,哪种性格类型的人最多:()。
A.性格、志趣相近的人
B.年龄、爱好差异较大的人
C.性格、教养差异较小的人
D.平和、易相处的人
第1题
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.
第2题
A. NLS_LANG
B. NLS_COMP
C. NLS_SORT
D. None of the above
第3题
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?()
第4题
A.ThesourcePL/SQLcodewillbestoredinnativemachinecode.
B.ThesourcePL/SQLcodewillbestoredininterpretedbytecode.
C.ThecompiledPL/SQLcodewillbestoredinnativemachinecode.
D.ThecompiledPL/SQLcodewillbestoredininterpretedbytecode.
第5题
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
第6题
A.PMONcoordinatesmediarecovery.
B.SMONcoordinatesinstancerecovery.
C.PMONcoordinatesinstancerecovery.
D.UndoAdvisorwouldrollbackalluncommittedtransactions.
E.SQL*PLUSreportsanerrorwiththemessageaskingyoutoperforminstancerecovery.
第7题
A.onlytheauto-tunedmemorycomponents
B.onlythememorycomponentsthatarenotauto-tuned
C.boththeauto-tunedmemorycomponentsandthenon-auto-tunedmemorycomponents
D.neithertheauto-tunedmemorycomponentsnorthenon-auto-tunedmemorycomponents
第8题
A.940M
B.990M
C.690M
D.1000M
第9题
A.ThecommandsucceedsonlyifAutomaticMemoryManagementisnotenabled.
B.Thecommandsucceeds,butyouneedtorestartthedatabaseforchangestotakeeffect.
C.Thecommandreturnsanerrorbecausethesizeoftheredologbuffercannotbechangeddynamically.
D.TheparametervalueischangedanditcomesintoeffectassoonasspacebecomesavailableintheSystemGlobalArea(SGA)
第10题
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;
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!