This set of Advanced Database Management System Multiple Choice Questions and Answers (MCQs) focuses on “Database Constraints”.
PRACTICE IT NOW TO SHARPEN YOUR CONCEPT AND KNOWLEDGE
1. ______ is the restrictions imposed to maintain the data integrity of the database
- Mapping Cardinalities
- Cardinality ratio
- Participation Constraints
- All of the Above
D. All of the Above
An ER enterprise schema may define certain constraints to which the contents of database must conform. Mapping cardinalities or cardinality ratio and participation constraints are two most important types of constraints
2. For a Binary relationship set R between entity sets A and B, the ________ express the number of entities to which another entity can be associated.
- Cardinality ratio.
- Participation constraints
- Limited Ratio
- Degree ratio
A. Cardinality ratio.
Cardinality Ratio are most useful in describing binary relationship sets, although they can contribute to the description of relationship sets that involve more than two entity sets
3. For a Binary relationship set R between entity sets A and B,the ________ express the number of entities to which another entity can be associated.
- Mapping Cardinalities.
- Participation constraints
- Domain Constraints
- Integrity constraints
A. Mapping Cardinalities.
Mapping Cardinalities also known as cardinality ratio are most useful in describing binary relationship sets, although they can contribute to the description of relationship sets that involve more than two entity sets
4. For a binary relationship set R between entity sets A and B, the Mapping Cardinality is ONE TO ONE if
- An Entity A is associated with any number (zero or more)of entities in B, An entity in B however, can be associated with at most one entity in A.
- An entity in A is associated with at most one entity in B, and an entity in B is associated with at most one entity in A
- an Entity A is associated with at most one entity in B, An entity in B however, can be associated with any number zero or more of entities in A
- . An entity in A is associated with any number zero or more of entities in B, and an entity in B is associated with any number zero or more of entities in A.
B. An entity in A is associated with at most one entity in B, and an entity in B is associated with at most one entity in A
5. For a binary relationship set R between entity sets A and B,the Mapping Cardinality is ONE TO MANY if
- An Entity A is associated with any number (zero or more)of entities in B, An entity in B however, can be associated with at most one entity in A
- An entity in A is associated with at most one entity in B, and an entity in B is associated with at most one entity in A
- An Entity A is associated with at most one entities in B,An entity in B however, can be associated with any number zero or more of entities in A
- An entity in A is associated with any number zero or more of entities in B,and an entity in B is associated with any number zero or more of entities in A.
A. An Entity A is associated with any number (zero or more)of entities in B, An entity in B however, can be associated with at most one entity in A
6. For a binary relationship set R between entity sets A and B,the Mapping Cardinality is MANY to ONE if
- An Entity A is associated with any number (zero or more)of entities in B,An entity in B however, can be associated with at most one entity in A.
- An entity in A is associated with at most one entity in B,and an entity in B is associated with at most one entity in A
- An Entity A is associated with at most one entities in B, An entity in B however, can be associated with any number zero or more of entities in A
- An entity in A is associated with any number zero or more of entities in B,and an entity in B is associated with any number zero or more of entities in A.
C. An Entity A is associated with at most one entities in B, An entity in B however, can be associated with any number zero or more of entities in A
7. For a binary relationship set R between entity sets A and B, the Mapping Cardinality is MANY to MANY if
- An Entity A is associated with any number (zero or more) of entities in B, An entity in B however, can be associated with at most one entity in A.
- An entity in A is associated with at most one entity in B,and an entity in B is associated with at most one entity in A
- An Entity A is associated with at most one entities in B,An entity in B however, can be associated with any number zero or more of entities in A
- An entity in A is associated with any number zero or more of entities in B, and an entity in B is associated with any number zero or more of entities in A.
D. An entity in A is associated with any number zero or more of entities in B, and an entity in B is associated with any number zero or more of entities in A.
