Database Questions and Answers for Experienced people on ” Querying database″.
1. Which s essential a business problem not a data problem:
a) Data
b) Database
c) Database design
d) All of the mentioned
Answer: c
Clarification: SQL-99 is the most recent version of standard SQL prescribed by the ANSI.
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
Answer: d
Clarification: Data modelling designs the data in a secured manner.
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
Answer: c
Clarification: SQL-99 is the most recent version of standard SQL prescribed by the ANSI.
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
Answer: b
Clarification: Insertion anomaly is due to confusion in data deletion or insertion.
5. How many types of insertion anomalies:
a) 1
b) 2
c) 3
d) 4
Answer: b
Clarification: Insertion anomaly is due to confusion in data deletion or insertion.
6. Who developed the normalization process:
a) E.F. codd
b) F.F. codd
c) E.E. codd
d) None of the mentioned
Answer: a
Clarification: Normalization helps in improving the quality of the data.
7. E.F.Codd developed the normalization process in the which early:
a) 1969
b) 1970
c) 1971
d) 1972
Answer: b
Clarification: Normalization helps in improving the quality of the data.
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
Answer: c
Clarification: Normalization helps in improving the quality of the data.
9. Which is the process of breaking a relation into multiple relations:
a) Functional dependency
b) Database modeling
c) Normalization
d) Decomposition
Answer: d
Clarification: SQL-99 is the most recent version of standard SQL prescribed by the ANSI.
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
Answer: c
Clarification: Normalization helps in improving the quality of the data.