2. Questions Bank
  3. 10th Class
  4. Computers Science
  5. Database Concepts

10th Class Computers Science Database Concepts Question Bank Database Management System

  • question_answer
    Given below is a snapshot of two files maintained by a college and the hostel separately, for keeping records of their students. Which of the following problem occurs in the records?
    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 spinner