DBMS Multiple choice Questions and Answers-Relational Databases

1.	A Relation is a
a.	Subset of a Cartesian product of a list of attributes
b.	Subset of a Cartesian product of a list of domains
c.	Subset of a Cartesian product of a list of tuple
d.	Subset of a Cartesian product of a list of relations

Discuss

Answer: (b).Subset of a Cartesian product of a list of domains

2.	In mathematical term Table is referred as
a.	Relation
b.	Attribute
c.	Tuple
d.	Domain

Discuss

Answer: (a).Relation

3.	In mathematical term Row is referred as
a.	Relation
b.	Attribute
c.	Tuple
d.	Domain

Discuss

Answer: (c).Tuple

4.	_______ allow us to identify uniquely a tuple in the relation.
a.	Superkey
b.	Domain
c.	Attribute
d.	Schema

Discuss

Answer: (a).Superkey

5.	Minimal Superkeys are called
a.	Schema keys
b.	Candidate keys
c.	Domain keys
d.	Attribute keys

Discuss

Answer: (b).Candidate keys

6.	Who proposed the relational model?
a.	Bill Gates
b.	E.F. Codd
c.	Herman Hollerith
d.	Charles Babbage

Discuss

Answer: (b).E.F. Codd

7.	Data Manipulation Language (DML) is not to
a.	Create information table in the Database
b.	Insertion of new information into the Database
c.	Deletion of information in the Database
d.	Modification of information in the Database

Discuss

Answer: (a).Create information table in the Database

8.	Which of the following in true regarding Referential Integrity?
a.	Every primary-key value must match a primary-key value in an associated table
b.	Every primary-key value must match a foreign-key value in an associated table
c.	Every foreign-key value must match a primary-key value in an associated table
d.	Every foreign-key value must match a foreign-key value in an associated table

Discuss

Answer: (c).Every foreign-key value must match a primary-key value in an associated table

9.	How many types of keys in Database Design?
a.	Candidate key
b.	Primary key
c.	Foreign key
d.	All of these

Discuss

Answer: (d).All of these

10.	The minimal set of super key is called
a.	Primary key
b.	Secondary key
c.	Candidate key
d.	Foreign key

Discuss

Answer: (c).Candidate key