 |
| Computer Science 12th Chapter 4 - Data Integrity and Normalization Questions Bank |
Computer Science 2nd Year Chapter 4 - Data Integrity and Normalization Solved MCQs, Important Short Questions and Long Questions Bank
MCQs
Please select the right answer.
1. In 3NF, which form of dependency is removed :
2. ___ problems occurs when same information is stored in two different ways :
3. ___ problems occurs when two different names are used for the same information :
4. ___anomalies arise due to transitive dependency :
5. ___problems occurs when same name is used for two different attributes :
6. 3NF, a non-key attribute must not depend on a:
7. A collection of data that consists of name, address and email of a person is called:
8. A foreign key constraint is also called
9. A functional dependency between two or more non-key attributes in a relation is called
10. A process in which it is being ensured that attributes are stored from where they belong
11. A process of analyzing the dependencies of attributes with in entities is called
12. A relation is in 2NF if it is in 1NF and all its non-key attributes are:
13. A relation is in second normal form if and only if :
14. A relation is in third normal form if it is in second normal form and:
15. A report is complete set of field
16. An example of a query is:
17. Data integrity is another form of data
18. Different attributes in two different tables having same name are referred to as
19. Each separate piece of information stored in a record is called:
20. Every relation should have:
21. How many types of data integrity are there :
22. If a relation is in 1NF and the key consists of a single attributes then the relation is called.
23. If the value of a non-key attribute can be obtained simply by knowing the values oF another non-key attribute, the relation is not in :
24. In 3NF, a non-key attribute must not depend on a(n)
25. In which of the following normal forms, any repeating group from the table is removed :
26. Integrity is concerned with the _________ of Data
27. Referential integrity is applied on
28. The ________ constraint states that in a relation no primary key value can have a null value.
29. The 1NF describes the tabular format in which:
30. The attribute on left hand side of arrow is called
31. The attribute on the left side of the arrow in a functional dependency is called:
32. The columns of a table correspond to:
33. The goal of normalization is to:
34. The objective of normalization is to :
35. The process of converting complex data structure into simple and stable data structure is called :
36. Two or more attributes with different names but same meaning create a problem.
37. Which form of dependency is removed for 2NF :
38. which form of dependency is removed n 3NF?
39. Which object is used to retrieve data from database and present in formatted way? Queries
40. Which of the following anomalies result from a transitive dependency?
41. Which of the following database object is used to retrieve data from database?
42. Which of the following is NOT a database object?
43. Which option in MS Access is used to create a new database from scratch?
Short Questions
1. Define normalization.
2. Define partial dependency.
3. Define referential integrity.
4. Define synonym.
5. Differentiate between entity integrity and referential integrity?
6. Differentiate between partial dependency and transitive dependency.
7. How is entity integrity attained?
8. How is referential integrity achieved?
9. What are database anomalies?
10. What do you know about mutual exclusiveness of data?
11. What do you mean by data integrity?
12. What do you mean by redundancy?
13. What is 1st Normal form?
14. What is 2nd Normal form?
15. What is 3rd Normal form?
16. What is a database anomaly?
17. What is a functional dependency?
18. What is a homonym?
19. What is a partial functional dependency?
20. What is a synonym?
21. What is a transitive dependency?
22. What is atomic value?
23. What is database integrity?
24. What is deletion anomaly?
25. What is determinant and determined in functional dependency?
26. What is functional dependency? Give an example.
27. What is insertion anomaly?
28. What is integrity constraint?
29. What is meant by entity integrity?
30. What is modification anomaly?
31. What is mutually exclusive data?
32. What is normalization?
33. What is redundancy?
34. What is redundant information?
35. What is removed when a relation is converted from 1NF to 2NF?
36. What is removed when a relation is converted from 2NF to 3NE?
37. What is repeating group?
38. What is the difference between data integrity and data security.
39. What is transitive dependency?
40. What types of problems may exist in the relations before normalization?
41. When a relation is in first normal form?
42. When does an insertion anomaly occur and what problem it causes?
43. When is a relation in 3NF?
44. When is a relation in second normal form?
45. Why is normalization used?
46. Write three conditions for second normal form.
47. Write three stages to normalize the relations.
48. Write three types of database anomalies.
49. Write two important integrity constraints in relational database.
Long Questions
1. What is data modeling? Also discuss its components / ingredients?
2. What are the different steps involved in analysis stage while designing a database?
3. What are relationships and what are their types?
4. What is cardinality? Explain briefly.