nerdexam
Microsoft

70-457 · Question #46

You use a Microsoft SQL Server 2012 database that contains a table named BlogEntry that has the following columns: Id is the Primary Key. You need to append the "This is in a draft stage" string to…

The correct answer is B. UPDATE BlogEntry. See the full explanation below for the reasoning.

Question

You use a Microsoft SQL Server 2012 database that contains a table named BlogEntry that has the following columns:

Id is the Primary Key. You need to append the "This is in a draft stage" string to the Summary column of the recent 10 entries based on the values in EntryDateTime. Which Transact-SQL statement should you use?

Exhibit

70-457 question #46 exhibit

Options

  • AUPDATE TOP (10) BlogEntry
  • BUPDATE BlogEntry
  • CUPDATE BlogEntry SET Summary.WRITE(N' This is in a draft stage', NULL, 0)
  • DUPDATE BlogEntry

How the community answered

(24 responses)
  • A
    4% (1)
  • B
    83% (20)
  • C
    8% (2)
  • D
    4% (1)

Community Discussion

No community discussion yet for this question.

Full 70-457 Practice