下列说法中，违背办事公道原则的是：（)。A．按照客户到来的先后次序为他们提供服务B．根据客户需求提

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.

A.Bob has max_user_connections set to zero, which blocks all his connections

B.Joe has exceeded the max_user_connections global limit

C.All users are blocked because max_user_connections is accumulated over the host account information

D.Kay is already connected elsewhere and attempting to log in again

E.Connect_timeout is too small to allow a connection to occur

InyourSupportcenter.cnproductiondatabase，youfindthatthedatabaseusersareabletocreateandreadfileswithunstructureddata，availableinanylocationonthehostmachinefromanapplication.Youwanttorestrictthedatabaseuserstoaccessfilesinaspecificlocationonthehostmachine.Whatcoulddotoachievethis？（）

A.ModifythevaluefortheUTL_FILE_DIRparameterintheparameterfile

B.Grantreadandwriteprivilegeontheoperatingsystempathtothedatabaseusers

C.ModifythevaluefortheLDAP_DIRECTORY_ACCESSparameterintheparameterfile

D.ModifythevalueforthePLSQL_NATIVE_LIBRARY_DIRparameterintheparameterfile

E.Createadirectoryobjectreferringtotheoperatingsystempath，andgrantreadandwriteprivilegeonthedirectoryobjecttothedatabaseusers

YouareworkingonaninstancestartedusingtheSPFILE.YouwanttomovetheFlashRecoveryAreaofyourdatabasetoanewlocation.YouwanttheFlashbacklogfilestobestoredinthenewlocation.Givenbeloware

thestepstoaccomplishthetaskinrandomorder：

1.Shutdowntheinstance.

2.ChangethevalueoftheDB_RECOVERY_FILE_DESTinitializationparametertoanewvalue.

3.ExecutetheALTERDATABASEFLASHBACKOFFcommand.

4.Startuptheinstanceandmountthedatabase.

5.ExecutetheALTERDATABASEFLASHBACKONcommand.

6.Openthedatabase.

Selectthecorrectorderinwhichthesetasksneedtobeperformed.（）

A.Donothing.

B.Restartthedatabase.

C.Performrecoveryonthedatabase.

D.Restorethealertlogfromthelastbackup.

A. VARCHAR2

B. CHAR

C. NVARCHAR2

D. CLOB

E. LONG