You create a locally managed tablespace by using the following SQL statement:
CREATE TABLESPACE hr_tbs
DATAFILE ‘data.dat’ SIZE 1M REUSE
AUTOEXTEND ON MAXSIZE 100M;
The warning and critical tablespace usage threshold values are set to 85% and 97%, respectively. Which two statements regarding the threshold-based alerts generation for the HR_TBS tablespace are correct? (Choose two.)
A.
A critical alert will be generated when 97 MB space is used.
B.
A critical alert will be generated when 970 KB space is used.
C.
A warning alert will be generated when 85 MB space is used.
D.
A warning alert will be generated when 850 KB space is used.
E.
A critical alert will be generated when 970 KB is left as free space.
F.
A warning alert will be generated when 850 KB is left as free space.
G.
No critical alert will be generated because it is a small file tablespace.
H.
No warning alert will be generated because the tablespace is autoextensible.
Explanation:
By default a server-generated alert is generated for tablespace space usage when the percentage of space usage exceeds either the 85% warning or 97% critical threshold level. MAXSIZE 100M , then 97 MB and 85MB, are the correct answers.
REF.: Oracle(r) 10g Administrator Guide , 4-19