Multiple choice technology databases

For a Sybase IQ running in UNIX, which Sybase IQ stored procedure can be used to execute the UNIX shell commands?

  1. sp_exec_os_cmd

  2. xp_cmdshell

  3. xp_ksh

  4. sp_cmdshell
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

xp_cmdshell is an extended stored procedure in Sybase that executes operating system commands. The 'xp' prefix indicates it's an extended procedure, not a regular stored procedure (sp_prefix). sp_exec_os_cmd and sp_cmdshell are not valid Sybase procedures, and xp_ksh is fictional.

Keep practicing — related questions