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
Bạn đang xem 5. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P82 PPSX