单选题You are specifying French case-insensitive sorts by using the NSL_SORT parameter for the user session of the user， Scott. Which value will you set for the NLS_SORT parameter？（）AFRENCH_AIBFRENCH_CICAI_FRENCHDCI_FRENCH

第1题：

For the V$SESSION_LONGOPS view， you find that some of the database users have long-running queries that consume a lot of CPU time. This causes performance problems for other users in the database， who have much shorter queries. You would like to make sure that the users with large queries do not use all the CPU time， but you still do not want to terminate them with an error message. Which method would you follow to achieve this？（）

• A、 Set the CPU time per call in the users profile.
• B、 Set the CPU time per session in the users profile.
• C、 Set the CPU levels for the user’s group using Resource Manager.
• D、 Set the TIMED_STATISTICS parameter to TRUE in the parameter file.

第2题：

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

第3题：

From the V$SESSION_LONGOPS view， you find that some of the database users have long-running queries and are consuming a lot of CPU time. This causes problems for you when you try to log on as the system user and perform small maintenance tasks. You would like to ensure that users SYS and SYSTEM get priority over all other users.   Which method would you use to achieve this objective？（）

• A、create a plan directive in the SYS_GROUP
• B、create the pending area for the consumer group
• C、activate the provided SYSTEM_PLAN in Resource Manager
• D、set the TIMED_STATISTICS parameter to TRUE in the parameter file
• E、set the execution time limit for all users， except SYS and SYSTEM， in their profiles

第4题：

An administrator account is granted the CREATE SESSION and SET CONTAINER system privileges. A multitenant container database (CDB) instant has the following parameter set: THREADED_EXECUTION = FALSE Which four statements are true about this administrator establishing connections to root in a CDB that has been opened in read only mode?（）

• A、You can conned as a common user by using the connect statement.
• B、You can connect as a local user by using the connect statement.
• C、You can connect by using easy connect.
• D、You can connect by using OS authentication.
• E、You can connect by using a Net Service name.
• F、You can connect as a local user by using the SET CONTAINER statement.

第5题：

The database users are connecting to the PROD database from different applications， thereby degrading the database performance. The senior database administrator suspects the large number of concurrent connections to be the reason for low performance and asks you to restrict the number concurrent connections per database user to one. Which action would you take to achieve this objective？ （）

• A、set the SESSIONS to 1 in the parameter file
• B、grant SINGLE SESSION privilege to all of the users
• C、set the SESSIONS_PER_USER to 1 in the users’ profile
• D、grant RESTRICTED SESSION privilege to all of the database users
• E、create a role with SINGLE SESSION privilege and assign the role to the users

第6题：

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You are maintaining an OLTP database in Oracle10g. You find that the database is generating a large number of trace files. You decide to disable the trace files generated by the ARCn background process.  Which action will enable you to disable the trace files generated by the ARCn background process？（）  

• A、 Remove the LOG_ARCHIVE_DEST parameter from the init.ora file.
• B、 Set the value of the SQL_TRACE parameter to FALSE in the init.ora file.
• C、 Use the DBMS_MONITOR.SESSION_TRACE_DISABLE procedure.
• D、 Set the value of the LOG_ARCHIVE_TRACE initialization parameter to zero.

第14题：

You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?（）

• A、Set MEMORY_TARGET to zero
• B、Set the STATISTICS_LEVEL parameter to BASIC
• C、Set the WORKAREA_SIZE_POLICY parameter to MANUAL
• D、Set the PGA_AGGREGATE_TARGET parameter to nonzero value

第15题：

A user complains that he gets the following error message repeatedly after executing some SQL statements.The error message forces the user to log off from and log onto the database to continue his work.  ORA-02392：exceeded session limit on CPU usage，you are being logged off Which action would you take to increase the session limit on CPU usage？（）

• A、Modify the profile assigned to the user.
• B、Modify the roles assigned to the users.
• C、Modify the object privileges assigned to the user.
• D、Modify the system privileges assigned to the users.
• E、Modify the value for the RESOURCE_LIMIT parameter in the parameter file.

第16题：

Your database is started by using the server parameter file （SPFILE）. You issued this command to change the value of the LOG_BUFFER initialization parameter：  ALTER SYSTEM SET LOG_BUFFER=24M SCOPE=BOTH；  What would be the outcome of this command？ （）

• A、The command would return an error because LOG_BUFFER is a static parameter.
• B、The parameter value would be changed and it would come into effect immediately.
• C、You need to restart the database so that parameter changes can come into effect.
• D、The command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.

第17题：

In your test database， you find that a user’s session is executing a lot of SQL statements， resulting in the generation of a large number of trace files. While investigating the reason， you find that SQL trace has been enabled at the instance level. You want to disable SQL trace， remotely， only for that user session to reduce the volume of trace data being generated.How do you achieve this objective？（）

• A、 by setting the SQL_TRACE parameter to FALSE in the parameter file
• B、 by using DBMS_MONITOR.SESSION_TRACE_DISABLE to disable the tracing for the user session
• C、 by setting the SQL_TRACE parameter to FALSE by using the ALTER SYSTEM command in the user session
• D、 by setting the SQL_TRACE parameter to FALSE by using the ALTER SESSION command in the user session

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：