Question 71 : ___________ does not allow bulk export operation in SQL Server.
1. INSERT … SELECT
2. DELETE
3. UPDATE
4. None of the mentioned
View Answer   Discuss with Members

Question 72 : Which of the following utility supports bulk exports and bulk imports data and generates format files ?
1. icp utility
2. bcp utility
3. dcp utility
4. all of the mentioned
View Answer   Discuss with Members

Question 73 : Which of the following is a bulk import operation ?
1. BULK INSERT
2. INSERT..SELECT
3. bcp
4. All of the mentioned
View Answer   Discuss with Members

Question 74 : Under the _______ recovery model, all bulk operations are fully logged
1. Simple
2. Partial
3. Full
4. All of the mentioned
View Answer   Discuss with Members

Question 75 : Point out the correct statement :
1. Bulk Copy is mainly used to transfer the data from outside world to SQL Server
2. Bulk Insert is mainly used to transfer the data from outside world to SQL Server
3. Bulk Import is mainly to transfer the data from outside world to SYBASE
4. None of the mentioned
View Answer   Discuss with Members

Question 76 : Which of the following operation cannot be performed in bulk ?
1. Copy
2. Insert
3. Import
4. All of the mentioned
View Answer   Discuss with Members