In table OrderItem(order_id, product_id, quantity), neither order_id nor product_id is unique alone, so the primary key is declared as (order_id, product_id). What is such a key called?
Correct answer B. Composite key
Subject / 929 questions
Page 32 of Programming multiple-choice questions with answers. Tap an option to check yourself.
Page 32 of 47
Correct answer B. Composite key
Correct answer B. 4
Correct answer C. Entity integrity
Correct answer D. The delete is rejected with a foreign key violation
Correct answer B. The insert succeeds, because a NULL foreign key is not checked
Correct answer B. 2
Correct answer A. They must have the same number of attributes with compatible domains
Correct answer A. {s1, s3}
Correct answer D. 20 tuples, 5 attributes
Correct answer A. Natural join
Correct answer B. {A, B, C}
Correct answer C. AD
Correct answer C. 2NF
Correct answer B. 2NF
Correct answer A. R is in 3NF but not in BCNF
Correct answer B. First normal form
Correct answer A. Deletion anomaly
Correct answer B. R1(A, B) and R2(B, C)
Correct answer A. A lossless, dependency-preserving decomposition into 3NF always exists
Correct answer B. ALTER