Home/ECAT/ECAT Computer Science Data Integrity and Normalization Test Online

ECAT Computer Science Data Integrity and Normalization Test Online

Mustansar KhanLast Updated: May 1, 2025

ECAT Computer Science Data Integrity and Normalization Test

ECAT Computer Science Chapter 10 Data Integrity and Normalization Online Test

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

ECAT Data Integrity and Normalization Test Online MCQs

Please wait...

Page 1 of 2

Uncategorized

1. Which of these is true about normalization?

It improves data integrity

It ensures unstructured data

It increases redundancy

It decreases consistency

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

Consistent reports

Accurate forecasting

Fast performance

Duplicate or conflicting data

3. What is a composite key?

A foreign key

A single attribute key

A duplicated primary key

A key made up of multiple columns

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

Insert anomaly

Format anomaly

Query anomaly

Join anomaly

5. Which of the following is a partial dependency?

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

A primary key depends on a foreign key

A table with no primary key

A field depends on itself

6. What is a candidate key?

A duplicate column

A key chosen randomly

A foreign key

A possible choice for primary key

7. Which of these is an example of denormalization?

Eliminating transitive dependencies

Adding redundant data to improve performance

Removing all keys

Applying 3NF

8. 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

9. What does a foreign key constraint prevent?

Inserting a value that does not exist in the referenced table

Writing complex queries

Duplicating the primary key

Entering null in any field

10. Which normal form eliminates partial dependency?

1NF

4NF

2NF

3NF

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

UNIQUE

CHECK

DEFAULT

FOREIGN KEY

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

2NF

1NF

3NF

All of the above

13. Which normal form removes transitive dependencies?

2NF

3NF

1NF

BCNF

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

Referential integrity

Relational integrity

Domain integrity

Entity integrity

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

Transitive dependency

Join dependency

Functional dependency

Partial dependency

16. Which constraint enforces referential integrity?

CHECK

DEFAULT

NOT NULL

FOREIGN KEY

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

2NF

4NF

1NF

0NF

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

Attribute

Form

Schema

Redundancy

19. Which is a disadvantage of normalization?

Increased redundancy

Poor data integrity

Slower queries due to joins

Reduced data consistency

20. Which normal form eliminates multi-valued dependencies?

BCNF

4NF

3NF

2NF

21. Which form of normalization removes repeating groups?

1NF

3NF

2NF

BCNF

22. What does the NOT NULL constraint do?

Prevents foreign key violations

Ensures that a column cannot have NULL values

Deletes null values

Prevents duplicates

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

CHECK

DEFAULT

NULL

UNIQUE

24. What is a prime attribute?

A duplicate attribute

An attribute that is part of a candidate key

An attribute that is always NULL

A secondary column

25. What is the main cause of data anomalies?

Indexing

Normalization

Foreign keys

Data redundancy

Page 2 of 2

26. Which of these attributes is derived?

Age (calculated from DOB)

Name

Student ID

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

1NF

2NF

3NF

4NF

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

It ensures atomic values in each cell

It removes transitive dependencies

It removes join dependencies

It allows multi-valued attributes

29. What is data redundancy?

Repetition of data unnecessarily

Structured data retrieval

Efficient data storage

Secure data access

30. Which of the following helps enforce domain integrity?

CHECK

ORDER BY

GROUP BY

HAVING

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

CHECK

Index

Trigger

Backup

32. Which term refers to consistency between related tables?

Entity integrity

Redundancy

Referential integrity

Domain integrity

33. What is a normal form in database design?

A database model

A report format

A type of table

A set of rules to reduce redundancy and anomalies

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

All attributes are text

It has a foreign key

It has no composite keys

It has no partial dependencies

35. Which normal form helps in eliminating join dependency?

3NF

5NF

4NF

1NF

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

Increases storage usage

Improves data integrity

Simplifies maintenance

Reduces data redundancy

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

Update anomaly

Delete anomaly

Access anomaly

Insert anomaly

38. What does entity integrity ensure?

Consistent foreign keys

No two rows are identical

Valid ranges for data

No NULL in a primary key

39. What is a delete anomaly?

Data that cannot be updated

Data that is accidentally inserted

Unintended loss of data due to deletion

Duplicate data being deleted

40. Normalization is mainly used to:

Increase speed of reports

Replace indexes

Increase data visualization

Minimize duplication and ensure logical storage

41. Which is an advantage of denormalization?

Improved query performance

Slower insert operations

Increased redundancy

Reduced data consistency

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

CHECK

NOT NULL

FOREIGN KEY

UNIQUE

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

2NF

1NF

BCNF

3NF

44. Which SQL keyword can help maintain entity integrity?

PRIMARY KEY

CHECK

FOREIGN KEY

INDEX

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

Structural integrity

Referential integrity

Domain integrity

Entity integrity

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

Less redundancy

Fewer anomalies

Faster queries in all cases

Better data consistency

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

Values must follow a specific data type and range

Values must exist in another table

Values must be non-null

Values must be unique

48. What is a transitive dependency?

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

When a field is dependent on two fields

When a field is independent of the key

When all fields depend on each other

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

Data redundancy

Data integrity

Data backup

Data replication

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

UET Peshawar Entry Test 2025 Registration Online ETEA Test D...
ECAT Statistics Test Set 17
ECAT Statistics Test Set 16
ECAT Statistics Test Set 15
ECAT Statistics Test Set 14
ECAT Statistics Test Set 13
ECAT Statistics Test Set 12
ECAT Statistics Test Set 11
ECAT Statistics Test Set 10
ECAT Statistics Test Set 9

Mustansar KhanLast Updated: May 1, 2025

Facebook Twitter Reddit WhatsApp Share via Email Print

ECAT Computer Science Data Integrity and Normalization Test Online

ECAT Computer Science Data Integrity and Normalization Test

ECAT Computer Science Chapter 10 Data Integrity and Normalization Online Test

ECAT Data Integrity and Normalization Test Online MCQs

Uncategorized

You Might Also Like

Mustansar Khan

Leave a Reply Cancel reply

ECAT Computer Science Data Integrity and Normalization Test

ECAT Computer Science Chapter 10 Data Integrity and Normalization Online Test

ECAT Data Integrity and Normalization Test Online MCQs

Uncategorized

You Might Also Like

Mustansar Khan

Your Related

ECAT English Active and Passive Voice 1 Online Test

ECAT Physics Motion and Force 2 Online Test

ECAT English Antonyms 6 Online Test

ECAT Physics Optical Instruments 2 Test Online

ECAT Computer Science Basics of Information Technology Test Online

ECAT Chemistry Aromatic Hydrocarbons Test Online

Leave a Reply Cancel reply