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 SQL keyword can help maintain entity integrity?

PRIMARY KEY

INDEX

FOREIGN KEY

CHECK

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

1NF

3NF

All of the above

2NF

3. Which of the following is a partial dependency?

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

A table with no primary key

A field depends on itself

A primary key depends on a foreign key

4. Which of these is true about normalization?

It decreases consistency

It improves data integrity

It increases redundancy

It ensures unstructured data

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

It has no partial dependencies

All attributes are text

It has a foreign key

It has no composite keys

6. Which is an advantage of denormalization?

Reduced data consistency

Improved query performance

Slower insert operations

Increased redundancy

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

Values must exist in another table

Values must follow a specific data type and range

Values must be unique

Values must be non-null

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

Query anomaly

Insert anomaly

Format anomaly

Join anomaly

9. Which normal form removes transitive dependencies?

3NF

1NF

BCNF

2NF

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

FOREIGN KEY

NOT NULL

CHECK

UNIQUE

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

FOREIGN KEY

UNIQUE

CHECK

DEFAULT

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

2NF

BCNF

3NF

1NF

13. What is a composite key?

A duplicated primary key

A foreign key

A single attribute key

A key made up of multiple columns

14. Which constraint enforces referential integrity?

CHECK

NOT NULL

FOREIGN KEY

DEFAULT

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

Redundancy

Schema

Form

Attribute

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

Insert anomaly

Delete anomaly

Access anomaly

Update anomaly

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

Faster queries in all cases

Less redundancy

Fewer anomalies

Better data consistency

18. What is data redundancy?

Repetition of data unnecessarily

Efficient data storage

Secure data access

Structured data retrieval

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

Domain integrity

Referential integrity

Relational integrity

Entity integrity

20. What is the main cause of data anomalies?

Data redundancy

Foreign keys

Indexing

Normalization

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

1NF

2NF

4NF

0NF

22. What does entity integrity ensure?

Consistent foreign keys

No two rows are identical

Valid ranges for data

No NULL in a primary key

23. Which normal form helps in eliminating join dependency?

5NF

3NF

1NF

4NF

24. What does the NOT NULL constraint do?

Ensures that a column cannot have NULL values

Prevents foreign key violations

Prevents duplicates

Deletes null values

25. What is a delete anomaly?

Duplicate data being deleted

Data that is accidentally inserted

Unintended loss of data due to deletion

Data that cannot be updated

Page 2 of 2

26. What is a prime attribute?

A secondary column

A duplicate attribute

An attribute that is always NULL

An attribute that is part of a candidate key

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

3NF

2NF

1NF

4NF

28. Which of these attributes is derived?

Age (calculated from DOB)

Name

Student ID

29. Normalization is mainly used to:

Replace indexes

Minimize duplication and ensure logical storage

Increase data visualization

Increase speed of reports

30. What does a foreign key constraint prevent?

Duplicating the primary key

Writing complex queries

Inserting a value that does not exist in the referenced table

Entering null in any field

31. Which of these is an example of denormalization?

Removing all keys

Applying 3NF

Adding redundant data to improve performance

Eliminating transitive dependencies

32. Which normal form eliminates multi-valued dependencies?

3NF

BCNF

4NF

2NF

33. Which of the following helps enforce domain integrity?

HAVING

ORDER BY

GROUP BY

CHECK

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

It allows multi-valued attributes

It removes transitive dependencies

It ensures atomic values in each cell

It removes join dependencies

35. Which normal form eliminates partial dependency?

2NF

1NF

3NF

4NF

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

Index

Backup

Trigger

CHECK

37. Which is a disadvantage of normalization?

Increased redundancy

Poor data integrity

Reduced data consistency

Slower queries due to joins

38. What is a transitive dependency?

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

When all fields depend on each other

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

UNIQUE

DEFAULT

CHECK

NULL

40. What is the purpose of normalization in databases?

To eliminate data redundancy and anomalies

To reduce complexity

To create duplicate data

To speed up data entry

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

Referential integrity

Structural integrity

Entity integrity

Domain integrity

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

Reduces data redundancy

Increases storage usage

Improves data integrity

Simplifies maintenance

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

Duplicate or conflicting data

Fast performance

Consistent reports

Accurate forecasting

44. Which term refers to consistency between related tables?

Entity integrity

Domain integrity

Referential integrity

Redundancy

45. Which form of normalization removes repeating groups?

2NF

3NF

BCNF

1NF

46. What is a candidate key?

A key chosen randomly

A possible choice for primary key

A foreign key

A duplicate column

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

Transitive dependency

Partial dependency

Functional dependency

Join dependency

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

Data integrity

Data backup

Data redundancy

Data replication

49. What is a normal form in database design?

A database model

A set of rules to reduce redundancy and anomalies

A type of table

A report format

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

UET Lahore, Taxila ECAT Chemistry Entry Test Online…
UET Lahore Combined Entry Test 2025 ECAT Schedule…
NED-Karachi ECAT Physics Entry Test Online Preparation
NED-Karachi ECAT Maths Entry Test Online Preparation
UET Lahore, Taxila ECAT Physics Entry Test Online…
NED-Karachi ECAT Chemistry Entry Test Online Preparation
Mehran University Sindh ECAT Physics Entry Test…
NUST Rawalpindi ECAT Chemistry Entry Test Preparation Online

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

Related:

You Might Also Like

Mustansar Khan

Leave a Reply Cancel reply