Table of Content

DBMS MCQ : Disadvantages of File (Multiple Choice Questions)


Question 1
Duplication of data at several places is called as _______________.
A
Data Isolation
B
Data Redundancy
C
Data Inconsistency
D
Atomicity Problem
Question 2
Data Redundancy increases the cost of storing and retrieving data.
A
False
B
True
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
name
B
account-no
C
address
D
mobile
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 Isolation
B
Data Integrity Problem
C
Data Redundancy
D
Data Inconsistency
Question 5
It is difficult to access conventional file system than Database System.
A
False
B
True
There are 5 questions to complete.

Pages: Page 1, Page 2