SQL Server 7.0 Questions

1. Why does each T-SQL command start with the prefix sp_? What does the sp_ stand for?
2. Please explain the basic BCP command syntax and list a few simple examples.
3. What is a transaction?
4. What is the DTC used for?
5. What is thedifference between “order by”, “where”, and “group by” in SQL Server?