Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. Which is a bottom-up approach to database design that design by examining the relationship between attributes:
a. functional dependency
b. database modeling
c. normalization
d. decomposition
Q. A relation is in if an attribute of a composite key is dependent on an attribute of other composite key.
a. 2nf
b. 3nf
c. bcnf
d. 1nf
Q. What are the desirable properties of a decomposition
a. partition constraint
b. dependency preservation
c. redundancy
d. security
Q. R (A,B,C,D) is a relation. Which of the following does not have a lossless join dependency preserving BCNF decomposition?
a. a->b, b->cd
b. a->b, b->c, c->d
c. ab->c, c->ad
d. a->bcd
Q. The algorithm that takes a set of dependencies and adds one schema at a time, instead of decomposing the initial schema repeatedly is
a. bcnf algorithm
b. 2nf algorithm
c. 3nf synthesis algorithm
d. 1nf algorithm
Q. Which normal form is considered adequate for normal relational database design?
a. 2nf
b. 5nf
c. 4nf
d. 3nf
Q. Relation R with an associated set of functional dependencies, F, is decomposed into BCNF. The redundancy (arising out of functional dependencies) in the resulting set of relations is
a. zero
b. more than zero but less than that of an equivalent 3nf decomposition
c. proportional to the size of f+
d. indeterminate
Q. Which forms has a relation that possesses data about an individual entity?
a. 2nf
b. 3nf
c. 4nf
d. 5nf
Q. If a multivalued dependency holds and is not implied by the corresponding functional dependency, it usually arises from one of the following sources.
a. a many-to-many relationship set
b. a multivalued attribute of an entity set
c. a one-to-many relationship set
d. both a many-to-many relationship set and a multivalued attribute of an entity set
Q. Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set?
a. a many-to-many relationship set
b. a multivalued attribute of an entity set
c. a one-to-many relationship set
d. none of the mentioned
Q. Fifth Normal form is concerned with
a. functional dependency
b. multivalued dependency
c. join dependency
d. domain-key
Q. In 2NF
a. no functional dependencies (fds) exist
b. no multivalued dependencies (mvds) exist
c. no partial fds exist
d. no partial mvds exist
Q. can help us detect poor E- R design.
a. database design process
b. e-r design process
c. relational scheme
d. functional dependencies
Q. Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set.
a. a many-to-many relationship set
b. a multivalued attribute of an entity set
c. a one-to-many relationship set
d. all of the mentioned
Q. In which of the following, a separate schema is created consisting of that attribute and the primary key of the entity set.
a. a many-to-many relationship set
b. a multivalued attribute of an entity set
c. a one-to-many relationship set
d. all of the mentioned