What is data redundancy? MCQ with Answer and Explanation

What is data redundancy?
A. Encrypted data
B. Duplication of data in multiple places
C. Absence of data
D. Processed information
Answer: Option B
Solution (By JKSSB Mock Tests)
Data redundancy refers to unnecessary duplication of data, which DBMS helps control.

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1
What does the letter 'D' stand for in the widely accepted ACID properties of database transactions?
A. Definition
B. Data
C. Durability
D. Dependency

Correct Answer: Option C


Explanation:
ACID stands for Atomicity, Consistency, Isolation, and Durability. Durability ensures that once a transaction commits, its changes survive system failures.

This question belongs to: Computer Database Management System (DBMS)
Question #2
The actual collection of data tuples stored in a table at any specific point in time is called a what?
A. Relation Degree
B. Relation Schema
C. Relation Domain
D. Relation Instance

Correct Answer: Option D


Explanation:
A Relation Instance is the specific collection of data rows (tuples) present in a table at a given moment. It changes frequently as data is modified.

This question belongs to: Computer Database Management System (DBMS)
Question #3
Which constraint ensures that a column cannot accept or store an unassigned or missing value?
A. NOT NULL
B. CHECK
C. UNIQUE
D. DEFAULT

Correct Answer: Option A


Explanation:
The NOT NULL constraint explicitly forces a column to always contain a value, preventing blank or NULL entries.

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