DBMS_STATS
DBMS_ALERT
DBMS_SPACE
DBMS_MONITOR
DBMS_SERVER_ALERT
DBMS_SPACE_ADMIN
第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?()
第2题:
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?()
第3题:
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?()
第4题:
While creating a database using Database Configuration Assistant tool, you created a database default temporary tablespace. Which activity would cause the default temporary tablespace of the database to be used?()
第5题:
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?()
第6题:
The new setting would be applied but no alerts would be raised immediately.
The new setting would be applied and an alert would be raised immediately.
The new setting would be ignored because the tablespace space usage is more than the specified threshold value.
The new setting would cause an error because the tablespace space usage is more than the specified threshold value.
第7题:
No warning level or critical level alert will be generated.
A warning level alert will never be generated, but a critical level alert will be generated when 97 percent space of the DATA1 tablespace is used.
A critical level alert will never be generated, but a warning level alert will be generated when 85 percent space of the DATA1 tablespace is used.
A warning level alert will be generated at 85 percent space usage of the DATA1 tablespace, and a critical level alert is generated at 97 percent space usage of the DATA1 tablespace.
第8题:
It would result in an error because the warning threshold cannot be more than the critical threshold.
The warning threshold is ignored and alerts would be generated when space usage exceeds the critical threshold.
The critical threshold is ignored and alerts would be generated when space usage exceeds the warning threshold.
Both threshold values are used and alerts are generated when space usage exceeds the respective threshold values.
第9题:
DBMS_STATS
DBMS_ALERT
DBMS_SPACE
DBMS_MONITOR
DBMS_SERVER_ALERT
DBMS_SPACE_ADMIN
第10题:
the CREATE TABLE .. command
sorting of the SYSTEM tablespace’s data
sorting of data required by recursive SQL statements
the CREATE TABLE .. ORGANIZATION EXTERNAL .. command
sorting of data if the users have not been allocated temporary tablespace explicitly
sorting of data if the users have been allocated temporary tablespace explicitly
第11题:
disable SQL tracing for theAPPS tablespace
disable logging attribute for the APPS tablespace
modify the tablespace to be a dictionarymanaged tablespace
increase the critical threshold value for the tablespace space usage metrics for the APPS tablespace
increase the warning threshold value for the tablespace space usage metrics for the APPS tablespace
第12题:
use automatic extent allocation
disable threshold for the tablespace
use freelists to manage the free space
use automatic segment space management
create the tablespace as a bigfile tablespace
use the RESIZE clause while creating the tablespace
enable AUTOEXTEND for at least one of the data files in the tablespace
第13题:
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?()
第14题:
The EMPLOYEES table is stored in the USERS tablespace. You need to check if the EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which option would you use?()
第15题:
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?()
第16题:
An online tablespace, TEST_TBS, is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace. What could be the reason, if the TEST_TBS tablespace does not include autoextensible data files?()
第17题:
The EVENT parameter was not set.
The SQL_TRACE parameter is set to FALSE
The Enterprise Manager Grid Control is not used.
The STATISTICS_LEVEL parameter is set to BASIC
The TIMED_STATISTICS parameter is set to FALSE
第18题:
The new setting would be applied but no alerts would be raised immediately.
The new setting would be applied and an alert would be raised immediately.
The new setting would be ignored because the tablespace space usage is more than the specified threshold value.
The new setting would cause an error because the tablespace space usage is more than the specified threshold value.
第19题:
Disable SQL tracing for the APPS tablespace.
Disable logging attributes for the APPS tablespace.
Modify the tablespace to be a dictionary-managed tablespace.
Increase the critical threshold value for the tablespace space usage metrics for the APPS tablespace.
Increase the warning threshold value for the tablespace space usage metric for the APPS tablespace.
第20题:
It would result in an error because the warning threshold cannot be more than the critical threshold.
The warning threshold is ignored and alerts would be generated when space usage exceeds the critical threshold.
The critical threshold is ignored and alerts would be generated when space usage exceeds the warning threshold.
Both threshold values are used and alerts are generated when space usage exceeds the respective threshold values.
第21题:
The EVENT parameter was not set
The SQL_TRACE parameter is set to FALSE
The Enterprise Manager Grid Control is not used
The STATISTICS_LEVEL parameter is set to BASIC
The TIMED_STATISTICS parameter is set to FALSE
第22题:
run a procedure to check the tablespace space usage
define the warning threshold for the tablespace at 75% in Database Control
create a trigger to be executed when tablespace space usage reaches 75%
submit a job by using DBMS_JOB package to check the free space in the tablespace at regular intervals
define the warning threshold to be 75% for the tablespace by ALTER TABLESPACE .. ADD THRESHOLD command
第23题:
the DBNEWID utility
the ANALYZE command
the RMAN LIST command
the RMAN REPORT command
the RMAN CROSSCHECK command
the RMAN BLOCKRECOVER command
第24题:
TEST_TBS is a small file tablespace
TEST_TBS is a bigfile tablespace (BFT)
TEST_TBS is the default temporary tablespace
TEST_TBS is a dictionary-managed tablespace
Threshold values for the TEST_TBS tablespace are not explicitly specified