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

Exam 98-361 All Questions

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

Exam 98-361 topic 1 question 116 discussion

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

This question requires that you evaluate the underlined text to determine if it is correct.
A table whose attributes depend only on the primary key must be at least second normal form.
Select the correct answer if the underlined text does not make the statement correct. Select "No change is needed'' if the underlined text makes the statement correct.

  • A. No change is needed
  • B. first
  • C. third
  • D. fourth
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
2nd Normal Form Definition
A database is in second normal form if it satisfies the following conditions:

It is in first normal form -
All non-key attributes are fully functional dependent on the primary key
by Pomphard at Sept. 7, 2020, 5:31 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
Effenberg
9 months, 2 weeks ago
SC200 materials Just got updated do you guys have new questions for it.
upvoted 1 times
...
Rour
9 months, 2 weeks ago
2nd form: The table also should not contain partial dependency. Here partial dependency means the proper subset of candidate key determines a non-prime attribute.
upvoted 1 times
...
LordPapkin
11 months, 3 weeks ago
Third!
upvoted 2 times
...
Pomphard
1 year, 8 months ago
As all attributes depend only on the primary key there can be no transitive dependency, right? So that'd mean the database automatically satisfies the 3rd normal form as well. I think the answer should be C
upvoted 2 times
itexamsmicrosoft
1 year, 2 months ago
incorrect. second form is the correct answer.
upvoted 1 times
...
vinx909
1 year, 1 month ago
three users could have the same address, so that address would be in the database 3 times. 3rd normal form would move the address to it's own table with users having a reference to it.
upvoted 1 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago