Discussion
Home ‣ Database ‣ Logical Database Design Comments
- Question
A foreign key may be null and still adhere to the referential integrity constraint.
Options- A. True
- B. False
- Correct Answer
- True
- 1. Well-structured relations encourage anomalies of data.
Options- A. True
- B. False Discuss
- 2. If a relation is in third normal form, it does not need to be in second normal form.
Options- A. True
- B. False Discuss
- 3. A synonym is two or more attributes that have different names but the same meaning.
Options- A. True
- B. False Discuss
- 4. A composite attribute does not get mapped into a relation.
Options- A. True
- B. False Discuss
- 5. A candidate key must uniquely identify each row.
Options- A. True
- B. False Discuss
- 6. The primary key in a relation does not need to be underlined.
Options- A. True
- B. False Discuss
- 7. The joining technique is useful when data from several relations are to be retrieved and displayed and the relationships are not necessarily nested.
Options- A. True
- B. False Discuss
- 8. There should be one condition within the WHERE clause for each pair of tables being joined.
Options- A. True
- B. False Discuss
- 9. A transaction is the complete set of closely related update commands that must all be done, or none of them done, for the database to remain valid.
Options- A. True
- B. False Discuss
- 10. A correlated subquery is where the outer query depends on data from the inner query.
Options- A. True
- B. False Discuss
Logical Database Design problems
Search Results
Correct Answer: False
Correct Answer: False
Correct Answer: True
Correct Answer: True
Correct Answer: True
Correct Answer: False
Correct Answer: True
Correct Answer: True
Correct Answer: True
Correct Answer: False
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.