What is "bcp"?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is "bcp"?

"bcp" is the "Bulk Copy" command line utility provided in the MS SQL Server package.
It can be used to import large numbers of new rows into SQL Server tables from data files or to export data out of tables into data files.

(Continued on next question...)

Other Job Interview Questions

• Where are database files and backup files of a MS SQL Server database located?
• What is the meaning of the following T-SQL command: DBCC SHRINKDATABASE ( Database, 10%)
• What two categories you can divide T-SQL statements into?
• What is the meaning of an Outer Join operatin of two tables?
• What is the different between concurrent connections and concurrent user logins?
• What is setup.iss file used for during MS SQL Server installation?
• When "SET CONCAT_NULL_YIELDS_NULL ON", concatenating a null value with a string will yield a NULL result. But this only applies to the current session if you use in Query Analyzer. Is this true?
• What is the size a Page in MS SQL Server?
• What is the meaning of the following T-SQL command: SELECT * FROM users WHERE first_name LIKE 'M%'
• What is the meaning of the following T-SQL command: EXEC sp_dboption 'OrderDB', 'single user', 'true'
• More...