___________ does not allow bulk export operation in SQL Server.

does-not-allow-bulk-export-operation-in-sql-server

___________ does not allow bulk export operation  in SQL Server.

A. INSERT … SELECT

B. DELETE

C. UPDATE

D. None of the mentioned

The question was asked at a job interview.

This interesting question is from Bulk Operations in chapter Data Connectivity of SQL Server

The correct option is A. INSERT … SELECT

Best explanation: INSERT … SELECT is a Transact-SQL statement that uses the OPENROWSET bulk rowset provider to bulk import data into a SQL Server table by specifying the OPENROWSET(BULK…) function to select data in an INSERT statement.