This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Bulk Operations”.
1. Which of the following operation cannot be performed in bulk?
a) Copy
b) Insert
c) Import
d) All of the mentioned
View Answer
Explanation: SQL Server supports bulk exporting data from a SQL Server table and for bulk importing data into a SQL Server table or non partitioned view.
2. Point out the correct statement.
a) Bulk Copy is mainly used to transfer the data from outside world to SQL Server
b) Bulk Insert is mainly used to transfer the data from outside world to SQL Server
c) Bulk Import is mainly to transfer the data from outside world to SYBASE
d) None of the mentioned
View Answer
Explanation: The bulk insert command can be used within T-SQL script or in a stored procedure to import data into SQL Server.
3. Under the _______ recovery model, all bulk operations are fully logged.
a) Simple
b) Partial
c) Full
d) All of the mentioned
View Answer
Explanation: You can minimize logging for a set of bulk operations by switching the database to the bulk-logged recovery model temporarily for bulk operations.
4. Which of the following is a bulk import operation?
a) BULK INSERT
b) INSERT..SELECT
c) bcp
d) All of the mentioned
View Answer
Explanation: SQL Server bulk-import operations do not support importing data from comma-separated value (CSV) files.
5. 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
View Answer
Explanation: In Bulk-logged recovery model, all most all the transaction are completely logged except Bulk operation.
6. Which of the following utility supports bulk exports and bulk imports data and generates format files?
a) icp utility
b) bcp utility
c) dcp utility
d) all of the mentioned
View Answer
Explanation: bcp is a command line utility for bulk import and export.
7. ___________ does not allow bulk export operation in SQL Server.
a) INSERT … SELECT
b) DELETE
c) UPDATE
d) None of the mentioned
View Answer
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.
8. Which of the following performance considerations are regarding bulk operations?
a) Column locking
b) Batch switches
c) Constraint checking of NULL constraints
d) All of the mentioned
View Answer
Explanation: Performance considerations can also be significant when large amounts of data are being imported.
9. ________ parameter specifies the number of rows in a batch in bulk insert script.
a) KEEPNULLS
b) KEEPIDENTITY
c) FIRE_TRIGGERS
d) None of the mentioned
View Answer
Explanation: BATCHSIZE =batch_size specifies the number of rows in a batch. Each batch is copied to the server as one transaction.
10. Which is the default field terminator for bulk insert in SQL Server?
a) Comma
b) Full stop
c) Parenthesis
d) Brackets
View Answer
Explanation: Field Terminator is used to delimit columns in the source file. There are some cases where I have seen “|” also. “,” can be part of Name. So in that case the bulk insert may fail.
Sanfoundry Global Education & Learning Series – SQL Server.
To practice all areas of SQL Server, here is complete set of 1000+ Multiple Choice Questions and Answers.
If you find a mistake in question / option / answer, kindly take a screenshot and email to [email protected]
- Check Information Technology Books
- Apply for Programming Internship
- Check SQL Server Books
- Practice Programming MCQs
