Question

Which of the following are the advantages of DBMS? \[ \begin{aligned} (i) &\ \text{Reduced Data Redundancy} (ii) &\ \text{Improved Data Security} (iii) &\ \text{Increased Data Inconsistency} (iv) &\ \text{Backup and Recovery} \end{aligned} \]

• A. (i) and (ii)
• B. (i), (ii) and (iii)
• C. (i), (ii) and (iv)
• D. (i) and (iii)

Hint:

Major advantages of DBMS:
• Reduced Data Redundancy
• Reduced Data Inconsistency
• Improved Security
• Data Sharing
• Backup and Recovery
• Better Data Integrity

Answer 1

The Correct Option is C

Concept: A Database Management System (DBMS) is software used to create, manage, store, retrieve, and secure data efficiently. DBMS provides centralized control over data and offers several advantages compared with traditional file systems.

Step 1: Examine statement (i).
A DBMS minimizes duplication of data by storing information in an organized manner. \[ (i) = \text{True} \]

Step 2: Examine statement (ii).
DBMS provides authentication, authorization, and access-control mechanisms. \[ (ii) = \text{True} \]

Step 3: Examine statement (iii).
A major objective of DBMS is to reduce data inconsistency, not increase it. \[ (iii) = \text{False} \]

Step 4: Examine statement (iv).
Modern DBMS software provides backup and recovery facilities to protect data from failures. \[ (iv) = \text{True} \]

Step 5: Select the correct combination.
The true statements are: \[ (i),\ (ii),\ (iv) \] \[ \boxed{(i),\ (ii)\ \text{and}\ (iv)} \] Hence, option (C) is correct.