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
Explanation: 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
View Answer
Explanation: 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
View Answer
Explanation: 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
View Answer
Explanation: 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
View Answer
Explanation: 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
View Answer
Explanation: 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
View Answer
Explanation: 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
View Answer
Explanation: 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
View Answer
Explanation: 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
View Answer
Explanation: Normalization helps in improving the quality of the data.
Sanfoundry Global Education & Learning Series – Database Management System.
- Practice Computer Science MCQs
- Check Computer Science Books
- Check DBMS Books
- Practice RDBMS MCQ
- Apply for Computer Science Internship