The setting is to put the drive to sleep, if possible - not cutting the power to the drive.
Querying the drive would usually power it on, I think, if it is sleeping.
Why would you want to know if the drive is actually off? You can always eject the drive, and turn off the power.
Shutting the mini off will probably power down the external drive completely, if the drive supports that action.