You are designing a table to store date and time information for an application. The application will be used by users in Europe, Asia, and North America. You need to add a column that stores the date and time information…
You are a database developer. You plan to design a database solution by using SQL Server 2008. The database will contain a table to stage data from an external source. The imported data will contain a field named TransactionTime. The…
You need to design a table that will contain a monetary value. The value must support five digits to the right of the decimal point. Which data type should you choose? A. money B. bigint C. decimal D. int
You are a database developer. You plan to design a database solution by using SQL Server 2008. A database contains two tables named Orders and OrderDetails. There is also a data warehouse containing a table named factSales. The factSales tale…
You are designing a new database. The tables of the database will be replicated to multiple offices. You need to design the tables to meet the following requirements: • A row identifier must be set when a row is created…
You have a server that runs SQL Server 2008 Enterprise. You have a query that contains SUM, AVG, and MAX functions. You discover that the query takes a long time to execute. You need to reduce the amount of time…
You have a stored procedure that uses a cursor. The stored procedure updates several related tables. You discover that the stored procedure runs slowly and uses a significant amount of resources on the database server. You need to recommend changes…
You need to design a stored procedure that contains a transaction. If an error condition causes the transaction to roll back, a temporary result set must be available to the query that follows the failed transaction. Which temporary storage object…
You are a database developer. You plan to design a database solution by using SQL Server 2008. The database includes a table that contains the following product inventory information: • Department • Class • Item • Quantity You plan to…
You are a database developer. You plan to design a database solution by using SQL Server 2008. The database contains a large table that has 20 million rows. The table contains the following columns: CustomerNumber • CompanyName • ContactFirstName •…