1. | State true or false: SQL specifies a way of mentioning functional dependencies |
Answer: (b).False
|
2. | State true or false: Most current database systems do not support constraints on materialized view |
Answer: (a).True
|
3. | Multi valued dependencies are also called as __________ |
Answer: (b).Tuple generating dependencies
|
4. | Functional dependencies are sometimes referred to as ________ |
Answer: (a).Equality generating dependencies
|
5. | The _______ is a set of all functional and multi values dependencies implied by a set of functional dependencies |
Answer: (b).Closure
|
6. | State true or false: If a relational schema is in _______ NF and A is a subset of R and B is also a subset of R then it is that A is a superkey is a trivial multi values dependency. |
Answer: (d).4
|
7. | Which of the following normal forms does not exist? |
Answer: (d).None of the mentioned
|
8. | Choose the correct statement regarding superkeys |
Answer: (a).A superkey is an attribute or a group of multiple attributes that can uniquely identify a tuple
|
9. | What is an Instance of a Database? |
Answer: (c).The state of the database system at any given point of time
|
10. | What is a foreign key? |
Answer: (c).A foreign key is an attribute of a relation that is a primary key of another relation
|