Page: 1
/ 26
Total 128 questions
Which term describes the rejoining of relations that have been decomposed?
- A. Normalization
- B. Denormalization
- C. Referential integrity
- D. Domain constraints
Answer : B
The creation of intermediate entities occurs during the logical database design phase for an enterprise. It is used to resolve which types of relationships?
- A. One-to-many, complex, and recursive
- B. Complex, recursive, and many-to-many
- C. Redundant, recursive, and many-to-many
- D. One-to-many and one-to-one
Answer : B
Consider the Dept1_Parts and Dept2_Parts relations shown in the exhibit. Which of the following SQL statements would create a set difference of the two relations with the widest variety of Structured Query Language dialects?
- A. SELECT * FROM Dept1_Parts EXCEPT (SELECT Part_ID FROM Dept2_Parts);
- B. SELECT * FROM Dept1_Parts MINUS (SELECT Part_ID FROM Dept2_Parts);
- C. SELECT * FROM Dept1_Parts DIFFERENCE (SELECT Part_ID FROM Dept2_Parts);
- D. SELECT * FROM Dept1_Parts DIFFERENCE (SELECT Part_ID FROM Dept2_Parts);
Answer : D
Which mechanism provides database users with controlled access to the database through the use of virtual tables?
- A. View
- B. Data dictionary
- C. Database control language
- D. Database management system
Answer : A
31 days access 