Computer Data Integrity and Normalization Test Online

Mustansar KhanLast Updated: October 15, 2025

Important Data Integrity and Normalization Question and Answer

Total Questions:	50
Time Allowed:	25 Minutes
Total Marks:	50
How to Attempt Test:	Please choose the right Option in MCQ-type question.
Test Helpful For:	ECAT Entry Test Computer Online Test Interview Questions about Computer All Universities Entrance Test Recruitments Tests

Data Integrity and Normalization Practice Test Online With Explanation

Please wait...

Page 1 of 2

Uncategorized

1. What is a transitive dependency?

When a non-key attribute depends on another non-key attribute

When a field is independent of the key

When all fields depend on each other

When a field is dependent on two fields

2. Which of the following anomalies occurs when updating one record requires updating multiple rows?

Update anomaly

Delete anomaly

Insert anomaly

Access anomaly

3. Which of these is an example of denormalization?

Removing all keys

Applying 3NF

Adding redundant data to improve performance

Eliminating transitive dependencies

4. Which of the following is not a feature of a normalized database?

Faster queries in all cases

Better data consistency

Less redundancy

Fewer anomalies

5. What does the NOT NULL constraint do?

Ensures that a column cannot have NULL values

Prevents duplicates

Deletes null values

Prevents foreign key violations

6. Which of the following is not an integrity rule in databases?

Entity integrity

Relational integrity

Referential integrity

Domain integrity

7. Which of the following is used to define rules for valid values in a column?

DEFAULT

CHECK

UNIQUE

FOREIGN KEY

8. What is the main cause of data anomalies?

Data redundancy

Foreign keys

Normalization

Indexing

9. What type of dependency is A → B, B → C implies A → C?

Join dependency

Functional dependency

Partial dependency

Transitive dependency

10. Which of these forms ensures that every determinant is a candidate key?

BCNF

1NF

3NF

2NF

11. Which normal form removes transitive dependencies?

2NF

3NF

BCNF

1NF

12. Which normal form eliminates partial dependency?

3NF

2NF

1NF

4NF

13. What is data redundancy?

Structured data retrieval

Repetition of data unnecessarily

Efficient data storage

Secure data access

14. Which of the following helps enforce domain integrity?

HAVING

GROUP BY

ORDER BY

CHECK

15. Which SQL keyword can help maintain entity integrity?

CHECK

INDEX

PRIMARY KEY

FOREIGN KEY

16. Which term refers to consistency between related tables?

Domain integrity

Redundancy

Referential integrity

Entity integrity

17. Which of these is true about normalization?

It increases redundancy

It improves data integrity

It ensures unstructured data

It decreases consistency

18. Which normal form eliminates multi-valued dependencies?

3NF

2NF

BCNF

4NF

19. What is a prime attribute?

A duplicate attribute

An attribute that is part of a candidate key

A secondary column

An attribute that is always NULL

20. What is a normal form in database design?

A set of rules to reduce redundancy and anomalies

A database model

A report format

A type of table

21. Which of the following is a form of integrity constraint?

Trigger

CHECK

Backup

Index

22. What is a delete anomaly?

Unintended loss of data due to deletion

Data that is accidentally inserted

Data that cannot be updated

Duplicate data being deleted

23. Which of the following is used to ensure unique values in a column?

CHECK

UNIQUE

NULL

DEFAULT

24. Which of these can be violated if foreign keys are not properly maintained?

Referential integrity

Entity integrity

Domain integrity

Structural integrity

25. Which of the following is a domain integrity rule?

Values must exist in another table

Values must be unique

Values must be non-null

Values must follow a specific data type and range

Page 2 of 2

26. Which normal form helps in eliminating join dependency?

5NF

4NF

1NF

3NF

27. Which of these terms refers to meaningful grouping of data in a database?

Form

Schema

Attribute

Redundancy

28. Which of the following is a higher normal form beyond 3NF?

1NF

4NF

0NF

2NF

29. Which is an advantage of denormalization?

Reduced data consistency

Slower insert operations

Improved query performance

Increased redundancy

30. Which is a disadvantage of normalization?

Reduced data consistency

Poor data integrity

Slower queries due to joins

Increased redundancy

31. What does a foreign key constraint prevent?

Writing complex queries

Duplicating the primary key

Entering null in any field

Inserting a value that does not exist in the referenced table

32. Which of the following is a partial dependency?

A table with no primary key

A primary key depends on a foreign key

A field depends on itself

A non-prime attribute depends on part of a composite key

33. What is the purpose of normalization in databases?

To reduce complexity

To create duplicate data

To speed up data entry

To eliminate data redundancy and anomalies

34. A relation is in 2NF if it is in 1NF and:

It has a foreign key

It has no composite keys

All attributes are text

It has no partial dependencies

35. Which of the following would result from a lack of data integrity?

Duplicate or conflicting data

Accurate forecasting

Consistent reports

Fast performance

36. In which normal form is a relation if it is free from transitive and partial dependencies?

2NF

4NF

3NF

1NF

37. Which of these attributes is derived?

Student ID

Age (calculated from DOB)

Name

38. Normalization is mainly used to:

Increase data visualization

Increase speed of reports

Replace indexes

Minimize duplication and ensure logical storage

39. Which of the following ensures the accuracy and consistency of data over its lifecycle?

Data integrity

Data backup

Data redundancy

Data replication

40. Which normal form is based on the concept of functional dependency?

All of the above

1NF

3NF

2NF

41. Which of the following constraints ensures that no two rows have the same value in a column?

FOREIGN KEY

NOT NULL

CHECK

UNIQUE

42. Which of the following is not a benefit of normalization?

Increases storage usage

Simplifies maintenance

Reduces data redundancy

Improves data integrity

43. What is a composite key?

A key made up of multiple columns

A foreign key

A duplicated primary key

A single attribute key

44. What does entity integrity ensure?

Valid ranges for data

No NULL in a primary key

Consistent foreign keys

No two rows are identical

45. Which of the following is true for 1NF?

It ensures atomic values in each cell

It removes join dependencies

It allows multi-valued attributes

It removes transitive dependencies

46. What is a candidate key?

A possible choice for primary key

A key chosen randomly

A foreign key

A duplicate column

47. Which of the following is a type of data anomaly?

Format anomaly

Query anomaly

Insert anomaly

Join anomaly

48. Which form of normalization removes repeating groups?

2NF

3NF

1NF

BCNF

49. Which constraint enforces referential integrity?

CHECK

NOT NULL

DEFAULT

FOREIGN KEY

Can't find what you're looking for? Search below:

Latest Updates

Windows 10 Shortcut Keys Test Online
Important Internet Basic Info Test Online
Computer Network Skills Test 8 Online
MS Windows XP Basic Info Test Online
Computer Network Skills Test 6 Online
CCNA Mcqs Test Online
Android Mcqs Test Online
Internet Explorer Shortcut Keys Test Online

Mustansar KhanLast Updated: October 15, 2025

Important Data Integrity and Normalization Question and Answer

Data Integrity and Normalization Practice Test Online With Explanation

Uncategorized

Latest Updates

Mustansar Khan

Leave a Reply Cancel reply