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 a table. Identify which fields can be designated as primary key and unique keys?
    Emp-id Fname Lname Email
    MK101 Vikas Kumar arvind@mkworld.com
    MK102 Bhanu Sharma Bhanu@mkworld.com
    MK103 Vinay Kapoor vinay@mkworld.com
    MK104 Nitin Arya Nitin@mkworld.com
     

    A)
    Primary key - Fname
    Unique keys - Emp-id, Fname

    B)
    Primary key - Emp-id
    Unique keys - Emp-id, Email

    C)
    Primary key - Email
    Unique keys - Fname, Lname

    D)
    Primary key - Fname
    Unique keys - Emp-id, Email

    Correct Answer: B

You need to login to perform this action.
You will be redirected in 3 sec spinner