There is a request to insert a row into table Tc with values 10,20,30 respectively for ax,bp,cm.Which of the following will take place?
A) The request cannot be executed
B) A row will be created in Tb and Tc (the "same" row) with value bp = 20 in Tb, and cm = 30 in Tc
C) A row will be created in Ta, Tb and Tc (the "same" row) with value ax = 10 in Ta, bp = 20 in Tb, and cm = 30 in Tc
D) Only one row will be created in Tc with value cm = 30

Question

Quizplus · Accepted Answer

The request is asking for a row to be inserted into table Tc with values 10, 20, and 30 respectively for ax, bp, and cm. This means that there should also be corresponding values for ax and bp in other tables. Therefore, a row will be created in Ta, Tb, and Tc with value ax = 10 in Ta, bp = 20 in Tb, and cm = 30 in Tc. This satisfies the request for inserting a row into Tc with the given values. Option A is not correct as the request can be executed. Option B is not correct as there should only be one row in Tc with the value of cm = 30. Option D is also not correct as there should be corresponding values for ax and bp in other tables.

There Is a Request to Insert a Row into Table