Point out the wrong statement :
A. In Bulk-logged recovery model, few transactions are completely logged
B. The operations that are minimally logged in this recovery model are bulk insert, create index, “bcp” commands, insertion of text , image column and select into query
C. Backups under BULK_LOGGED recovery model, will include log records and the data pages changed by bulk operations
D. None of the mentioned
Answer:A
Point out the wrong statement :
A. In Bulk-logged recovery model, few transactions are completely logged B. The operations that are minimally logged in this recovery model are bulk insert, create index, “bcp” commands, insertion of text , image column and select into query C. Backups under BULK_LOGGED recovery model, will include log records and the data pages changed by bulk operations D. None of the mentioned
Explanation:In Bulk-logged recovery model, all most all the transaction are completely logged except Bulk operation.