Relational Database Management System MCQ : Preliminaries, Functional Dependencies : MCQ1
RDBMS MCQ & Answers
Are you worried about the answers to Relational Database Management System questions :Preliminaries, Functional Dependencies? We have arranged the Show Answer button under the each question. Candidates can click on it to know the right option among the given alternatives. Furthermore, the applicants can check our web portal @ www.totalmcq.com to take part in more MCQ on various subject. Wish, the given information about the Relational Database Management System MCQ will helpful to the advance and can learn the various types of questions and answers.
Q.1. A relational database consists of a collection of-----------.
A. Tables
B. Records
C. Fields D. Keys
Q.2.A--------in a table represents a relationship among a set of values.
A. Column
B. Row
C. Key D. Entry
Q.3. A functional dependency is a relationship between or among:----------
A. tables
B. Attributes
C. rows D. relations
Q.4. The term--------is used to refer to a row.
A. Attribute
B. Field
C. Tuple D. Instance
Q.5. The term attribute refers to a--------- of a table.
A. Record
B. Tuple
C. Key
D. Column
Q.6. The functional dependency of two sets E and F are considered as equivalent if----------
A. E + F = E - F
B. E * = F2
C. E * =F*
D. E2 = F2
Q.7. For some relations, changing the data can have undesirable consequences called--------
A. referential integrity constraints
B. normal forms
C. modification anomalies
D. transitive dependencies
Q.8. If attributes A and B determine attribute C, then it is also true that-------
A. A → C
B. (A,B) is a composite determinant
C. B → C
D. C is a determinant
Q.9. One solution to the multivalued dependency constraint problem is to -----------.
A. split the relation into two relations, each with a single theme.
B. change the theme.
C. create a new theme.
D. add a composite key.
Q.10. A function that has no partial functional dependencies is in-------form.
A. 2NF
B. 3NF
C. 4NF
D. BCNF
Q.11. 4NF is designed to cope with----------
A. Transitive dependency
B. Multi valued dependency
C. Join dependency D. None of the above
Q.12. A BCNF is --------
A. loss less join and dependency preserving.
B. loss less join but not dependency preserving.
C. not loss less join but dependency preserving.
D. None of the above.
Q.13. A functional dependency between two or more non-key attributes is called-------
A. Transitive dependency
B. Partial transitive dependency
C. Functional dependency
D. Partial functional dependency
Q.14. Every Boyee-Codd normal form is in---------.
A. First normal form
B. Second normal form
C. Third normal form
D. All of the above
Q.15. 5NF is designed to cope with-------
A. Transitive dependency
B. Multi valued dependency
C. Join dependency D. All of the above