exam questions

Exam 98-364 All Questions

View all questions & answers for the 98-364 exam

Exam 98-364 topic 1 question 71 discussion

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

First normal form requires that a database excludes:

  • A. Foreign keys
  • B. Composite keys
  • C. Duplicate rows
  • D. Repeating groups
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️

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
syed5
Highly Voted 4 years, 11 months ago
repeating group (database) Any attribute that can have multiple values associated with a single instance of some entity. For example, a book might have multiple authors.Such a "-to-many" relationship might be represented in an normalized relational database as multiple author columns in the book table or a single author(s) column containing a string which was a list of authors. Converting this to "first normal form" is the first step in database normalization. Each author of the book would appear in a separate row along with the book's primary key. Later normalization stages would move the book-author relationship into a separate table to avoid repeating other book attributes (e.g. title, publisher) for each author.
upvoted 6 times
...
Kenny_A
Highly Voted 4 years, 6 months ago
There are two correct answers here. Each row must be unique, so rows cannot be duplicated, and repeating groups are not permitted.
upvoted 5 times
emka_ka
3 years, 3 months ago
the formal definition I think was used here in choosing only D. It speaks of 'attributes having atomic values' (so atomic values in columns cells, not atomic rows, even if consequently it leads to the same).
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
Loading ...