You are a database administrator on an instance of SQL Server 2008. You need to perform complex processing on data from the OrderHistory table in your database. You need the ability to scroll backward and forward through the rows in…

Your Prod database resides on an instance of SQL Server 2008. The Prod database contains a SalesHeader table that is used by one of your applications. The SalesHeader table is defined as follows: Currently, the SalesHeader table has a clustered…

You are designing a table that will store transactions for an online retailer. You anticipate that the online retailer will have an average of 500,000 transactions per day. You need to design a solution for data aging and archiving. The…

You are designing a database that will store telephone numbers. You need to ensure that only phone numbers that use a specific format are written to the database. What should you create? A. a CHECK constraint B. a computed column…