Oracle认证考试
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
题目
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 = Drop,10; What is the significance of this setting?（）
- A、It terminates the client connection after 10 bad packets and the client cannot reconnect to the same instance.
- B、It terminates the client connection after 10 bad packets but the client can still reconnect, and attempt the same operation again.
- C、It terminates the client connection 10 seconds after receiving a bad packet and the client cannot reconnect to the same instance.
- D、It terminates the client connection after receiving a bad packet and the client can reconnect to the same instance after 10 minutes.
相似问题和答案
第1题：
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.
第2题：
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
正确答案:B
第3题：
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 = Drop,10;What is the significance of this setting?（）
A. It terminates the client connection after 10 bad packets and the client cannot reconnect to the same instance.
B. It terminates the client connection after 10 bad packets but the client can still reconnect, and attempt the same operation again.
C. It terminates the client connection 10 seconds after receiving a bad packet and the client cannot reconnect to the same instance.
D. It terminates the client connection after receiving a bad packet and the client can reconnect to the same instance after 10 minutes.
第4题：
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.
正确答案:C
第5题：
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.
正确答案:A
第6题：
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=<nonzero value>; statement
正确答案:C,D
第7题：
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
正确答案:D
第8题：
A. the SQL text SQL
B. the execution plan
C. the execution context
D. the execution frequency
E. the system change number (SCN)
第9题：
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.
正确答案:B
第10题：
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
正确答案:D