nerdexam
Microsoft

70-433 · Question #25

You work as a network database administrator at ABC.com. ABC.com has a database server named ABC-DB02 hosting the Inventory database. The Inventory database has two tables named Sales and SalesRep…

The correct answer is B. By creating a Transact-SQL statement utilizing the DELETE FROM SalesRep. See the full explanation below for the reasoning.

Question

You work as a network database administrator at ABC.com. ABC.com has a database server named ABC-DB02 hosting the Inventory database. The Inventory database has two tables named Sales and SalesRep that are related by a foreign key with the CASCADE DELETE option. How would have the records of the Sales table removed?

Options

  • ABy creating a Transact-SQL statement utilizing the ALTER TABLE Sales.
  • BBy creating a Transact-SQL statement utilizing the DELETE FROM SalesRep.
  • CBy creating a Transact-SQL statement utilizing the TRUNCATE DATABASE Inventory.
  • DBy creating a Transact-SQL statement utilizing the INSTEAD OF DELETE.
  • EBy creating a Transact-SQL statement utilizing the DELETE TOP Sales.

How the community answered

(22 responses)
  • B
    82% (18)
  • C
    5% (1)
  • D
    5% (1)
  • E
    9% (2)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-433 Practice