Which of the following terms refers to the duplication of data across multiple locations in a non-DBMS file system? MCQ with Answer and Explanation

Which of the following terms refers to the duplication of data across multiple locations in a non-DBMS file system?

A. Data Integrity

B. Data Redundancy

C. Data Security

D. Data Isolation

Answer: Option B

Solution (By JKExamLibrary)

Data Redundancy refers to the unnecessary duplication of the exact same data in multiple files or locations, which wastes storage and can cause inconsistencies.

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

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1 Report Error

Which of the following is a valid SQL statement to add a new column to a table?

A. ADD COLUMN TO table_name column_name datatype;

B. ALTER TABLE table_name ADD COLUMN column_name datatype;

C. Both A and C

D. ALTER TABLE table_name ADD column_name datatype;

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
Both 'ADD column_name datatype' and 'ADD COLUMN column_name datatype' are valid syntax in some DBMS, but standard SQL uses 'ADD column_name datatype'. However, many DBMS support both.

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

Question #2 Report Error

What is an attribute called when it can hold more than one value for a single entity instance, such as multiple phone numbers for a person?

A. Composite Attribute

B. Derived Attribute

C. Multi-valued Attribute

D. Complex Attribute

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
A Multi-valued Attribute is an attribute that can store multiple distinct values for a single entity instance (e.g., skill_set, phone_numbers).

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