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.
第1题:
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?()
第2题:
As a database administrator you spend a lot of time observing and setting various storage parameter values for your application tables in order to gain performance benefits. Which task would you perform to reduce this overhead?()
第3题:
A. Flash recovery area must be defined
B. Undo retention guarantee must be enabled.
C. Database must be running in archivelog mode.
D. Automatic undo management must be enabled.
E. The tablespace in which the Flashback Data Archive is created must have automatic segment space Management (ASSM).
第4题:
When setting up the Flashback Data Archive, which of these key parameters are required?()
第5题:
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?()
第6题:
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?()
第7题:
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?()
第8题:
While setting up the threshold 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?()
第9题:
Examine the commands executed in a DBA session:SQL> CREATE BIGFILE TABLESPACE MRKT 2 DATAFILE ’/u01/app/oracle/oradata/orcl/mrkt.dbf’ size 10M LOGGING 3 EXTENT MANAGEMENT LOCALSEGMENT SPACE MANAGEMENT AUTO; Tablespace created. SQL> ALTER DATABASE DEFAULT TABLESPACE MRKT; Database altered. Which two statements are trueregarding the MRKT tablespace()
第10题:
While setting up the database for your production environment, you want to create a user with following requirements. 1.The objects created by the user must be stored in a tablespace, TBS1, if the TABLESPACE option is not defined during the object creation. 2.The user should be able to use 10MB of space in the tablespace TBS1. 3.The user must change the password immediately after logging in for the first time. Which three options of the CREATE USER command would you use to achieve this objective?()