Chapter 5 Normalization of Database Tables MCQs

14 min Score: 0 Attempted: 0/14 Subscribe
1. A functional dependency is a relationship between or among





2. The database design prevents some data from being stored due to _______.





3. If one attribute is determinant of second, which in turn is determinant of third, then the relation cannot be:





4. A relation is in 2NF if:





5. In which form of function there is no partial functional dependencies?





6. In which normal form Boyce-Codd can operate?





7. In relational databases, the table is also called _____?





8. In 3NF a non-key attribute must not depend on a _____?





9. Different attributes in two different tables having same name are referred to as _____?





10. Every relation must have _____?





11. The goal of normalization is to ____?





12. A rule that states that each foreign key value must match a primary key value in the other relation is called _____?





13. Two or more attributes having different names but same meaning are called _____?





14. A constraint between two attributes is called _____?





Contents Copyrights Reserved By T4Tutorials