Multiple choice technology databases

Tools for importing and exporting data in sql server

  1. BULK insert

  2. BCP

  3. DTS

  4. All the above

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

SQL Server provides multiple tools for data import and export: BULK INSERT is a T-SQL command for bulk data loading, BCP (Bulk Copy Program) is a command-line utility, and DTS (Data Transformation Services) is a graphical tool for data transfer and transformation. All three are valid options.