DBMS MCQ : Disadvantages of File (Multiple Choice Questions)admin
Duplication of data at several places is called as _______________.
Data Redundancy increases the cost of storing and retrieving data.
Question 2 Explanation:
Due to Duplicate data , duplicate information gets stored in the database and thus cost for storage and retrieval increases.
Suppose user have Saving Account and Checking Account in the Bank. Saving Account Stores following information -
account-no name address mobileand Checking Account stores -
account-no name address mobileWhich of the information is not redundant.
Question 3 Explanation:
Account no is different for different account i.e for Checking Account and Saving Account.
If in redundant file common fields are not matching then it results in _____________.
Data Integrity Problem
It is difficult to access conventional file system than Database System.
There are 5 questions to complete.