You are working for an online retailer on a section of the site that allows people to create new customer records. At the moment the customer table has primary key of first name and last name.
You get a support call one day form customer care stating that John Smith cannot create a new account. Upson investigation you realize that you already have a John Smith as a customer.
How would you alter the database to allow for multiple customers with the same name?

You are a developer working on transaction processing application for an online retailer. You are currently implementing a new feature where the exact date and time of the transaction is stored, so that you can guarante shipment within 48 hours.
You are working on a report that locates unshipped orders that are more than 40 hours old. You find that some orders are causing data errors. Upon investigation you find that the order date and time are being stored in an nvarchar(30) field and that the format of the date is not uniform.
What is the best way to fix this problem?

You are working for a medical records ompany. Your company makes serveral products all of which use the same database. One of your applications is reporting a data error because there is no medical record number associated with some of the medical records.
Upon investigation you discover that the pocket PC application is not requiring that a medical record number be generated for each record. The pocket PC group is asked to fix their application and you are asked to fix the database.
After you assign medical record numbers to the orphan records, what is the best solution?

You can use a compare validator to perform all but one of the following validations. Which one is it?

You cannot directly apply an ASP.NET theme to a master page. However, themes are applied to master pages under these circumstances:

You create an ASP.NET page that allows a user to enter a requested delivery date in a TextBox control named requestTKDate. The date must be no earlier than two business days after the order date, and no later that 60 business days after the order date.
You add a CustomValidator control to your page. In the Properties window, you set the ControlToValidate property to requestTKDate.
You need to ensure that the date entered in the requestDate TextBox control falls within the acceptable range of values. In addition, you need to minimize the number of round trips to the server.
What should you do?

You create an ASP.NET application for Regalia Bank. The project manager requires a standard appearance for all Web applications. Standards are expected to change periodically. You need to enforce these standards and reduce maintenance time.
What should you do?

You have developed a timeheet entry application that will be used by all employees in your company. You have used ASP.NET to develop this application and have deployed it on the company’s Web server. What should all the employees of the company install on therir computers before accessing the timesheet entry application.

You have organized your files two folder: web_pages and web_image.
The folder web_images contains an image "theseus.jpg" which should appear on the page main.html in the folder web_pages.
Which is the correct code:

You have designed a Web form that uses a DropDownList control to allow a user to select a state containing her shipping address. You’ve implemented an event handler for the SelectedIndexChanged event to update the sales tax amount displayed on the Web form when a new state is selected.
User report that the sales tax amount is not updated no matter which state they choose in the DropDownList control.
What must you do to fix this problem?