Study tips 70-432
You need to check the physical consistency of the database
You need to rectify a damaged index without losing any data
Which Transact-SQL statement(s) should you execute in the DB1 database?
What should you include in your solution?
Which four Transact-SQL statements should you use?
Which three actions should you perform in sequence?
You need to partition the table by year
What utility should you run to create the requested package?
How should you remedy the situation?
What steps should you take?