Scribd Logo
Upload

Welcome to Scribd!

  • 307 views

    Javeria Ismail (20) Database MCQs

    Uploaded by

    Mehwish Shabbir
    The document contains a multiple choice quiz about database keys and integrity constraints. The questions cover topics such as the definitions of primary keys, foreign keys, candidate keys, and referential integrity constraints. It also asks about the purpose of constraints like not null and unique constraints.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Javeria Ismail (20) Database MCQs

    Uploaded by

    Mehwish Shabbir
    307 views3 pages
    The document contains a multiple choice quiz about database keys and integrity constraints. The questions cover topics such as the definitions of primary keys, foreign keys, candidate keys, and referential integrity constraints. It also asks about the purpose of constraints like not null and unique constraints.

    Original Description:

    Databsae MCQs

    Original Title

    Javeria ismail(20) Database MCQs

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains a multiple choice quiz about database keys and integrity constraints. The questions cover topics such as the definitions of primary keys, foreign keys, candidate keys, and referential integrity constraints. It also asks about the purpose of constraints like not null and unique constraints.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    307 views3 pages

    Javeria Ismail (20) Database MCQs

    Uploaded by

    Mehwish Shabbir
    The document contains a multiple choice quiz about database keys and integrity constraints. The questions cover topics such as the definitions of primary keys, foreign keys, candidate keys, and referential integrity constraints. It also asks about the purpose of constraints like not null and unique constraints.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 3

    Database

    Keys And Integrity Constraint’s MCQs

    Submitted To:
    Miss. Kiran

    Submitted by:
    Javeria Ismail
    Roll#: 20
    Q1: Choose the correct option.

    1. A _____ is a property of the entire relation, rather than of the individual tuples in
    which each tuple is unique.  

    a. Rows c. Attribute
    b. Key d. Fields

    2. 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.  

    a. Referential c. Specific
    b. Primary d. All of these

    3. A attribute in a relation is a foreign key if the _______ key from one relation is used
    as an attribute in that relation .  

    a. Super c. Candidate
    b. Primary d. foreign

    4. Which key accepts multiple NULL values?

    a. Foregin Key. c. Primary Key


    b. Candidate key. d. Unique Key.

    5. What is the function of the not null constraint?

    a. It ensures that the data entered is unique


    b. It prevents illegal data from being entered into the database
    c. It ensures that data is entered into the database
    d. None

    6. Which of the following is not an integrity constraint?

    a. Not null c. Unique


    b. Positive d. none

    7. Domain constraints, functional dependency and referential integrity are special


    forms of _________
    a. Foreign Key c. Assertion
    b. Primary Key d. none

    8. The Entity Customer has three candidate keys:


    i. CustId
    ii. Email and
    iii. ContactNo.

    Suggest the best primary key for this entity?

    a. ContactNo c. CustId
    b. Email d. All

    9. A _______________ key is a minimal super key:

    a. Primary c. Candidate
    b. Foreign d. Non-Prime

    10. The subset of super key is a candidate key under what condition?  

    a. No proper subset is a super key c. All subsets are super key


    b. Subset is s super key d. Both B and C

    You might also like