“管理”和“领导”概念的关系是：（)。A．领导是管理的职能活动之一B．一个领导者必然是管理者C．两者没有

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

YouworkasadatabaseadministratorforSupportcenter.cn.OnaMondaymorning，youfindthedatabaseinstanceaborted.Afterinspectingthealertlogfile，youexecutetheSTARTUPcommandinSQL*Plustobringtheinstanceup.Whatstatementistrue？（）

A.PMONcoordinatesmediarecovery.

B.SMONcoordinatesinstancerecovery.

C.PMONcoordinatesinstancerecovery.

D.UndoAdvisorwouldrollbackalluncommittedtransactions.

E.SQL*PLUSreportsanerrorwiththemessageaskingyoutoperforminstancerecovery.

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

TheSPFILEforyourdatabasecontainsthefollowingparametersettings：SGA_TARGET=1000MDB_CACHE_SIZE=512MSHARED_POOL_SIZE=128MLOG_BUFFER=10MDB_8K_CACHE_SIZE=50MWhatisthetotalmemorythatcanbedistributedacrosstheauto-tunedmemorycomponents？（）

A.940M

B.990M

C.690M

D.1000M

ourdatabaseinstanceisstartedusingtheserverparameterfile（SPFILE）.YouexecutedacommandtochangethevalueoftheLOG_BUFFERinitializationparameter：ALTERSYSTEMSETLOG_BUFFER=32MSCOPE=BOTH；Whatwouldbetheoutcomeofthiscommand（）

A.ThecommandsucceedsonlyifAutomaticMemoryManagementisnotenabled.

B.Thecommandsucceeds，butyouneedtorestartthedatabaseforchangestotakeeffect.

C.Thecommandreturnsanerrorbecausethesizeoftheredologbuffercannotbechangeddynamically.

D.TheparametervalueischangedanditcomesintoeffectassoonasspacebecomesavailableintheSystemGlobalArea（SGA）

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;

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.

TheAutomaticSharedMemoryManagementfeatureisenabledforthePRODdatabase.Currently，alotofinsertactivityistakingplaceinthedatabase，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

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

A. The client and server have different NLS_LANGUAGE settings.

B. The client and server character sets are not the same, and the database character set is not a strict superset of the client character set.

C. The client and server are in different time zones.

D. The client requests automatic data conversion.

E. The AUTO_CONVERT initialization parameter is set to TRUE.