PrepAway - Latest Free Exam Questions & Answers

Which of the following SQL statements will list table s…

Which of the following SQL statements will list table spaces whose utilization is greater than 95% and may
potentially fill, returning an error?

PrepAway - Latest Free Exam Questions & Answers

A.
SELECT tbsp_name, tbsp_utilization_percent
FROM TABLE(sysproc.mon_tbsp_utilization()) AS t
WHERE tbsp_utilization_percent > 95
AND tbsp_auto_resize_enabled = 1;

B.
SELECT tbsp_name, tbsp_utilization_percent
FROM syscat.mon_tbsp_utilization
WHERE tbsp_utilization_percent > 95
AND tbsp_auto_resize_enabled = 0;

C.
SELECT tbsp_name, tbsp_utilization_percent
FROM syscat.mon_tbsp_utilization
WHERE tbsp_utilization_percent > 95
AND tbsp_auto_resize_enabled = 1;

D.
SELECT tbsp_name, tbsp_utilization_percent
FROM sysibmadm.mon_tbsp_utilization
WHERE tbsp_utilization_percent > 95
AND tbsp_auto_resize_enabled = 0;


Leave a Reply