Multiple choice technology web technology

Which stored procedure can be useful in giving information about devices

  1. sp_help

  2. sp_helpdevice

  3. sp_helpsegment

  4. sp_helpdbdev

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

sp_helpdevice is the system stored procedure that provides detailed information about database devices in Sybase ASE. It shows device names, sizes, status, and usage information, unlike sp_help which covers general object information.