You are maintaining your OLTP database in Oracle10g. You have not set the warning level and critical level threshold values for space usage of the DATA1 tablespace. What will be the impact？（）A、 No warning level or critical level alert will be generated.B、

第1题：

The warning and critical threshold values have been set to 85% and 97%， respectively， for one of the tablespaces. The current tablespace space usage is 54%. You modify the warning threshold to be 50 % and critical threshold to be 53% in Database Control. Which statement is true？（）

• A、 The new setting would be applied but no alerts would be raised immediately.
• B、 The new setting would be applied and an alert would be raised immediately.
• C、 The new setting would be ignored because the tablespace space usage is more than the specified threshold value.
• D、 The new setting would cause an error because the tablespace space usage is more than the specified threshold value.

第2题：

You want to be notified when the space usage of an existing critical tablespace has reached 75% of the allocated space. Which option would you use to achieve this？（）

• A、run a procedure to check the tablespace space usage
• B、define the warning threshold for the tablespace at 75% in Database Control
• C、create a trigger to be executed when tablespace space usage reaches 75%
• D、submit a job by using DBMS_JOB package to check the free space in the tablespace at regular intervals
• E、define the warning threshold to be 75% for the tablespace by ALTER TABLESPACE .. ADD THRESHOLD command

第3题：

You have created a locally managed tablespace by issuing the following command：        CREATE TABLESPACE data1   DATAFILE ’data1_file1.dbf’ SIZE 10M AUTOEXTEND ON MAXSIZE        UNLIMITED；   For the DATA1 tablespace， you have set the warning level alert limit to 70 percent.  In which situation will a warning level alert be generated？（）  

• A、 when 700 KB is used
• B、 when 700 KB is left as free space
• C、 when 7MB is used
• D、 when 7MB is left as free space
• E、 no alert will be generated because an autoextensible datafile is included in the tablespace

第4题：

You issued the following statement：   SQL>ALTER DATABASE ENABLE RESUMABLE TIMEOUT n；   What will be the result of issuing the above statement？（）

• A、The command will not execute successfully because TIMEOUT is an invalid clause with the ALTER DATABASE ENABLE RESUMABLE command.
• B、 The command will not execute successfully because resumable space allocation is enabled at the session level.
• C、 The command will execute successfully and resumable space will be allocated at the session level.
• D、 The command will execute successfully and resumable space will be allocated at the instance level.

第5题：

You want to monitor and control the resource usage by sessions. You want to be warned automatically when more than 100 sessions are opened with your database. What action would you take to achieve this？（）

• A、Use the Database Resource Manager.
• B、Set the limits in the profiles used by users.
• C、Modify the SESSIONS initialization parameter.
• D、Set the warning threshold for the Current Logons Count metric.

第6题：

You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows： Warning （%）： 90  Critical （%）： 95  Which background process is responsible for issuing alerts when the threshold is crossed（）

• A、System monitor （SMON）
• B、Process monitor （PMON）
• C、Memory manager process （MMAN）
• D、Manageability Monitor process （MMON）

第7题：

Users are performing a large volume of inserts and deletes on the application tables in the APPS tablespace. You observe that there are several warning alerts being generated for the APPS tablespace space usage metrics. Currently， the warning threshold for the tablespace usage metrics is set to 70%. To make the generated alerts more useful as a problem identification tool， you want to reduce the frequency of alert generation for the tablespace usage metrics for the APPS tablespace. What should you do？（）

• A、 Disable SQL tracing for the APPS tablespace.
• B、 Disable logging attributes for the APPS tablespace.
• C、 Modify the tablespace to be a dictionary-managed tablespace.
• D、 Increase the critical threshold value for the tablespace space usage metrics for the APPS tablespace.
• E、 Increase the warning threshold value for the tablespace space usage metric for the APPS tablespace.

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You have a range-partitioned table in your database. Each partition in the table contains the sales data for a quarter.  The partition related to the current quarter is modified frequently and other partitions undergo fewer data manipulations. The preferences for the table are set to their default values. You collect statistics for the table using the following command in regular intervals： SQL> EXECUTE  DBMS_STATS.GATHER_TABLE_STATS（’SH’，’SALES’，GRANULARITY=>’GLOBAL’）；   You need statistics to be collected more quickly.  What can you do to achieve this？（）

• A、 Set DYNAMIC_SAMPLING to level 4
• B、 Set the STATISTICS_LEVEL parameter to BASIC
• C、 Set the INCREMENTAL value to TRUE for the partition table
• D、 Increase the value of STALE_PERCENT for the partition table

第14题：

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

第15题：

While setting up the thresholds for tablespace space usage metrics for one of your tablespaces， you define the critical threshold as 60% and warning threshold as 75%. What would be the result of this setting？（）

• A、It would result in an error because the warning threshold cannot be more than the critical threshold.
• B、The warning threshold is ignored and alerts would be generated when space usage exceeds the critical threshold.
• C、The critical threshold is ignored and alerts would be generated when space usage exceeds the warning threshold.
• D、Both threshold values are used and alerts are generated when space usage exceeds the respective threshold values.

第16题：

You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows：Warning （%）： 90Critical （%）： 95 Which background process is responsible for issuing alerts when the threshold is crossed（）

• A、System monitor （SMON）
• B、Process monitor （PMON）
• C、Memory manager process （MMAN）
• D、Manageability Monitor process （MMON）

第17题：

The warning level threshold value for a tablespace， DATA1， is set to 60% and the critical level threshold value is set to 80%. The tablespace， DATA1， is infrequently used and is not a part of the production environment. You issued the following command：        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’）；   What will be the result of the command？（）  

• A、 The command will be executed successfully only if the tablespace DATA1 is a dictionary-managed tablespace.
• B、 The total numbers of alerts that you receive every day will be reduced.
• C、 The total number of alerts that you receive every day will be increased.
• D、 No more data will be added to the DATA1 tablespace if 80% of the space allocated to the DATA1 tablespace is used.

第18题：

You need to resolve the blocking issue that is affecting the performance of the CRM system. What should you do?（）

• A、Replace the named query with an SQL view.
• B、Set the transaction isolation level to serializable in the named query.
• C、Set the source database to use snapshot isolation.
• D、Set the transaction isolation level to repeatable read in the named query.

第19题：

第20题：

第21题：

第22题：

第23题：