nerdexam
CIW

1D0-441 · Question #141

The exhibit shows a table called Student Relation that tracks all information related to a students courses, professors and sites. What would be the consequence of removing all records for a student…

The correct answer is C. A deletion anomaly would occur. See the full explanation below for the reasoning.

Question

The exhibit shows a table called Student Relation that tracks all information related to a students courses, professors and sites. What would be the consequence of removing all records for a student with the ID 1311?

Exhibit

1D0-441 question #141 exhibit

Options

  • ANo adverse effects would occur on the database.
  • BAn insertion anomaly would occur.
  • CA deletion anomaly would occur.
  • DAn update anomaly and a deletion anomaly would occur.

How the community answered

(43 responses)
  • A
    5% (2)
  • B
    16% (7)
  • C
    72% (31)
  • D
    7% (3)

Community Discussion

No community discussion yet for this question.

Full 1D0-441 Practice