Computer Programming MCQs

5739 MCQs  (Page 550 of 574)

Which of the following is a tuple-generating dependency?
A. Functional dependency
B. Equality-generating dependencies
C. Multi-valued dependencies
D. Non-functional dependency
The main task carried out in the ……. is to remove repeating attributes to separate tables?
A. First normal form
B. Second normal form
C. Third normal form
D. Fourth normal form
Which of the following has each related entity set its own schema and there is an additional schema for the relationship set?
A. A many-to-many relationship set
B. A multi-valued attribute of an entity set
C. A one-to-many relationship set
D. Both a & b
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 multi-valued attribute of an entity set
C. A one-to-many relationship set
D. Both a & b
In 2NF:
A. No functional dependencies (fds) exist
B. No multivalued dependencies (mvds) exist
C. No partial fds exist
D. No partial mvds exist
……. can help us detect poor E-R design?
A. Database design process
B. E-r design process
C. Relational scheme
D. Functional dependencies
What is the best way to represent the attributes in a large database?
A. Relational-and
B. Concatenation
C. Dot representation
D. All of the mentioned