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. What type of dependency is A → B, B → C implies A → C?

Transitive dependency

Partial dependency

Functional dependency

Join dependency

2. Which term refers to consistency between related tables?

Redundancy

Domain integrity

Entity integrity

Referential integrity

3. Which is a disadvantage of normalization?

Poor data integrity

Slower queries due to joins

Reduced data consistency

Increased redundancy

4. Which form of normalization removes repeating groups?

2NF

BCNF

1NF

3NF

5. Which of these is an example of denormalization?

Removing all keys

Adding redundant data to improve performance

Applying 3NF

Eliminating transitive dependencies

6. Which SQL keyword can help maintain entity integrity?

INDEX

PRIMARY KEY

FOREIGN KEY

CHECK

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

Values must follow a specific data type and range

Values must be non-null

Values must be unique

Values must exist in another table

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

Domain integrity

Relational integrity

Entity integrity

Referential integrity

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

UNIQUE

FOREIGN KEY

NOT NULL

CHECK

10. Which of the following helps enforce domain integrity?

GROUP BY

ORDER BY

CHECK

HAVING

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

2NF

3NF

1NF

All of the above

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

Schema

Form

Attribute

Redundancy

13. Which normal form removes transitive dependencies?

1NF

BCNF

3NF

2NF

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

15. What does the NOT NULL constraint do?

Prevents foreign key violations

Prevents duplicates

Deletes null values

Ensures that a column cannot have NULL values

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

Data integrity

Data redundancy

Data backup

Data replication

17. Which normal form eliminates multi-valued dependencies?

4NF

3NF

BCNF

2NF

18. What is data redundancy?

Secure data access

Efficient data storage

Repetition of data unnecessarily

Structured data retrieval

19. What is a normal form in database design?

A type of table

A database model

A report format

A set of rules to reduce redundancy and anomalies

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

FOREIGN KEY

DEFAULT

UNIQUE

CHECK

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. In which normal form is a relation if it is free from transitive and partial dependencies?

3NF

2NF

4NF

1NF

23. What is a prime attribute?

A duplicate attribute

A secondary column

An attribute that is part of a candidate key

An attribute that is always NULL

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

It allows multi-valued attributes

It removes transitive dependencies

It removes join dependencies

It ensures atomic values in each cell

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

Faster queries in all cases

Less redundancy

Better data consistency

Fewer anomalies

Page 2 of 2

26. Which normal form helps in eliminating join dependency?

4NF

5NF

1NF

3NF

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

It has no composite keys

It has no partial dependencies

It has a foreign key

All attributes are text

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

Fast performance

Consistent reports

Accurate forecasting

Duplicate or conflicting data

29. Which of these attributes is derived?

Age (calculated from DOB)

Student ID

Name

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

Increases storage usage

Simplifies maintenance

Improves data integrity

Reduces data redundancy

31. Which of these is true about normalization?

It ensures unstructured data

It decreases consistency

It improves data integrity

It increases redundancy

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

Trigger

Index

CHECK

Backup

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

1NF

2NF

4NF

0NF

34. Which is an advantage of denormalization?

Increased redundancy

Slower insert operations

Reduced data consistency

Improved query performance

35. What is a transitive dependency?

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

When all fields depend on each other

When a field is dependent on two fields

When a field is independent of the key

36. Which normal form eliminates partial dependency?

4NF

1NF

2NF

3NF

37. What is a candidate key?

A duplicate column

A key chosen randomly

A foreign key

A possible choice for primary key

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

39. What does a foreign key constraint prevent?

Entering null in any field

Inserting a value that does not exist in the referenced table

Duplicating the primary key

Writing complex queries

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

Format anomaly

Insert anomaly

Query anomaly

Join anomaly

41. What is a composite key?

A single attribute key

A foreign key

A key made up of multiple columns

A duplicated primary key

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

Insert anomaly

Update anomaly

Delete anomaly

Access anomaly

43. What is the main cause of data anomalies?

Data redundancy

Normalization

Indexing

Foreign keys

44. What is the purpose of normalization in databases?

To speed up data entry

To eliminate data redundancy and anomalies

To create duplicate data

To reduce complexity

45. Which constraint enforces referential integrity?

NOT NULL

DEFAULT

CHECK

FOREIGN KEY

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

CHECK

UNIQUE

NULL

DEFAULT

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

Domain integrity

Referential integrity

Structural integrity

Entity integrity

48. Normalization is mainly used to:

Replace indexes

Increase speed of reports

Increase data visualization

Minimize duplication and ensure logical storage

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

BCNF

3NF

1NF

2NF

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 Chemistry Chemical Equilibrium Test Online

ECAT English Vocabulary 1 Online Test

ECAT Computer Science Spreadsheet Software Test Online

ECAT English Vocabulary 7 Test Online

ECAT English Spotting Errors 6 Online Test

ECAT Statistics Test Set 1

Leave a Reply Cancel reply