MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 8 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
_________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 |
| Answer» E. | |
| 2. |
Which_is_default_field_terminator_for_bulk_insert_in_SQL_Server_?$ |
| A. | Comma |
| B. | Full stop |
| C. | Parenthesis |
| D. | Brackets |
| Answer» B. Full stop | |
| 3. |
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 |
| Answer» C. Constraint checking of NULL constraints | |
| 4. |
___________ does not allow bulk export operation in SQL Server. |
| A. | INSERT … SELECT |
| B. | DELETE |
| C. | UPDATE |
| D. | None of the mentioned |
| Answer» B. DELETE | |
| 5. |
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 |
| Answer» C. dcp utility | |
| 6. |
Which of the following is a bulk import operation ? |
| A. | BULK INSERT |
| B. | INSERT..SELECT |
| C. | bcp |
| D. | All of the mentioned |
| Answer» E. | |
| 7. |
Under the _______ recovery model, all bulk operations are fully logged |
| A. | Simple |
| B. | Partial |
| C. | Full |
| D. | All of the mentioned |
| Answer» D. All of the mentioned | |
| 8. |
Which of the following operation cannot be performed in bulk ? |
| A. | Copy |
| B. | Insert |
| C. | Import |
| D. | All of the mentioned |
| Answer» E. | |