2nd Year Computer Science Chapter 4 Data Integrity and Normalization Notes MCQs Bank

computer 12th notes chapter No 4

1. Integrity is concerned with the _________ of Data 

 
 
 
 

2. ___anomalies arise due to transitive dependency :

 
 
 
 

3. In 3NF, which form of dependency is removed : 

 
 
 
 

4. A functional dependency between two or more non-key attributes in a relation is  called 

 
 
 
 

5. The 1NF describes the tabular format in which:

 
 
 
 

6. The attribute on the left side of the arrow in a functional dependency is called:

 
 
 
 

7. In which of the following normal forms, any repeating group from the table is  removed : 

 
 
 
 

8. ___ problems occurs when two different names are used for the same  information : 

 
 
 
 

9. Each separate piece of information stored in a record is called:

 
 
 
 

10. Which of the following anomalies result from a transitive dependency? 

 
 
 
 

11. A report is complete set of field

 
 
 
 

12. ___     problems occurs when same information is stored in two different ways :

 
 
 
 

13. The attribute on left hand side of arrow is called 

 
 
 
 

14. The goal of normalization is to:

 
 
 
 

15. 3NF, a non-key attribute must not depend on a:

 
 
 
 

16. The objective of normalization is to :

 
 
 
 

17. A relation is in 2NF if it is in 1NF and all its non-key attributes are:

 
 
 
 

18. Different attributes in two different tables having same name are referred to as

 
 
 
 

19. A process of analyzing the dependencies of attributes with in entities is called

 
 
 
 

20. A collection of data that consists of name, address and email of a person is called:

 
 
 
 

21. A relation is in third normal form if it is in second normal form and:

 
 
 
 

22. How many types of data integrity are there :

 
 
 
 

23. A foreign key constraint is also called 

 
 
 
 

24. An example of a query is:

 
 
 
 

25. Which option in MS Access is used to create a new database from scratch?

 
 
 
 

26. Referential integrity is applied on 

 
 
 
 

27. Two or more attributes with different names but same meaning create a problem.

 
 
 
 

28. In 3NF, a non-key attribute must not depend on a(n) 

 
 
 
 

29. Every relation should have:

 
 
 
 

30. Which form of dependency is removed for 2NF : 

 
 
 
 

31. Which object is used to retrieve data from database and present in formatted way? Queries

 
 
 
 

32. If a relation is in 1NF and the key consists of a single attributes then the relation is  called.

 
 
 
 

33. ___problems occurs when same name is used for two different attributes :

 
 
 
 

34. The process of converting complex data structure into simple and stable data  structure is called :

 
 
 
 

35. The columns of a table correspond to:

 
 
 
 

36. which form of dependency is removed n 3NF?

 
 
 
 

37. A relation is in second normal form if and only if : 

 
 
 
 

38. The ________ constraint states that in a relation no primary key value can have a  null value. 

 
 
 
 

39. Which of the following is NOT a database object?

 
 
 
 

40. Which of the following database object is used to retrieve data from database?

 
 
 
 

41. 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 :

 
 
 
 

42. A process in which it is being ensured that attributes are stored from where they belong 

 
 
 
 

43. Data integrity is another form of data 

 
 
 
 

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. Define Normalization and different steps involved in it.
2. When a relation is in Second Normal Form? Explain with the help of an example.
3. What is data integrity? Also discuss its two types.
4. Explain the difference between data integrity and data security.
5. Define the terms Synonyms, Homonyms, Redundant information and mutually exclusive data.
6. What are database anomalies? Briefly discuss insertion deletion and modification anomalies.
7. When a relation is in First Normal Form? Explain with the help of an example.
8. When a relation is in Third Normal Form? Explain with the help of an example.
9. Write a note on functional dependency.

Leave a Reply

Your email address will not be published. Required fields are marked *