Microsoft
70-433 · Question #158
You administer a Microsoft SQL Server 2008 database that contains tables named Sales.Customer and Sales.SalesOrder. A diagram of the tables is shown in the exhibit. (Click the Exhibit button.) You…
The correct answer is B. Option B. See the full explanation below for the reasoning.
Question
You administer a Microsoft SQL Server 2008 database that contains tables named Sales.Customer and Sales.SalesOrder. A diagram of the tables is shown in the exhibit. (Click the Exhibit button.) You need to execute a query to update the value of the Customer-Value field to HV when a customer has more than 5 orders for a total sales amount of more than 5,000U.S. dollars. Which Transact-SQL statement should you use?
Options
- AOption A
- BOption B
- COption C
- DOption D
How the community answered
(50 responses)- A14% (7)
- B78% (39)
- C6% (3)
- D2% (1)
Community Discussion
No community discussion yet for this question.