Multiple choice technology databases

Extended Stored Procedure master.dbo.xp_fileexist can be used to decide if a file exists.

  1. True

  2. False

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

The extended stored procedure xp_fileexist checks whether a specified file exists on the server's file system and returns output parameters indicating file existence. It returns 1 in the 'File Exists' parameter if the file is found. Note: Extended stored procedures are deprecated in modern SQL Server versions in favor of FILESTREAM and other methods.