Scribd
Upload
354 views3 pages

Javeria Ismail (20) Database MCQs

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.

Uploaded by

Mehwish Shabbir
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
354 views3 pages

Javeria Ismail (20) Database MCQs

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.

Uploaded by

Mehwish Shabbir
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

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