Exit 70-433 TS: Microsoft SQL Server 2008, Database Development
Question 3 of 5
0% complete
Q3 Single choice

You administer a Microsoft SQL Server 2008 database named AdventureWork that contains a table named Production.Product.

The table has the following definition:

You want to add a new product named Widget and a list price of 10.50 U.S. dollars to the product table.

You need to add a record for the product information. You also need to set the DateCreated field to the current date and the UserCreated field to your Windows login identification name.

Which Transact-SQL statement should you use?

  • A

    Option A

  • B

    Option B

  • C

    Option C

  • D

    Option D