PrepAway - Latest Free Exam Questions & Answers

Tag: mss

What should you do?

You discover that the schema changes that were recently made to your SQL Server 2005 database have caused your Web site to stop functioning. It is unclear who made the changes. Domain.com now mandates that all changes to the database schema be tracked. You need to implement a mechanism that will track schema changes in your database.
What should you do?

Which two bcp commands could you use to accomplish this?

You are a database administrator for your company.
You transfer data from the Prod1 database maintained onthe Sql1 instance of SQL Server 2008 into an external data file before sending the data file to vendors.
You mustsend all the data from the Tbl_auction_rate table. You must use the bcp utility to accomplish this.
Which two bcp commands could you use to accomplish this? (Choose two. Each correct answer represents acomplete solution.)