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 normal form eliminates partial dependency?

1NF

2NF

3NF

4NF

2. What is a delete anomaly?

Data that is accidentally inserted

Duplicate data being deleted

Unintended loss of data due to deletion

Data that cannot be updated

3. 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 exist in another table

Values must be unique

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

CHECK

UNIQUE

DEFAULT

NULL

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

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

Fewer anomalies

Faster queries in all cases

Better data consistency

Less redundancy

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

All of the above

1NF

2NF

3NF

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

Backup

CHECK

Trigger

Index

9. Which normal form eliminates multi-valued dependencies?

BCNF

4NF

3NF

2NF

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

Transitive dependency

Partial dependency

Functional dependency

Join dependency

11. What is a candidate key?

A foreign key

A duplicate column

A possible choice for primary key

A key chosen randomly

12. Which is a disadvantage of normalization?

Reduced data consistency

Poor data integrity

Slower queries due to joins

Increased redundancy

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

It removes join dependencies

It allows multi-valued attributes

It removes transitive dependencies

It ensures atomic values in each cell

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

FOREIGN KEY

NOT NULL

UNIQUE

CHECK

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

16. What is a composite key?

A foreign key

A duplicated primary key

A key made up of multiple columns

A single attribute key

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

4NF

2NF

3NF

1NF

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

Relational integrity

Entity integrity

Referential integrity

Domain integrity

19. Which term refers to consistency between related tables?

Entity integrity

Referential integrity

Redundancy

Domain integrity

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

It has no partial dependencies

It has a foreign key

All attributes are text

It has no composite keys

21. What is data redundancy?

Secure data access

Efficient data storage

Repetition of data unnecessarily

Structured data retrieval

22. Which normal form removes transitive dependencies?

BCNF

1NF

3NF

2NF

23. Which SQL keyword can help maintain entity integrity?

CHECK

PRIMARY KEY

INDEX

FOREIGN KEY

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

Format anomaly

Join anomaly

Query anomaly

Insert anomaly

25. 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 all fields depend on each other

When a field is dependent on two fields

Page 2 of 2

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

3NF

BCNF

1NF

2NF

27. What is a prime attribute?

A duplicate attribute

An attribute that is part of a candidate key

A secondary column

An attribute that is always NULL

28. What is the main cause of data anomalies?

Data redundancy

Indexing

Normalization

Foreign keys

29. Which of these is true about normalization?

It improves data integrity

It decreases consistency

It increases redundancy

It ensures unstructured data

30. Which of these attributes is derived?

Student ID

Name

Age (calculated from DOB)

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

Duplicate or conflicting data

Consistent reports

Fast performance

Accurate forecasting

32. Which of the following is a partial dependency?

A primary key depends on a foreign key

A table with no primary key

A field depends on itself

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

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

Entity integrity

Domain integrity

Structural integrity

Referential integrity

34. What is the purpose of normalization in databases?

To reduce complexity

To speed up data entry

To create duplicate data

To eliminate data redundancy and anomalies

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

2NF

4NF

1NF

0NF

36. Which of the following helps enforce domain integrity?

CHECK

GROUP BY

HAVING

ORDER BY

37. What does the NOT NULL constraint do?

Prevents duplicates

Prevents foreign key violations

Ensures that a column cannot have NULL values

Deletes null values

38. Which form of normalization removes repeating groups?

2NF

3NF

BCNF

1NF

39. Which constraint enforces referential integrity?

NOT NULL

DEFAULT

FOREIGN KEY

CHECK

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

DEFAULT

CHECK

UNIQUE

FOREIGN KEY

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

Form

Attribute

Schema

Redundancy

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

Insert anomaly

Update anomaly

Access anomaly

Delete anomaly

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

Data replication

Data backup

Data redundancy

Data integrity

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

Simplifies maintenance

Reduces data redundancy

Increases storage usage

Improves data integrity

45. Which is an advantage of denormalization?

Improved query performance

Slower insert operations

Increased redundancy

Reduced data consistency

46. Which of these is an example of denormalization?

Removing all keys

Adding redundant data to improve performance

Applying 3NF

Eliminating transitive dependencies

47. What does entity integrity ensure?

No NULL in a primary key

Consistent foreign keys

No two rows are identical

Valid ranges for data

48. Which normal form helps in eliminating join dependency?

4NF

3NF

1NF

5NF

49. Normalization is mainly used to:

Increase data visualization

Increase speed of reports

Replace indexes

Minimize duplication and ensure logical storage

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

ECAT Introduction to Computers Online Test
ECAT Physics Optical Instruments 1 Test Online
ECAT Computer File Handling in “C” Test Online
ECAT Computer Functions in “C” Test Online
ECAT Computer Loop Constructs Test Online
ECAT Computer Decision Constructs Test Online
ECAT Computer Input Output Test Online
ECAT Computer Elements of “C” Test Online
ECAT Computer Getting Started with “C” Test Online
ECAT Computer Science Microsoft Access-Forms and Reports Tes...

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 Group VA and VIA Elements Test Online

ECAT Physics Optical Instruments 1 Test Online

ECAT Chemistry Alcohols Phenols And Ethers Test Online

ECAT Mathematics Vectors Chapter Online Test

ECAT English Sentence Completion Online Test

ECAT Computer Loop Constructs Test Online

Leave a Reply Cancel reply