Database Questions and Answers – Querying Database – 4

This set of Database Multiple Choice Questions & Answers (MCQs) focuses on “Querying database part – 4”.

1. Which s essential a business problem not a data problem:
a) Data
b) Database
c) Database design
d) All of the mentioned
View Answer

2. Which is primarily the result of a thorough understanding of information about an enterprise:
a) Data
b) Database
c) Database design
d) Data modeling
View Answer

3. McFadden has defined normalization in his which book___________
a) Database modern management
b) Management database of modern
c) Modern database management
d) Database management
View Answer

4. The database design prevents some data from being represented due to _______
a) Deletion anomalies
b) Insertion anomalies
c) Update anomaly
d) None of the mentioned
View Answer

5. How many types of insertion anomalies:
a) 1
b) 2
c) 3
d) 4
View Answer

6. Who developed the normalization process:
a) E.F. codd
b) F.F. codd
c) E.E. codd
d) None of the mentioned
View Answer

7. E.F.Codd developed the normalization process in the which early:
a) 1969
b) 1970
c) 1971
d) 1972
View Answer

8. 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
View Answer

9. Which is the process of breaking a relation into multiple relations:
a) Functional dependency
b) Database modeling
c) Normalization
d) Decomposition
View Answer

10. Which formal method that locates and analyses relation schemas on the basis of their primary, candidate keys, and the FD’s that are present among the attributes of these schemas:
a) Functional dependency
b) Database modeling
c) Normalization
d) Decomposition
View Answer

Sanfoundry Global Education & Learning Series – Database Management System.