nerdexam
Microsoft

70-433 · Question #118

You have been tasked with creating a table named dbo.Widgets. You need to insert five rows into the dbo.Widgets table and return WidgetID for each of the five rows that have been inserted. Which…

The correct answer is A. CREATE TABLE dbo.Widgets (. See the full explanation below for the reasoning.

Question

You have been tasked with creating a table named dbo.Widgets. You need to insert five rows into the dbo.Widgets table and return WidgetID for each of the five rows that have been inserted. Which Transact-SQL batch should you use?

Options

  • ACREATE TABLE dbo.Widgets (
  • BCREATE TABLE dbo.Widgets (
  • CCREATE TABLE dbo.Widgets (
  • DCREATE TABLE dbo.Widgets (

How the community answered

(27 responses)
  • A
    70% (19)
  • B
    4% (1)
  • C
    19% (5)
  • D
    7% (2)

Community Discussion

No community discussion yet for this question.

Full 70-433 Practice