WHEN DOING A BULK INSERT OPERATION YOU RECEIVE AN ERROR STATING THA...

5. When doing a BULK INSERT operation you receive an error stating that the

transaction log for the database is full. What can you do to make the BULK

INSERT succeed (Select all that apply)?

A. Set the database’s recovery model to BULK_LOGGED

B. Run the BULK INSERT with the TABLOCK option

C. Set the database’s recovery model to FULL

D. Use BCP instead of BULK INSERT