Importing/Exporting Data  «Prev  Next»

Loading data with SQL Statements - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. If you want to load multiple rows from a file into an existing table which SQL statement, should you use?
Please select the best answer.
  A. insert
  B. select into
  C. bulk insert
  D. load table

2. If you want to use the bulk insert statement to only load some of the fields from a file into a table, which of the following is true?
Please select the best answer.
  A. You can not use bulk insert to skip columns.
  B. You must use the SKIPCOLUMN option to skip columns.
  C. You must use the SKIPFIELD option to skip columns.
  D. You must use a format file.

3. Which of the following SQL statements can be used to load multiple rows into an existing table?
Please select all the correct answers.
  A. Select into
  B. insert
  C. Copy table
  D. bulk insert