File-1 | |||
S_Id | Name | Course | Contact No. |
FET-001 | Shikha | IT | 000000000 |
FET-002 | Anirudh | CSE | 000000000 |
FET-003 | Priyanka | CSE | 000000000 |
FET-004 | Abhishek | IT | 000000000 |
File-2 | |||
S_Id | Name | Course | Contact No. |
FET-001 | Shikha | 301 | 000000000 |
FET-002 | Anirudh | 302 | 000000000 |
FET-003 | |||
FET-004 |
A) Data Duplicacy
B) Data Inconsistency
C) Data Consistency
D) Both [A] and [B]
Correct Answer: B
Solution :
Data inconsistency occurs in given tables, because in File 1 the value of Contact No. field which has s_id FET-001 is nine eight one two one two one two one two one two in File 2 it is Nine eight one one one two one two one two , similarly the value of contact No. field is changed for FET-002 also.You need to login to perform this action.
You will be redirected in
3 sec