Computer Data Integrity and Normalization Test Online

Q: How can I prepare for Computer Data Integrity and Normalization Test Online?

You can prepare for Computer Data Integrity and Normalization Test Online by attempting the free online quizzes at Gotest.com.pk. We provide instant results, performance reports, and detailed explanations for every question.

Question 1

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

Answer

FOREIGN KEY

Question 2

2. Which normal form helps in eliminating join dependency?

Question 3

3. Which is an advantage of denormalization?

Answer

Reduced data consistency

Answer

Slower insert operations

Answer

Improved query performance

Answer

Increased redundancy

Question 4

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

Answer

Functional dependency

Answer

Join dependency

Answer

Transitive dependency

Answer

Partial dependency

Question 5

5. What is a candidate key?

Answer

A possible choice for primary key

Answer

A duplicate column

Answer

A foreign key

Answer

A key chosen randomly

Question 6

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

Question 7

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

Answer

It removes transitive dependencies

Answer

It allows multi-valued attributes

Answer

It removes join dependencies

Answer

It ensures atomic values in each cell

Question 8

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

Answer

Data backup

Answer

Data replication

Answer

Data redundancy

Answer

Data integrity

Question 9

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

Answer

Delete anomaly

Answer

Access anomaly

Answer

Update anomaly

Answer

Insert anomaly

Question 10

10. What is a transitive dependency?

Answer

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

Answer

When a field is dependent on two fields

Answer

When all fields depend on each other

Answer

When a field is independent of the key

Question 11

11. Which form of normalization removes repeating groups?

Question 12

12. Which normal form removes transitive dependencies?

Question 13

13. Which normal form eliminates partial dependency?

Question 14

14. Which SQL keyword can help maintain entity integrity?

Answer

PRIMARY KEY

Answer

FOREIGN KEY

Question 15

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

Answer

Consistent reports

Answer

Accurate forecasting

Answer

Fast performance

Answer

Duplicate or conflicting data

Question 16

16. Which term refers to consistency between related tables?

Answer

Referential integrity

Answer

Domain integrity

Answer

Entity integrity

Answer

Redundancy

Question 17

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

Answer

All of the above

Question 18

18. Which normal form eliminates multi-valued dependencies?

Question 19

19. Which of the following is a partial dependency?

Answer

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

Answer

A primary key depends on a foreign key

Answer

A table with no primary key

Answer

A field depends on itself

Question 20

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

Answer

Domain integrity

Answer

Referential integrity

Answer

Entity integrity

Answer

Structural integrity

Question 21

21. What is a prime attribute?

Answer

An attribute that is part of a candidate key

Answer

A duplicate attribute

Answer

A secondary column

Answer

An attribute that is always NULL

Question 22

22. Which is a disadvantage of normalization?

Answer

Reduced data consistency

Answer

Increased redundancy

Answer

Slower queries due to joins

Answer

Poor data integrity

Question 23

23. What is data redundancy?

Answer

Structured data retrieval

Answer

Secure data access

Answer

Efficient data storage

Answer

Repetition of data unnecessarily

Question 24

24. What does a foreign key constraint prevent?

Answer

Entering null in any field

Answer

Writing complex queries

Answer

Duplicating the primary key

Answer

Inserting a value that does not exist in the referenced table

Question 25

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

Answer

FOREIGN KEY

Question 26

26. Which of these attributes is derived?

Answer

Student ID

Answer

Age (calculated from DOB)

Question 27

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

Answer

Insert anomaly

Answer

Format anomaly

Answer

Query anomaly

Answer

Join anomaly

Question 28

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

Answer

Redundancy

Question 29

29. What is a normal form in database design?

Answer

A report format

Answer

A set of rules to reduce redundancy and anomalies

Answer

A database model

Answer

A type of table

Question 30

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

Question 31

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

Answer

Values must exist in another table

Answer

Values must be unique

Answer

Values must be non-null

Answer

Values must follow a specific data type and range

Question 32

32. What does the NOT NULL constraint do?

Answer

Prevents duplicates

Answer

Deletes null values

Answer

Ensures that a column cannot have NULL values

Answer

Prevents foreign key violations

Question 33

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

Question 34

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

Question 35

35. Which of these is an example of denormalization?

Answer

Adding redundant data to improve performance

Answer

Applying 3NF

Answer

Removing all keys

Answer

Eliminating transitive dependencies

Question 36

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

Question 37

37. Which of these is true about normalization?

Answer

It increases redundancy

Answer

It improves data integrity

Answer

It ensures unstructured data

Answer

It decreases consistency

Question 38

38. What is the purpose of normalization in databases?

Answer

To eliminate data redundancy and anomalies

Answer

To speed up data entry

Answer

To reduce complexity

Answer

To create duplicate data

Question 39

39. What is a delete anomaly?

Answer

Unintended loss of data due to deletion

Answer

Duplicate data being deleted

Answer

Data that is accidentally inserted

Answer

Data that cannot be updated

Question 40

40. Which constraint enforces referential integrity?

Answer

FOREIGN KEY

Question 41

41. What does entity integrity ensure?

Answer

Valid ranges for data

Answer

No NULL in a primary key

Answer

No two rows are identical

Answer

Consistent foreign keys

Question 42

42. Which of the following helps enforce domain integrity?

Question 43

43. What is a composite key?

Answer

A key made up of multiple columns

Answer

A single attribute key

Answer

A duplicated primary key

Answer

A foreign key

Question 44

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

Answer

It has no partial dependencies

Answer

All attributes are text

Answer

It has no composite keys

Answer

It has a foreign key

Question 45

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

Answer

Domain integrity

Answer

Entity integrity

Answer

Relational integrity

Answer

Referential integrity

Question 46

46. What is the main cause of data anomalies?

Answer

Data redundancy

Answer

Foreign keys

Answer

Normalization

Question 47

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

Answer

Improves data integrity

Answer

Reduces data redundancy

Answer

Simplifies maintenance

Answer

Increases storage usage

Question 48

48. Normalization is mainly used to:

Answer

Increase speed of reports

Answer

Minimize duplication and ensure logical storage

Answer

Increase data visualization

Answer

Replace indexes

Question 49

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

Answer

Better data consistency

Answer

Faster queries in all cases

Answer

Less redundancy

Answer

Fewer anomalies

Question 50

Loading...

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

Computer Data Integrity and Normalization Test Online

Important Data Integrity and Normalization Question and Answer

Data Integrity and Normalization Practice Test Online With Explanation

Uncategorized

Study Plan for Computer Data Integrity and Normalization Test Online

How to Use GoTest for Preparation:

Mustansar Khan

Leave a Reply Cancel reply

Important Data Integrity and Normalization Question and Answer

Data Integrity and Normalization Practice Test Online With Explanation

Uncategorized

Study Plan for Computer Data Integrity and Normalization Test Online

How to Use GoTest for Preparation:

Latest Updates

Mustansar Khan

Leave a Reply Cancel reply