When the same data is updated in one location but remains unchanged in another location, it creates a state of what? MCQ with Answer and Explanation

Question

Share Report Error

When the same data is updated in one location but remains unchanged in another location, it creates a state of what?

A. Data Integrity

B. Data Independence

C. Data Inconsistency

D. Data Security

Answer: Option C

Solution (By JKExamLibrary)

Data Inconsistency occurs when different versions of the same data appear in different places due to uncontrolled data redundancy.

This question belongs to: Computer Database Management System (DBMS)

Request complete Subject PDF

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1

Share Report

Which of the following is a valid SQL constraint that ensures a column's values are all distinct?

A. DISTINCT

B. UNIQUE

C. Both A and B

D. PRIMARY KEY

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Both UNIQUE and PRIMARY KEY enforce uniqueness. PRIMARY KEY also implies NOT NULL.

This question belongs to: Computer Database Management System (DBMS)

Question #2

Share Report

Which type of relationship is represented by a foreign key in a relational database?

A. Many-to-many

B. One-to-one

C. One-to-many

D. All of the above

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Foreign keys can represent various relationships, including one-to-one, one-to-many, and many-to-many (via junction tables).

This question belongs to: Computer Database Management System (DBMS)

Question #3

Share Report

What is the main advantage of using a DBMS over a file system?

A. Data security and access control are provided

B. All of the above

C. Data redundancy is minimized

D. Data consistency is maintained

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
A DBMS offers advantages like reduced redundancy, consistency, security, concurrent access, and backup/recovery compared to file systems.

This question belongs to: Computer Database Management System (DBMS)

Explore All Database Management System (DBMS) MCQs