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

[单选题]

YouaremaintainingthePRODdatabaseofNetFxCorporation.YousetthevalueoftheSQL_TRACEparametertoTRUE.Whatwillbetheimpactofthissetting？（）

A.TheSQLtracefacilitywillgeneratetheperformancestatisticsforalltheSQLstatementsforaninstanceandwritethemintheUSER_DUMP_DESTdirectory.

B.TheSQLtracefacilitywillgeneratetheperformancestatisticsforalltheSQLstatementsforasessionandwritethemintheUSER_DUMP_DESTdirectory.

C.TheSQLtracefacilitywillgeneratetheperformancestatisticsforalltheSQLstatementsforaninstanceandwritethemintheBACKGROUND_DUMP_DESTdirectory.

D.TheSQLtracefacilitywillgeneratetheperformancestatisticsforalltheSQLstatementsforasessionandwritethemintheBACKGROUND_DUMP_DESTdirectory.

查看答案

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

您可能会需要：

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

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

更多“YouaremaintainingthePRODdataba…”相关的问题

第1题

In a database with the database character set of US7ASCII and a national character set of UTF-8, which datatypes would be capable of storing Unicode data by default?（）

A. VARCHAR2

B. CHAR

C. NVARCHAR2

D. CLOB

E. LONG

点击查看答案

第2题

AjuniorlevelDatabaseAdministratorerroneouslydeletedthedatabasealertlogwhileuserswereaccessingthedatabase.Whichactionshouldyoutaketorecoverthealertlog？（）

A.Donothing.

B.Restartthedatabase.

C.Performrecoveryonthedatabase.

D.Restorethealertlogfromthelastbackup.

点击查看答案

第3题

Youareworkingonaninstancestartedusing&81

YouareworkingonaninstancestartedusingtheSPFILE.YouwanttomovetheFlashRecoveryAreaofyourdatabasetoanewlocation.YouwanttheFlashbacklogfilestobestoredinthenewlocation.Givenbeloware

thestepstoaccomplishthetaskinrandomorder：

1.Shutdowntheinstance.

2.ChangethevalueoftheDB_RECOVERY_FILE_DESTinitializationparametertoanewvalue.

3.ExecutetheALTERDATABASEFLASHBACKOFFcommand.

4.Startuptheinstanceandmountthedatabase.

5.ExecutetheALTERDATABASEFLASHBACKONcommand.

6.Openthedatabase.

Selectthecorrectorderinwhichthesetasksneedtobeperformed.（）

点击查看答案

第4题

InyourSupportcenter.cnproductiondatabase，youfindthatthedatabaseusersareabletocreateandread

fileswithunstructureddata，availableinanylocationonthehostmachinefromanapplication.Youwanttorestrictthedatabaseuserstoaccessfilesinaspecificlocationonthehostmachine.Whatcoulddotoachievethis？（）

A.ModifythevaluefortheUTL_FILE_DIRparameterintheparameterfile

B.Grantreadandwriteprivilegeontheoperatingsystempathtothedatabaseusers

C.ModifythevaluefortheLDAP_DIRECTORY_ACCESSparameterintheparameterfile

D.ModifythevalueforthePLSQL_NATIVE_LIBRARY_DIRparameterintheparameterfile

E.Createadirectoryobjectreferringtotheoperatingsystempath，andgrantreadandwriteprivilegeonthedirectoryobjecttothedatabaseusers

点击查看答案

第5题

An employee cannot access the company database. You check the connection variables:What is a valid explanation for why one of the users is unable to connect to the database?（）

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

点击查看答案

第6题

Automatic data conversion will occur if which of the following happens?（）

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.

点击查看答案

第7题

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

点击查看答案

第8题

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

点击查看答案

第9题

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.

点击查看答案

第10题

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;

点击查看答案