Relational Data Model MCQ: A database is a collection of interrelated data and the way data is related to each other depends upon the model being used. Generally database are based on one of the three models; the hierarchical model, the network model or the relational model. A database based on the network or hierarchical model is a non-relational database and a database based on relational model is a relational database.
A relational database is a collection of relation (or two-dimensional tables) having distinct names. The relational model represents both data and the relationships among those data using relation. A relation is used to represent information about any entity (such as book, publisher, author) and its relationship with other entities in the form of attributes (or columns) and tuples (or rows).
Relational Data Model MCQ
1. The relational model is base on the branches of ……….
a. Science
b. Engineering
c. Mathematics
d. None of these
2. The relational model includes:
a. Structural components
b. Manipulative components
c. Integrity constraints
d. All of the above
3. Which of the following is not a constituent of a relation schema?
a. Tuples
b. Relation name
c. Set of attributes
d. Both (b & c)
4. Which of the following can only be defined as column-level constraints?
a. Not null constraint
b. Primary key constraint
c. Foreign key constraint
d. Check constraint
5. Integrity constraints can be categorized into ………….. parts.
a. One
b. Two
c. Three
d. Four
6. Candidate key is also known as …………
a. Primary key
b. Super key
c. Irreducible super-key
d. Foreign key
7. Which of the following integrity is applied on the tuple?
a. Entity integrity
b. Domain integrity
c. Referential integrity
d. Semantic integrity
8. In case more than one attributes forms in primary key, the key is known as ………..
a. Foreign key
b. Candidate key
c. Alternate key
d. Composite key
9. While mapping relationship type to a relation, which of the following relationship types allows us to choose primary key of either participating entity type as a primary key of the relation?
a. One to one
b. One to many
c. Many to many
d. all of the above
10. Which of the following is not true with primary key constraint?
a. Unique key constraints is preferable
b. Primary key attribute cannot have null value over primary key constraint
c. Primary key constraint enforces entity integrity
d. Multiple primary key constraints can be defined on a relation.
Useful Links:
1. Database Multiple Choice Question (MCQ) Link
2. Entity Relationship Model MCQ Link
3. Computer Operator MCQ Quiz Link
4. NEB Computer Operator Preparation Link
