To control the execution of a server process when it is receiving bad packets from a potentially malicious client, you set the SEC_PROTOCOL_ERROR_FURTHER_ACTION initialization parameter as follows: SQL> ALTER SYSTEM SET SEC_PROTOCOL_ERROR_FURTHER_ACTION

第1题：

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

第2题：

You plan to use Windows PowerShell scripts to configure system settings when you deploy Windows 7.   You need to ensure that Windows PowerShell scripts will run on the client computers during initial setup.   What should you do？（）

• A、Set the script execution policy to RemoteSigned.
• B、Set the script execution policy to AllSigned.
• C、Set the script execution policy to Restricted.
• D、Use Group Policy preferences.

第3题：

A new report process containing a complex query is written, with high impact on the database. You wantto collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests. For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and theCONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING. What should you do to accomplish this task?（）

• A、Execute the query and view Active Session History (ASH) for information about the query.
• B、Enable SQL trace for the query.
• C、Create a database operation, execute the query, and use the DBMS_SQL_MONITOR. REPORT_SQL_MONITOR function to view the report.
• D、Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.

第4题：

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.

第5题：

You want to enable resumable space allocation at the instance level.Which two actions would enable resumable space allocation at the instance level? （）(Choose two.)

• A、issuing the ALTER SYSTEM ENABLE RESUMABLE; statement
• B、issuing the ALTER SESSION ENABLE RESUMABLE; statement
• C、modifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero value
• D、issuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=; statement

第6题：

Automatic Shared Memory Management (ASMM) has been enabled for your database instance. The initialization parameters for the components that are managed by ASMM are not set. After observing the effectsof ASMM, you executed the following command: SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M; Which statement is true in this scenario（　）

• A、The minimum memory size for the database buffer cache is set to 100 mb.
• B、The maximum memory size that can be obtained by the database buffer cache during ASMM is set to 100mb
• C、The minimum memory size allocated for a server process in the database buffer cache in dedicated modeis set to 100 mb.
• D、The maximum memory size from the database buffer cache that can be released for dynamic distributionduring ASMM is set to 100 mb

第7题：

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

第8题：

You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing. What information is captured as part of this process?（）

• A、the SQL text SQL
• B、the execution plan
• C、the execution context
• D、the execution frequency
• E、the system change number (SCN)

第9题：

第10题：

第11题：

第12题：

第13题：

You have specified the warning and critical threshold values of an application tablespace to be 60% and 70% respectively. From the tablespace space usage metrics， you find that the actual space usage has reached the specified warning threshold value， but no alerts have been generated. What could be the reason for this？（）

• A、 The EVENT parameter was not set
• B、 The SQL_TRACE parameter is set to FALSE
• C、 The Enterprise Manager Grid Control is not used
• D、 The STATISTICS_LEVEL parameter is set to BASIC
• E、 The TIMED_STATISTICS parameter is set to FALSE

第14题：

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.

第15题：

You have specified the warning and critical threshold values of an application tablespace to be 60% and 70%， respectively. From the tablespace space usage metrics， you find that the actual space usage has reached the specified warning threshold value， but no alerts have been generated. What could be the reason for this？（）

• A、The EVENT parameter was not set.
• B、The SQL_TRACE parameter is set to FALSE
• C、The Enterprise Manager Grid Control is not used.
• D、The STATISTICS_LEVEL parameter is set to BASIC
• E、The TIMED_STATISTICS parameter is set to FALSE

第16题：

You want to enable resumable space allocation at the instance level. Which two actions would enable resumable space allocation at the instance level？（） 

• A、 issuing the ALTER SYSTEM ENABLE RESUMABLE；statement
• B、 issuing the ALTER SESSION ENABLE RESUMABLE；statement
• C、 modifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero value
• D、 issuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=；statement

第17题：

You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA.  While observing the server settings， you find that the following parameter has been set in the parameter file of the database：  REMOTE_OS_AUTHENT = TRUE  What could have been the reason to set this parameter as TRUE？（）

• A、to enable operating system authentication for a remote client
• B、to restrict the scope of administration to identical operating systems
• C、to allow the start up and shut down of the database from a remote client
• D、to enable the administration of the operating system from a remote client
• E、to disable the administration of the operating system from a remote client

第18题：

You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing.  What information is captured as part of this process？（）

• A、 the SQL text
• B、 the execution plan
• C、 the execution context
• D、 the execution frequency
• E、 the system change number （SCN）

第19题：

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.

第20题：

第21题：

第22题：

第23题：

第24题：