Microsoft
70-433 · Question #150
You administer a Microsoft SQL Server database named AdventureWorks2008R2. The database has a table that has the following definition: You plan to implement custom error handling for INSERT…
The correct answer is C. Option C. See the full explanation below for the reasoning.
Question
You administer a Microsoft SQL Server database named AdventureWorks2008R2. The database has a table that has the following definition:
You plan to implement custom error handling for INSERT commands. The error number for a duplicate key is 2627. The error number for a NULL violation is 515. You need to ensure that an INSERT statement meets the following requirements:
Which Transact-SQL statement should you use?
Exhibits
Options
- AOption A
- BOption B
- COption C
- DOption D
How the community answered
(32 responses)- A3% (1)
- B3% (1)
- C84% (27)
- D9% (3)
Community Discussion
No community discussion yet for this question.