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

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

4. Beyond ordinary INSERT permission on the target table, what else does a login need to run the bulk insert statement?
Please select the best answer.
  A. Membership in the bulkadmin fixed server role, or the ADMINISTER BULK OPERATIONS permission
  B. Membership in the db_owner fixed database role
  C. The CONTROL SERVER permission
  D. No additional permission is required

5. Which of the following statements about the bcp utility are true?
Please select all the correct answers.
  A. bcp is a command-line utility run outside of SQL Server, not a T-SQL statement
  B. bcp can only export data out of SQL Server; it cannot import data into a table
  C. bcp can generate a format file describing how a table's columns map to a data file
  D. bcp requires a graphical tool such as SSMS to run