Which two statements regarding the threshold-based alerts generation for the HR_TBS tablespace are correct? (Choose two.)

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.)

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



Leave a Reply 0

Your email address will not be published. Required fields are marked *