Database Questions and Answers – Querying Database – 4

This set of Database Questions and Answers for Experienced people 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

Answer: c
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

Answer: d
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

Answer: c
Explanation: SQL-99 is the most recent version of standard SQL prescribed by the ANSI.
advertisement
advertisement

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

Answer: b
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

Answer: b
Explanation: Insertion anomaly is due to confusion in data deletion or insertion.
Sanfoundry Certification Contest of the Month is Live. 100+ Subjects. Participate Now!

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

Answer: a
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

Answer: b
Explanation: Normalization helps in improving the quality of the data.
advertisement

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

Answer: c
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

Answer: d
Explanation: SQL-99 is the most recent version of standard SQL prescribed by the ANSI.
advertisement

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

Answer: c
Explanation: Normalization helps in improving the quality of the data.

Sanfoundry Global Education & Learning Series – Database Management System.

If you find a mistake in question / option / answer, kindly take a screenshot and email to [email protected]

advertisement
advertisement
Subscribe to our Newsletters (Subject-wise). Participate in the Sanfoundry Certification contest to get free Certificate of Merit. Join our social networks below and stay updated with latest contests, videos, internships and jobs!

Youtube | Telegram | LinkedIn | Instagram | Facebook | Twitter | Pinterest
Manish Bhojasia - Founder & CTO at Sanfoundry
Manish Bhojasia, a technology veteran with 20+ years @ Cisco & Wipro, is Founder and CTO at Sanfoundry. He lives in Bangalore, and focuses on development of Linux Kernel, SAN Technologies, Advanced C, Data Structures & Alogrithms. Stay connected with him at LinkedIn.

Subscribe to his free Masterclasses at Youtube & discussions at Telegram SanfoundryClasses.