nerdexam
Microsoft

70-459 · Question #61

You need to create the object used by the parameter of usp_UpdateEmployeeName. Which code segment should you use?

The correct answer is B. CREATE TYPE EmployeesInfo AS Table. See the full explanation below for the reasoning.

Question

You need to create the object used by the parameter of usp_UpdateEmployeeName. Which code segment should you use?

Options

  • ACREATE XML SCHEMA COLLECTION EmployeesInfo
  • BCREATE TYPE EmployeesInfo AS Table
  • CCREATE TABLE EmployeesInfo
  • DCREATE SCHEMA EmployeesInfo

How the community answered

(30 responses)
  • A
    3% (1)
  • B
    83% (25)
  • C
    3% (1)
  • D
    10% (3)

Community Discussion

No community discussion yet for this question.

Full 70-459 Practice