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 forms ensures that every determinant is a candidate key?

2NF

BCNF

1NF

3NF

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

Data backup

Data redundancy

Data replication

Data integrity

3. Which term refers to consistency between related tables?

Redundancy

Domain integrity

Entity integrity

Referential integrity

4. What is a transitive dependency?

When a field is dependent on two fields

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

When all fields depend on each other

When a field is independent of the key

5. Which of these is true about normalization?

It ensures unstructured data

It increases redundancy

It improves data integrity

It decreases consistency

6. Which constraint enforces referential integrity?

NOT NULL

CHECK

FOREIGN KEY

DEFAULT

7. Which normal form eliminates multi-valued dependencies?

BCNF

3NF

2NF

4NF

8. Normalization is mainly used to:

Minimize duplication and ensure logical storage

Replace indexes

Increase speed of reports

Increase data visualization

9. Which of these is an example of denormalization?

Eliminating transitive dependencies

Removing all keys

Adding redundant data to improve performance

Applying 3NF

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

All of the above

1NF

2NF

3NF

11. What does a foreign key constraint prevent?

Inserting a value that does not exist in the referenced table

Duplicating the primary key

Writing complex queries

Entering null in any field

12. What is a normal form in database design?

A database model

A report format

A set of rules to reduce redundancy and anomalies

A type of table

13. What is a prime attribute?

An attribute that is part of a candidate key

An attribute that is always NULL

A duplicate attribute

A secondary column

14. Which SQL keyword can help maintain entity integrity?

PRIMARY KEY

CHECK

FOREIGN KEY

INDEX

15. What is data redundancy?

Secure data access

Repetition of data unnecessarily

Structured data retrieval

Efficient data storage

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

Insert anomaly

Delete anomaly

Access anomaly

Update anomaly

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

2NF

4NF

1NF

3NF

18. Which is a disadvantage of normalization?

Slower queries due to joins

Poor data integrity

Increased redundancy

Reduced data consistency

19. What does the NOT NULL constraint do?

Prevents foreign key violations

Prevents duplicates

Ensures that a column cannot have NULL values

Deletes null values

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

NOT NULL

FOREIGN KEY

CHECK

UNIQUE

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

Backup

CHECK

Index

Trigger

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

Insert anomaly

Query anomaly

Format anomaly

Join anomaly

23. What does entity integrity ensure?

Consistent foreign keys

No two rows are identical

Valid ranges for data

No NULL in a primary key

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

NULL

UNIQUE

CHECK

DEFAULT

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

Schema

Redundancy

Attribute

Form

Page 2 of 2

26. Which form of normalization removes repeating groups?

3NF

1NF

2NF

BCNF

27. What is a candidate key?

A possible choice for primary key

A foreign key

A key chosen randomly

A duplicate column

28. Which of the following is a partial dependency?

A field depends on itself

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

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

It has no partial dependencies

It has a foreign key

It has no composite keys

All attributes are text

30. Which normal form eliminates partial dependency?

2NF

3NF

1NF

4NF

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

Duplicate or conflicting data

Fast performance

Consistent reports

Accurate forecasting

32. Which normal form removes transitive dependencies?

2NF

3NF

1NF

BCNF

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

Increases storage usage

Simplifies maintenance

Reduces data redundancy

Improves data integrity

34. What is the purpose of normalization in databases?

To create duplicate data

To speed up data entry

To eliminate data redundancy and anomalies

To reduce complexity

35. Which is an advantage of denormalization?

Reduced data consistency

Slower insert operations

Improved query performance

Increased redundancy

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

Values must exist in another table

Values must be non-null

Values must be unique

Values must follow a specific data type and range

37. What is a delete anomaly?

Duplicate data being deleted

Unintended loss of data due to deletion

Data that cannot be updated

Data that is accidentally inserted

38. Which of these attributes is derived?

Age (calculated from DOB)

Student ID

Name

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

Referential integrity

Domain integrity

Entity integrity

Relational integrity

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

Faster queries in all cases

Better data consistency

Fewer anomalies

Less redundancy

41. What is the main cause of data anomalies?

Indexing

Foreign keys

Normalization

Data redundancy

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

UNIQUE

FOREIGN KEY

CHECK

DEFAULT

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

Partial dependency

Join dependency

Functional dependency

Transitive dependency

44. Which of the following helps enforce domain integrity?

CHECK

GROUP BY

ORDER BY

HAVING

45. What is a composite key?

A single attribute key

A foreign key

A duplicated primary key

A key made up of multiple columns

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

1NF

2NF

4NF

0NF

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

Structural integrity

Entity integrity

Referential integrity

Domain integrity

48. Which normal form helps in eliminating join dependency?

3NF

4NF

5NF

1NF

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

It removes join dependencies

It ensures atomic values in each cell

It allows multi-valued attributes

It removes transitive dependencies

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 Computer Science Fundamentals of Internet Test Online

UET Lahore, Taxila ECAT Chemistry Entry Test Online Preparation

ECAT Statistics Test Set 15

ECAT Computer Science Table and Query Test Online

ECAT Chemistry Liquids Test Online

ECAT Chemistry Alcohols Phenols And Ethers Test Online

Leave a Reply Cancel reply