40. A snapshot of two files (File-1 and File-2), maintained
by a college and the hostel separately, for keeping
records of their students is shown here. Which of the
following problem occurs in the records?
File-1
C Id
|
CET-001
CET-002
Name
Niharika
Piyush
Aparna
Rohit
Course
IT
CSE
CSE
IT
Contact No.
9860124890
9200080004
9624103041
9420104552
CET-003
CET-004
File-2
C
Id
CET-001
Name
Niharika
Piyush
Aparna
Course
IT
CSE
Contact No.
9860124890
9200800004
9624103041
CET-002
CET-003
CSE
CET-004
Rohit
CSE
9420104552
A.
B.
IC.
D.
Data Duplicacy
Data Inconsistency
Data Consistency
Both A and B
Answers
Answered by
0
Answer
Option D
Explanation:
Data Duplicate is a condition that occurs between files when similar data is kept in two different files
Data inconsistency is a condition that occurs between files when similar data is kept in different formats in two different files
IN the given files 1 and 2, there is both data duplicacy and data inconsistency. There is a lot of data that is similar in both files as well as the format is also slightly changed in both.
Similar questions