Multiple choice technology programming languages

Which of the following is true about xp command shell in SQL Server 2005:

  1. xp command shell can be enabled by sysadmin by executing following: EXEC sp_configure 'xp_cmdshell', 0;

  2. xp command shell is enabled by default;

  3. xp command shell can be used to run bcp utility

  4. None of above
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

xp_cmdshell is an extended stored procedure that executes operating system commands from SQL Server, so it can invoke any command-line utility including bcp (Bulk Copy Program). For security, xp_cmdshell is disabled by default and must be explicitly enabled with sp_configure, setting the value to 1 (not 0, which disables it).

Keep practicing — related questions