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

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) \] \[ {(i),\ (ii)\ \text{and}\ (iv)} \] Hence, option (C) is correct.