Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
26 Cards in this Set
- Front
- Back
All command-line switches for BCP are _______.
|
case-sensitive
|
|
The first bcp argument specifies the _____ or ____that BCP operates upon. The third argument specifies the _____ that is the source or target of the BCP command.
|
table or query
file |
|
The second bcp argument for the BCP command can be set to ___, ___, or ______.
|
in
out queryout |
|
When you import data into a table using BCP, _____ and __________ are disabled
|
triggers
check constraints |
|
When the second BCP switch is set to _____, the BCP command imports the entire contents of the file specified into the table specified.
|
in
|
|
When the second BCP switch is set to _____, the BCP command exports the entire contents of the
table into the file specified. |
out
|
|
When the second BCP switch is set to _____, the BCP command exports only a subset of a table or the result set based on a query.
|
queryout
|
|
The BCP switch ____ specifies that the data in the file is in the native format of SQL Server.
|
–n
|
|
The BCP switch ____ specifies that data in the file is in
a character format. |
–c
|
|
If you are exporting data which will be imported to another SQL Server instance, you should use the ____ switch because it provides better performance by allowing SQL Server to dump data in the internal storage format that SQL Server uses on the data
pages. |
–n
|
|
If you need to move a file between database platforms or to other non–SQL Server systems, you should use the ____ BCP switch, which converts the data from the native storage format of SQL Server into a standard character-based format.
|
–c
|
|
The ____ BCP switch specifies the instance name to connect to.
|
-S
|
|
The ____ BCP switch designates a trusted connection
and BCP uses the Windows credentials of the account that is executing the BCP command to connect. |
–T
|
|
You can use a SQL Server login by specifying the –U and –P switches when using BCP. –U specifies the _____ and –P specifies the _____ to use.
|
login name
password |
|
If you want to enforce check constraints and fi e triggers during a BCP import, you need to use the ____ switch.
|
–h
|
|
The BULK INSERT command has many of the same options as BCP and behaves almost identically, except for
the following two differences: |
1. cannot export data
2. does not need to specify login credentials |
|
If you want to import and export data directly between
source and destination, as well as apply transformations and error-handling routines, you can use the capabilities of ____ to build packages. |
SSIS
|
|
What are the data formats that BCP supports and the command-line switches for each format?
|
BCP can work with data in either a character or native format. The –c switch designates character mode while the –n switch is used for native mode.
|
|
Which BCP parameter do you specify to export data using a query?
|
The queryout parameter is used to export the result set of a query.
|
|
The Import and Export Wizard is based on which feature of SQL Server?
|
The Import and Export Wizard uses a subset of the SSIS feature.
|
|
Which sources and destinations is the Import and Export Wizard capable of using?
|
You can define any source or destination for which you have an OLE DB provider.
|
|
____ is a lightweight, command-line utility that allows you to import and export data.
|
BCP
|
|
The ____ utility is not designed to provide data transformation or error-handling
routines. |
BCP
|
|
In addition to exporting the entire contents of a table or view, you can export the results of a query by using the _____ argument for the BCP utility.
|
queryout
|
|
_____ is a T-SQL command you can use only to import data.
|
BULK INSERT
|
|
The Import and Export Wizard, based on a subset of SSIS, allows you to move data directly between a ____and _____ without requiring the use of a file.
|
source
destination |