98-364 Exam QuestionsBrowse all questions from this exam

98-364 Exam - Question 118


You work for a small auto trading company. You need to remove a car from the company database.

Information about the car is stored in the following tables.

Exam 98-364 Question 118

All of the car's parts are custom made, so they each have a row in every table. Cascading deletes are not enabled but referential integrity is.

From which table must you first make your deletion?

Show Answer
Correct Answer: D

When removing a car's information from a database with referential integrity but without cascading deletes enabled, you need to remove entries starting from the tables with the least dependencies to avoid violating referential integrity constraints. In this case, you should start with the 'ModelEngine' table, as it directly connects the 'Model' and 'Engine' tables but doesn't depend on the 'Make' table. Deleting the 'ModelEngine' record first allows you to safely remove the corresponding entries in the 'Model' and 'Engine' tables subsequently, without causing any referential integrity issues.

Discussion

3 comments
Sign in to comment
vaibhav11
Sep 9, 2021

i think answer is D - ModelEngine as it is not referred anywhere

defcon1
Nov 30, 2021

That is my thought also. Since cascade deletion is not available, then we must start with ModelEngine.

defcon1Option: D
Nov 30, 2021

Since cascade deletion is not available, then we must start with ModelEngine. Answer D should be true.

Divyansh0003Option: D
Feb 8, 2022

Through Model Engine table we can access all the other tables