A customer has a 3584 library with 1000 tape volumes. All of the tape volumes are in IBM Tivoli Storage Manager library inventory with private and scratch status. Now the customer wants to know the total number of ‘Private’ volumes by SQL command. What is the correct SQL statement for an automatic count?

A.
SELECT * FROM volumes WHERE status=’Private’

B.
SELECT * FROM libvolumes WHERE status=’Private’

C.
SELECT COUNT(*) FROM volumes WHERE status=’Private’

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

Explanation: