IBM
C2090-600 · Question #47
Which of the following SQL statements will list table spaces whose utilization is greater than 95% and may potentially fill, returning an error?
The correct answer is C. SELECT tbsp_name, tbsp_utilization_percent. See the full explanation below for the reasoning.
Question
Which of the following SQL statements will list table spaces whose utilization is greater than 95% and may potentially fill, returning an error?
Options
- ASELECT tbsp_name, tbsp_utilization_percent
- BSELECT tbsp_name, tbsp_utilization_percent
- CSELECT tbsp_name, tbsp_utilization_percent
- DSELECT tbsp_name, tbsp_utilization_percent
How the community answered
(22 responses)- A5% (1)
- B9% (2)
- C77% (17)
- D9% (2)
Community Discussion
No community discussion yet for this question.