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

You created a locally managed tablespace by using the following SQL statement:
CREATE TABLESPACE hr_tbs
DATAFILE ‘dat
a.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 created a locally managed tablespace by using the following SQL statement:
CREATE TABLESPACE hr_tbs
DATAFILE ‘dat
a.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 warning alert will be generated when 850 KB space is used.

C.
A critical alert will be generated when 970 KB is left as free space.

D.
A warning alert will be generated when 85 MB space is used.

E.
A critical alert will be generated when 970 KB space is used.

F.
No warning alert will be generated because thetablespace is autoextensible.

G.
No critical alert will be generated because it is a small filetablespace.

H.
A warning alert will be generated when 850 KB is left as free space.



Leave a Reply 0

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