ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 98-364 All Questions

View all questions & answers for the 98-364 exam
Go to Exam

Exam 98-364 topic 1 question 70 discussion

Actual exam question from Microsoft's 98-364
Question #: 70
Topic #: 1
[All 98-364 Questions]

Which statement should you use to remove a foreign key?

  • A. ALTER TABLE
  • B. DELETE TABLE
  • C. DELETE FOREIGN KEY
  • D. ALTER FOREIGN KEY
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by syed5 at July 9, 2020, 2:35 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
syed5
Highly Voted 4 years, 11 months ago
The ALTER TABLE statement is used to add, delete, or modify columns in an existing table. The ALTER TABLE statement is also used to add and drop various constraints on an existing table.
upvoted 6 times
emka_ka
3 years, 3 months ago
the ALTER TABLE here will be correct. when used with DROP FOREIGN KEY. You are correct if ALTER is used in isolation, for actions just on columns, but that is not a sole usage. amongst options given here A is correct. full syntax would have to be ALTER TABLE table_name DROP FOREIGN KEY constraint_name
upvoted 2 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel