IBM Exam Questions

Which select statement will give the count of the scratch volumes available within the IBM Tivoli St

Which select statement will give the count of the scratch volumes available within the IBM Tivoli Storage Manager?

A.
SELECT SUM(*) FROM volumes WHERE status=’scratch’

B.
SELECT COUNT(*) FROM volumes WHERE status=’scratch’

C.
SELECT SUM(*) FROM libvolumes WHERE status=’Scratch’

D.
SELECT COUNT(*) FROM libvolumes WHERE status=’Scratch’

Explanation: