What can you do with the "BULK INSERT" T-SQL com

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

(Continued from previous question...)

What can you do with the "BULK INSERT" T-SQL command in MS SQL Server?

"BULK INSERT" T-SQL command can be used to import a data file into a table in MS SQL Server.

(Continued on next question...)

Other Job Interview Questions

• By default, MS SQL Server sets the index fill factor to 100%. What does this mean?
• What does Constraint refer to in MS SQL Server?
• How do you describe a field in a table in the database?
• What is the default TCP/IP port # used by MS SQL Server to receive connection requests?
• If you finish installing MS SQL Server as Named Instance, what would be the default path name on the hard disk where the server will be installed to?
• What is the meaning of an Outer Join operatin of two tables?
• What is the minimum of hard disk space required by MS SQL Server?
• What does RDBMS stand for?
• What is the use of *.ndf files in MS SQL Server?
• What two categories you can divide T-SQL statements into?
• More...