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

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

It removes transitive dependencies

It allows multi-valued attributes

It removes join dependencies

It ensures atomic values in each cell

3. What is a composite key?

A single attribute key

A duplicated primary key

A foreign key

A key made up of multiple columns

4. Which normal form eliminates multi-valued dependencies?

4NF

BCNF

3NF

2NF

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

Referential integrity

Relational integrity

Domain integrity

Entity integrity

6. What is the purpose of normalization in databases?

To reduce complexity

To create duplicate data

To eliminate data redundancy and anomalies

To speed up data entry

7. What does the NOT NULL constraint do?

Ensures that a column cannot have NULL values

Prevents foreign key violations

Prevents duplicates

Deletes null values

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

UNIQUE

DEFAULT

NULL

CHECK

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

Consistent reports

Duplicate or conflicting data

Accurate forecasting

Fast performance

10. Which form of normalization removes repeating groups?

1NF

BCNF

2NF

3NF

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

Values must be non-null

Values must follow a specific data type and range

Values must exist in another table

Values must be unique

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

3NF

1NF

BCNF

2NF

13. Normalization is mainly used to:

Replace indexes

Increase data visualization

Minimize duplication and ensure logical storage

Increase speed of reports

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

Insert anomaly

Delete anomaly

Update anomaly

Access anomaly

15. What is a delete anomaly?

Duplicate data being deleted

Data that cannot be updated

Data that is accidentally inserted

Unintended loss of data due to deletion

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

Structural integrity

Referential integrity

Entity integrity

Domain integrity

17. What is data redundancy?

Structured data retrieval

Efficient data storage

Secure data access

Repetition of data unnecessarily

18. Which normal form removes transitive dependencies?

2NF

3NF

BCNF

1NF

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

Data redundancy

Data replication

Data backup

Data integrity

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

Transitive dependency

Functional dependency

Partial dependency

Join dependency

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

Join anomaly

Insert anomaly

Query anomaly

Format anomaly

22. Which of these is true about normalization?

It ensures unstructured data

It decreases consistency

It improves data integrity

It increases redundancy

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

0NF

4NF

2NF

1NF

24. Which is an advantage of denormalization?

Slower insert operations

Reduced data consistency

Improved query performance

Increased redundancy

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

UNIQUE

DEFAULT

CHECK

FOREIGN KEY

Page 2 of 2

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

CHECK

NOT NULL

FOREIGN KEY

UNIQUE

27. Which is a disadvantage of normalization?

Increased redundancy

Poor data integrity

Slower queries due to joins

Reduced data consistency

28. What is a transitive dependency?

When all fields depend on each other

When a field is independent of the key

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

When a field is dependent on two fields

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

Simplifies maintenance

Improves data integrity

Increases storage usage

Reduces data redundancy

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

1NF

3NF

2NF

All of the above

31. What is a prime attribute?

An attribute that is always NULL

An attribute that is part of a candidate key

A duplicate attribute

A secondary column

32. Which of these is an example of denormalization?

Adding redundant data to improve performance

Eliminating transitive dependencies

Applying 3NF

Removing all keys

33. Which of the following helps enforce domain integrity?

HAVING

ORDER BY

GROUP BY

CHECK

34. What does entity integrity ensure?

Valid ranges for data

Consistent foreign keys

No two rows are identical

No NULL in a primary key

35. Which SQL keyword can help maintain entity integrity?

PRIMARY KEY

CHECK

FOREIGN KEY

INDEX

36. What is the main cause of data anomalies?

Indexing

Normalization

Foreign keys

Data redundancy

37. Which term refers to consistency between related tables?

Domain integrity

Redundancy

Entity integrity

Referential integrity

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

Trigger

Index

Backup

CHECK

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

Fewer anomalies

Better data consistency

Less redundancy

Faster queries in all cases

40. What is a candidate key?

A possible choice for primary key

A foreign key

A duplicate column

A key chosen randomly

41. Which normal form helps in eliminating join dependency?

4NF

1NF

5NF

3NF

42. Which of these attributes is derived?

Age (calculated from DOB)

Name

Student ID

43. What is a normal form in database design?

A type of table

A report format

A database model

A set of rules to reduce redundancy and anomalies

44. Which constraint enforces referential integrity?

CHECK

NOT NULL

DEFAULT

FOREIGN KEY

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

Form

Redundancy

Attribute

Schema

46. Which of the following is a partial dependency?

A table with no primary key

A primary key depends on a foreign key

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

A field depends on itself

47. What does a foreign key constraint prevent?

Duplicating the primary key

Inserting a value that does not exist in the referenced table

Entering null in any field

Writing complex queries

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

1NF

2NF

3NF

4NF

49. Which normal form eliminates partial dependency?

3NF

2NF

4NF

1NF

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