DBMS MCQ : Disadvantages of File (Multiple Choice Questions)


Question 1
Duplication of data at several places is called as _______________.
A
Data Redundancy
B
Atomicity Problem
C
Data Isolation
D
Data Inconsistency
Question 2
Data Redundancy increases the cost of storing and retrieving data.
A
True
B
False
Question 2 Explanation: 
Due to Duplicate data , duplicate information gets stored in the database and thus cost for storage and retrieval increases.
Question 3
Suppose user have Saving Account and Checking Account in the Bank. Saving Account Stores following information -
account-no
name
address
mobile
and Checking Account stores -
account-no
name
address
mobile
Which of the information is not redundant.
A
address
B
mobile
C
account-no
D
name
Question 3 Explanation: 
Account no is different for different account i.e for Checking Account and Saving Account.
Question 4
If in redundant file common fields are not matching then it results in _____________.
A
Data Inconsistency
B
Data Integrity Problem
C
Data Redundancy
D
Data Isolation
Question 5
It is difficult to access conventional file system than Database System.
A
False
B
True
There are 5 questions to complete.