Home / CSE MCQs / DBMS MCQs :: DBMS Keys

CSE MCQs :: DBMS MCQs

  1. Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?
  2. A.
    Candidate key
    B.
    Sub key
    C.
    Super key
    D.
    Foreign key

    View Answer

    Workspace

    Discuss Discuss in Forum


  3. Consider attributes ID , CITY and NAME . Which one of this can be considered as a super key ?
  4. A.
    NAME
    B.
    ID
    C.
    CITY
    D.
    CITY , ID

    View Answer

    Workspace

    Discuss Discuss in Forum


  5. The subset of super key is a candidate key under what condition ?
  6. A.
    No proper subset is a super key
    B.
    All subsets are super keys
    C.
    Subset is a super key
    D.
    Each subset is a super key

    View Answer

    Workspace

    Discuss Discuss in Forum


  7. A _____ is a property of the entire relation, rather than of the individual tuples in which each tuple is unique.
  8. A.
    Rows
    B.
    Key
    C.
    Attribute
    D.
    Fields

    View Answer

    Workspace

    Discuss Discuss in Forum


  9. Which one of the following attribute can be taken as a primary key ?
  10. A.
    Name
    B.
    Street
    C.
    Id
    D.
    Department

    View Answer

    Workspace

    Discuss Discuss in Forum


  11. Which one of the following cannot be taken as a primary key ?
  12. A.
    Id
    B.
    Register number
    C.
    Dept_id
    D.
    Street

    View Answer

    Workspace

    Discuss Discuss in Forum


  13. A attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation .
  14. A.
    Candidate
    B.
    Primary
    C.
    Super
    D.
    Sub

    View Answer

    Workspace

    Discuss Discuss in Forum


  15. The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as primary key is called
  16. A.
    Referential relation
    B.
    Referencing relation
    C.
    Referenced relation
    D.
    Referred relation

    View Answer

    Workspace

    Discuss Discuss in Forum


  17. The ______ is the one in which the primary key of one relation is used as a normal attribute in another relation .
  18. A.
    Referential relation
    B.
    Referencing relation
    C.
    Referenced relation
    D.
    Referred relation

    View Answer

    Workspace

    Discuss Discuss in Forum


  19. A _________ integrity constraint requires that the values appearing in specified attributes of any tuple in the referencing relation also appear in specified attributes of at least one tuple in the referenced relation.
  20. A.
    Referential
    B.
    Referencing
    C.
    Specific
    D.
    Primary

    View Answer

    Workspace

    Discuss Discuss in Forum