nerdexam
Microsoft

98-364 · Question #209

This question requires that you evaluate the underlined text to determine if it is correct. The CREATE TABLE command removes one or more table definitions and all data, indexes, triggers…

The correct answer is B. DROP TABLE. See the full explanation below for the reasoning.

Question

This question requires that you evaluate the underlined text to determine if it is correct. The CREATE TABLE command removes one or more table definitions and all data, indexes, triggers, constraints, and permission specifications for those tables. Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct

Options

  • ANo change is needed
  • BDROP TABLE
  • CTRUNCATE TABLE
  • DALTER TABLE

How the community answered

(32 responses)
  • A
    3% (1)
  • B
    72% (23)
  • C
    9% (3)
  • D
    16% (5)

Community Discussion

No community discussion yet for this question.

Full 98-364 Practice