Importing/Exporting Data  «Prev  Next»

Loading Data SQL Server - Quiz

 
Select the best answer or answers for each question.
1. Which of the following can be used to load data from a file into a non-existing table?
Please select all the correct answers.
  A. bulk insert
  B. DTS Wizard
  C. DTS Package
  D. select into

2. If you want to use the bcp program to load data skipping rows from the beginning of the file, which of the following parameters should you use?
Please select the best answer.
  A. -F
  B. FIRSTROW
  C. -L
  D. LASTROW

3. If you are loading data with bcp into a table that has identities and the file does not contain values for the identity, which of the following can you do?
Please select all the correct answers.
  A. Use a format file to skip the identity column
  B. Provide the –E parameter to bcp
  C. Do not provide the –E parameter
  D. Do not provide the –k parameter

4. Which of the following data sources can you use as a source system when using the DTS Wizard?
Please select all the correct answers.
  A. SQL Server
  B. Excel
  C. Oracle
  D. DB2