Microsoft
70-433 · Question #111
You have a table named Orders. OrderID is defined as an IDENTITY(1,1). OrderDate has a default value of 1. You need to write a query to insert a new order into the Orders table for CustomerID 45…
The correct answer is C. INSERT INTO Orders. See the full explanation below for the reasoning.
Question
You have a table named Orders. OrderID is defined as an IDENTITY(1,1). OrderDate has a default value of 1. You need to write a query to insert a new order into the Orders table for CustomerID 45 with today's date and a cost of 89.00. Which statement should you use?
Exhibit
Options
- AINSERT INTO Orders
- BINSERT INTO Orders
- CINSERT INTO Orders
- DINSERT INTO Orders
How the community answered
(47 responses)- A15% (7)
- B4% (2)
- C74% (35)
- D6% (3)
Community Discussion
No community discussion yet for this question.