What is "osql"? What can you do with "osql"?

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

(Continued from previous question...)

What is "osql"? What can you do with "osql"?

"osql" is command line utility included in the MS SQL Server package. It allows your to connect to a MS SQL Server and run T-SQL statements. "osql" uses ODBC connections to communicate with the server.

(Continued on next question...)

Other Job Interview Questions

• What two categories you can divide T-SQL statements into?
• What can you do with the Bulk Copy operation in MS SQL Server?
• What is default sorting order when you use "ORDER BY" clause in a query statement?
• What can you do with the "ALTER DATABASE ..." T-SQL command?
• What is the size a Page in MS SQL Server?
• What is the different between concurrent connections and concurrent user logins?
• What should you do to prepare for MS SQL Server upgrade?
• By default, MS SQL Server sets the index fill factor to 100%. What does this mean?
• What is the main feature of the "RAID 0" disk configuration?
• What is the meaning of the following T-SQL command: "GRANT CREATE TABLE TO <username>"
• More...