An administrator builds a new custom table for tracking facilities jobs and configures it to extend the Task table. Which statement describes the relationship between the new table and Task?
- AIt inherits Task's fields, including Number, State, Assignment group and Assigned to, and may carry additional fields of its own that Task does not hold. Correct
- BIt receives a one time copy of Task's fields when it is created, so a field added to Task afterwards does not appear on the new table.
- CIt receives the Number field alone, and common fields such as State, Assignment group and Assigned to have to be created on the new table by hand.
- DIt inherits Task's fields but cannot define any of its own, so job specific data has to be held on a separate related table joined to it.
Why A is correct: Correct because an extended table inherits the parent's fields and can define further fields specific to itself, which is why incident, problem and change all share the task fields yet differ.
Why B is wrong: Tempting because copying is how many import and template mechanisms behave, but table extension is live inheritance rather than a snapshot, so a field added to Task later is available to every extending table.
Why C is wrong: Tempting because Number is the field candidates notice first on task records, but the whole point of extending Task is that the common work management fields come with it rather than being rebuilt.
Why D is wrong: Tempting because inheritance sounds restrictive, but an extending table is free to add its own fields, and forcing a related table would be unnecessary work.