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

CHECK

NULL

UNIQUE

DEFAULT

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

Transitive dependency

Functional dependency

Partial dependency

Join dependency

3. What is the purpose of normalization in databases?

To eliminate data redundancy and anomalies

To create duplicate data

To speed up data entry

To reduce complexity

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

Values must follow a specific data type and range

Values must be unique

Values must exist in another table

Values must be non-null

5. What is a candidate key?

A foreign key

A key chosen randomly

A duplicate column

A possible choice for primary key

6. Which normal form eliminates multi-valued dependencies?

4NF

3NF

BCNF

2NF

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

Referential integrity

Relational integrity

Domain integrity

Entity integrity

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

9. Which normal form removes transitive dependencies?

2NF

3NF

BCNF

1NF

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

UNIQUE

DEFAULT

CHECK

FOREIGN KEY

11. Which of these is true about normalization?

It increases redundancy

It improves data integrity

It ensures unstructured data

It decreases consistency

12. Which normal form helps in eliminating join dependency?

3NF

1NF

5NF

4NF

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

Trigger

CHECK

Backup

Index

14. What is data redundancy?

Secure data access

Efficient data storage

Repetition of data unnecessarily

Structured data retrieval

15. Which is a disadvantage of normalization?

Reduced data consistency

Poor data integrity

Slower queries due to joins

Increased redundancy

16. What does entity integrity ensure?

Consistent foreign keys

No NULL in a primary key

No two rows are identical

Valid ranges for data

17. What does the NOT NULL constraint do?

Prevents foreign key violations

Ensures that a column cannot have NULL values

Prevents duplicates

Deletes null values

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

4NF

3NF

1NF

2NF

19. Which is an advantage of denormalization?

Increased redundancy

Improved query performance

Slower insert operations

Reduced data consistency

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

Insert anomaly

Delete anomaly

Access anomaly

Update anomaly

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

Better data consistency

Faster queries in all cases

Less redundancy

Fewer anomalies

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

Increases storage usage

Reduces data redundancy

Improves data integrity

Simplifies maintenance

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

Attribute

Form

Schema

Redundancy

24. Which normal form eliminates partial dependency?

3NF

4NF

1NF

2NF

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

NOT NULL

CHECK

UNIQUE

FOREIGN KEY

Page 2 of 2

26. What is the main cause of data anomalies?

Indexing

Data redundancy

Foreign keys

Normalization

27. What is a normal form in database design?

A set of rules to reduce redundancy and anomalies

A report format

A type of table

A database model

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

Join anomaly

Query anomaly

Insert anomaly

Format anomaly

29. Which of the following is a partial dependency?

A field depends on itself

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

A table with no primary key

A primary key depends on a foreign key

30. Which SQL keyword can help maintain entity integrity?

INDEX

FOREIGN KEY

CHECK

PRIMARY KEY

31. Which of the following helps enforce domain integrity?

HAVING

ORDER BY

CHECK

GROUP BY

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

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

Domain integrity

Structural integrity

Referential integrity

Entity integrity

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

Data backup

Data integrity

Data redundancy

Data replication

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

Accurate forecasting

Fast performance

Consistent reports

Duplicate or conflicting data

36. Which of these attributes is derived?

Name

Age (calculated from DOB)

Student ID

37. Which constraint enforces referential integrity?

DEFAULT

CHECK

NOT NULL

FOREIGN KEY

38. What does a foreign key constraint prevent?

Writing complex queries

Duplicating the primary key

Inserting a value that does not exist in the referenced table

Entering null in any field

39. What is a prime attribute?

An attribute that is always NULL

An attribute that is part of a candidate key

A secondary column

A duplicate attribute

40. Which term refers to consistency between related tables?

Entity integrity

Domain integrity

Redundancy

Referential integrity

41. What is a composite key?

A single attribute key

A duplicated primary key

A foreign key

A key made up of multiple columns

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

2NF

3NF

BCNF

1NF

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

0NF

1NF

2NF

4NF

44. What is a transitive dependency?

When a field is dependent on two fields

When all fields depend on each other

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

When a field is independent of the key

45. Which form of normalization removes repeating groups?

3NF

2NF

BCNF

1NF

46. Normalization is mainly used to:

Increase data visualization

Replace indexes

Increase speed of reports

Minimize duplication and ensure logical storage

47. Which of these is an example of denormalization?

Eliminating transitive dependencies

Removing all keys

Adding redundant data to improve performance

Applying 3NF

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

1NF

3NF

All of the above

2NF

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

It has a foreign key

It has no partial dependencies

All attributes are text

It has no composite keys

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 Physics Measurements Test Online

UET Lahore, Taxila ECAT Maths Entry Test Online Preparation

ECAT English Prepositions 1 Online Test

Quaid-e-Azam University QAU Nawab Shah ECAT Maths Entry Test Preparation Online

ECAT Computer Loop Constructs Test Online

ECAT Computer Elements of “C” Test Online

Leave a Reply Cancel reply