Home/Computer/Computer Data Integrity and Normalization Test Online

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. Which of the following is used to ensure unique values in a column?

NULL

CHECK

UNIQUE

DEFAULT

2. Which term refers to consistency between related tables?

Entity integrity

Domain integrity

Referential integrity

Redundancy

3. Which normal form eliminates partial dependency?

3NF

2NF

1NF

4NF

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

0NF

1NF

2NF

4NF

5. What is the purpose of normalization in databases?

To create duplicate data

To reduce complexity

To speed up data entry

To eliminate data redundancy and anomalies

6. Which is an advantage of denormalization?

Improved query performance

Reduced data consistency

Increased redundancy

Slower insert operations

7. Which constraint enforces referential integrity?

NOT NULL

DEFAULT

CHECK

FOREIGN KEY

8. What is the main cause of data anomalies?

Foreign keys

Normalization

Indexing

Data redundancy

9. Normalization is mainly used to:

Increase speed of reports

Replace indexes

Minimize duplication and ensure logical storage

Increase data visualization

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

It has no partial dependencies

It has no composite keys

All attributes are text

It has a foreign key

11. Which is a disadvantage of normalization?

Reduced data consistency

Increased redundancy

Slower queries due to joins

Poor data integrity

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

Trigger

CHECK

Index

Backup

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

Entity integrity

Relational integrity

Domain integrity

Referential integrity

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

Data backup

Data integrity

Data redundancy

Data replication

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

Increases storage usage

Reduces data redundancy

Improves data integrity

Simplifies maintenance

16. Which of these attributes is derived?

Student ID

Age (calculated from DOB)

Name

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

1NF

2NF

3NF

4NF

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

Fewer anomalies

Less redundancy

Better data consistency

Faster queries in all cases

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

Format anomaly

Query anomaly

Insert anomaly

Join anomaly

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

Duplicate or conflicting data

Consistent reports

Accurate forecasting

Fast performance

21. What does entity integrity ensure?

Consistent foreign keys

No NULL in a primary key

No two rows are identical

Valid ranges for data

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

Entity integrity

Structural integrity

Referential integrity

Domain integrity

23. What is data redundancy?

Repetition of data unnecessarily

Structured data retrieval

Efficient data storage

Secure data access

24. Which of the following helps enforce domain integrity?

HAVING

GROUP BY

CHECK

ORDER BY

25. What is a normal form in database design?

A report format

A database model

A type of table

A set of rules to reduce redundancy and anomalies

Page 2 of 2

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

Values must be unique

Values must follow a specific data type and range

Values must exist in another table

Values must be non-null

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

UNIQUE

CHECK

FOREIGN KEY

DEFAULT

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

1NF

3NF

BCNF

2NF

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

Update anomaly

Access anomaly

Delete anomaly

Insert anomaly

30. What does a foreign key constraint prevent?

Duplicating the primary key

Inserting a value that does not exist in the referenced table

Writing complex queries

Entering null in any field

31. What is a delete anomaly?

Unintended loss of data due to deletion

Duplicate data being deleted

Data that cannot be updated

Data that is accidentally inserted

32. 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 a field is dependent on two fields

When all fields depend on each other

33. What is a candidate key?

A key chosen randomly

A possible choice for primary key

A foreign key

A duplicate column

34. What is a composite key?

A key made up of multiple columns

A foreign key

A duplicated primary key

A single attribute key

35. What is a prime attribute?

An attribute that is always NULL

A secondary column

An attribute that is part of a candidate key

A duplicate attribute

36. Which SQL keyword can help maintain entity integrity?

CHECK

INDEX

PRIMARY KEY

FOREIGN KEY

37. Which form of normalization removes repeating groups?

3NF

1NF

BCNF

2NF

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

1NF

3NF

2NF

All of the above

39. What does the NOT NULL constraint do?

Prevents foreign key violations

Ensures that a column cannot have NULL values

Prevents duplicates

Deletes null values

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

It removes join dependencies

It removes transitive dependencies

It allows multi-valued attributes

It ensures atomic values in each cell

41. Which of these is an example of denormalization?

Eliminating transitive dependencies

Applying 3NF

Removing all keys

Adding redundant data to improve performance

42. Which of these is true about normalization?

It decreases consistency

It ensures unstructured data

It improves data integrity

It increases redundancy

43. Which normal form removes transitive dependencies?

3NF

BCNF

2NF

1NF

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

Functional dependency

Transitive dependency

Join dependency

Partial dependency

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

CHECK

NOT NULL

FOREIGN KEY

UNIQUE

46. Which of the following is a partial dependency?

A primary key depends on a foreign key

A table with no primary key

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

A field depends on itself

47. Which normal form eliminates multi-valued dependencies?

2NF

3NF

BCNF

4NF

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

Redundancy

Schema

Attribute

Form

49. Which normal form helps in eliminating join dependency?

3NF

5NF

4NF

1NF

You Can Learn and Gain more Knowledge through our Online Quiz and Testing system Just Search your desired Preparation subject at Gotest.

Introduction to Computers Online Test
Computer File Handling in “C” Test Online
Computer Functions in “C” Test Online
Computer Loop Constructs Test Online
Computer Decision Constructs Test Online
Computer Input Output Test Online
Computer Elements of “C” Test Online
Computer Getting Started with “C” Test Online
Computer Microsoft Access-Forms and Reports Test Online
Computer Table and Query Test Online

Mustansar KhanLast Updated: October 15, 2025

Computer Data Integrity and Normalization Test Online

Important Data Integrity and Normalization Question and Answer

Data Integrity and Normalization Practice Test Online With Explanation

Uncategorized

Related Posts

Mustansar Khan

Leave a Reply Cancel reply