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