When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):

A Transitive Dependency
B Insertion Anomaly
C Referential Integrity Constraint
D Normal Form

Correct Answer: Referential Integrity Constraint

Referential Integrity is set of constraints applied to foreign key which prevents entering a row in child table for which you don’t have any corresponding row in parent table i.e. entering NULL or invalid foreign keys.
Bissoy MCQ
#Oracle Database #Normalization

Related Questions

When a foreign key column is created without a corresponding foreign key constraint, we have created a "casual relationship" between the two tables.
A True
B False
When they had a meeting seven company executives __ T, U, V, W, X, Y and Z ___ sit at a rectangular table .Three executives sit along one side of the table , and three sit along the other side, each directly opposite one of the other three. The seventh sits at the head of the table . There is no seat at the foot of the table . Ualways sits in one of te two seats farthest from the head of the table. Y and V always sit next to each other .V never sits next to Z . If Z does not sit at the head of the table, W sits there. If W sits directly opposite T, X must sit next to which of the following excutives?
A T
B U
C V
D Z
Six arms negotiators -- M,O,P,R,S and T-- are to be seated at a round table to discuss disarmament. There are exactly six chairs around the table. Each negotiator sits facing the center of the table and is directly opposite a negotiators across the table.The seating arrangement is subject to the following restrictions : T cannot sit next to P;S cannot sit next to M;R must sit next to M. If T sits directly across the table from O, who must sit on the other side of P?
A M and O
B M and S
C O and R
D O and S
h,J,K,L,M,N and O are the only legislators eligible to vote on Bills 1,2 and 3, each of which will be passed if at least four legislators eligible vote in favor of it. each legislator must vote on all three bills; on abstentions are possible. The following is known : *H must vote against all three bills; each of the other legislators must vote in favor of at least one bill and against at lest one bill. *j must vote against Bills 1. *O Must vote against Bills 2 and 3. * L must the same way that K dose on all three bills.*N must vote the same way that O dose on all three bills. which of the following must vote in favor of Bill 1 ?
A J
B K
C L
D O
h,J,K,L,M,N and O are the only legislators eligible to vote on Bills 1,2 and 3, each of which will be passed if at least four legislators eligible vote in favor of it. each legislator must vote on all three bills; on abstentions are possible. The following is known : *H must vote against all three bills; each of the other legislators must vote in favor of at least one bill and against at lest one bill. *j must vote against Bills 1. *O Must vote against Bills 2 and 3. * L must the same way that K dose on all three bills.*N must vote the same way that O dose on all three bills. If any bill is to be passed,which of the following must be among the legislators who vote in favor of it?
A J
B K
C M
D N
Six arms negotiators -- M,O,P,R,S and T-- are to be seated at a round table to discuss disarmament. There are exactly six chairs around the table. Each negotiator sits facing the center of the table and is directly opposite a negotiators across the table.The seating arrangement is subject to the following restrictions : T cannot sit next to P;S cannot sit next to M;R must sit next to M. Which of the following is an acceptable sequence of negotiators around the table ?
A M,S,R,T,P,O
B M,S,T,P,R,O
C T,O,P,S,M,R
D T,R,M,P,S,O
Six arms negotiators -- M,O,P,R,S and T-- are to be seated at a round table to discuss disarmament. There are exactly six chairs around the table. Each negotiator sits facing the center of the table and is directly opposite a negotiators across the table.The seating arrangement is subject to the following restrictions : T cannot sit next to P;S cannot sit next to M;R must sit next to M. If T sits next to M and S sits next to R, which of the other negotiators must sit next to s ?
A M
B O
C P
D R
h,J,K,L,M,N and O are the only legislators eligible to vote on Bills 1,2 and 3, each of which will be passed if at least four legislators eligible vote in favor of it. each legislator must vote on all three bills; on abstentions are possible. The following is known : *H must vote against all three bills; each of the other legislators must vote in favor of at least one bill and against at lest one bill. *j must vote against Bills 1. *O Must vote against Bills 2 and 3. * L must the same way that K dose on all three bills.*N must vote the same way that O dose on all three bills. The maximum number of favorable votes that Bill 2 could receive is ---
A Two
B Three
C Four
D Five
h,J,K,L,M,N and O are the only legislators eligible to vote on Bills 1,2 and 3, each of which will be passed if at least four legislators eligible vote in favor of it. each legislator must vote on all three bills; on abstentions are possible. The following is known : *H must vote against all three bills; each of the other legislators must vote in favor of at least one bill and against at lest one bill. *j must vote against Bills 1. *O Must vote against Bills 2 and 3. * L must the same way that K dose on all three bills.*N must vote the same way that O dose on all three bills. which of the following cannot be true ?
A J and K vote in favor of the same bill
B J and O vote in favor of the same bill
C J votes in favor of one bill and against two bills
D k votes in favor of two bills and against one bill
h,J,K,L,M,N and O are the only legislators eligible to vote on Bills 1,2 and 3, each of which will be passed if at least four legislators eligible vote in favor of it. each legislator must vote on all three bills; on abstentions are possible. The following is known : *H must vote against all three bills; each of the other legislators must vote in favor of at least one bill and against at lest one bill. *j must vote against Bills 1. *O Must vote against Bills 2 and 3. * L must the same way that K dose on all three bills.*N must vote the same way that O dose on all three bills. If M votes the same way that O dose on all three bills, which of the following can be determined ?
A Bill I will be passed
B Bill I will be defeated
C Bill 2 will be passed
D Bill 2 will be defeated

Next steps