You have a table named Sales.
You need to return sales data ordered by customer name. For each customer, the most recent sale must be listed first.
Which query should you use?

You are a database developer. You plan to design a database solution by using SQL Server 2008.
There are two schemas named Sales and Marketing. You are the owner of the Sales schema and the Marketing schema is owned by a user named MarketingUser.
Users of the Marketing schema do not have permissions to access the Sales schema. You have permissions to create objects in all schemas in the database.
The Sales schema has a table named Customers.
You plan to create a storedprocedure in the Marketing schema for the marketing team. The stored procedure will select data from the Customers table and will be owned by MarketingUser.
You need to ensure that the marketing team is able to execute the stored procedure.
What should you do?

You have a transaction that uses the repeatable read isolation level.
This transaction causes frequent blocking problems. You need to reduce blocking. You also need to avoid dirty reads and non-repeatable reads.
Which transaction isolation level should you use?

You are a database developer. You plan to design a database solution by using SQL Server 2008.
The database contains two tables named Supplier and Product. There is a foreign key constraint between the Supplier and Product tables on the SupplierID column. The Supplier table contains a row that has the SupplierID value as 0. The 0 value indicates that the supplier is deleted.
Certain transactions delete the supplier records from the Supplier table.
You need to ensure that if a supplier is deleted, the SupplierID value in the Product table is set to 0.
What should you do?

You are creating a function that references a table.
You need to prevent the table from being dropped.
Which option should you use when you create the function?

You are a database developer. You plan to design a database solution by using SQL Server 2008. The database will store multilingual data.
The database will contain a table that has 100 million rows.
The table will contain 1,000 columns that are based on the nvarchar(max) data type. For each column, only2 percent of th e rows will be populated.
You need to design the table to optimize storage space.
What should you do?

You need to create a stored procedure that accepts a table valued parameter named @Customers.
Which code segment should you use?