Home »
MCQs »
DBMS MCQs
DBMS Integrity Constraints Multiple-Choice Questions (MCQs)
DBMS Integrity Constraints MCQs: This section contains DBMS Integrity Constraints Multiple-Choice Questions (MCQs).
Submitted by Anushree Goswami, on March 28, 2022
1. Constraints regarding integrity are ___ that must be followed.
- Data
- Rules
- Tables
- None
Answer: B) Rules
Explanation:
Constraints regarding integrity are rules that must be followed.
Discuss this Question
2. Information ___ is maintained by Integrity Constraints.
- Quantity
- Data
- Quality
- Flow
Answer: C) Quality
Explanation:
Information quality is maintained by Integrity Constraints.
Discuss this Question
3. A ___ constraint ensures that insertions, updates, and other processes are performed in a manner that does not compromise ___.
- Data Composition
- Data Interval
- Data Integrity
- Data Insertion
Answer: C) Data Integrity
Explanation:
A data integrity constraint ensures that insertions, updates, and other processes are performed in a manner that does not compromise data integrity.
Discuss this Question
4. An ___ prevents data from being accidentally damaged.
- Data Constraint
- Integrity Constraint
- Integrity Rule
- Data Rule
Answer: B) Integrity Constraint
Explanation:
An integrity constraint prevents data from being accidentally damaged.
Discuss this Question
5. How many types of integrity constraints are there?
- 3
- 4
- 5
- 6
Answer: B) 4
Explanation:
There are 4 types of integrity constraints.
Discuss this Question
6. Which of the following is NOT a type of integrity constraint?
- Domain Constraint
- Entity Integrity Constraint
- Key Constraint
- Primary Key Constraint
Answer: D) Primary Key Constraint
Explanation:
Primary Key Constraint is NOT a type of Integrity Constraint.
Discuss this Question
7. To include integrity constraint in an existing relation use ___.
- Drop table
- Modify table
- Alter table
- Create table
Answer: C) Alter table
Explanation:
To include integrity constraint in an existing relation use "Alter table".
Discuss this Question
8. Which of the following is not an integrity constraint?
- Not null
- Positive
- Unique
- Check 'predicate'
Answer: B) Positive
Explanation:
In the given values, the "Positive" is not an integrity constraint.
Discuss this Question
9. What is Domain Constraint?
- An attribute domain constraint can be described as a definition of a valid set of values for a particular attribute
- An attribute domain constraint can be described as a definition of a valid set of values for a particular row
- An attribute domain constraint can be described as a definition of a valid set of values for a particular table
- An attribute domain constraint can be described as a definition of a valid set of values for a particular database
Answer: A) An attribute domain constraint can be described as a definition of a valid set of values for a particular attribute
Discuss this Question
10. What does the data type of domain include?
- String
- Date
- Currency
- All of the above
Answer: D) All of the above
Explanation:
The data type of domain includes string, date, currency, etc.
Discuss this Question
11. In order for an __ to have a value, it must be available within the corresponding domain.
- Value
- Order
- Attribute
- Row
Answer: C) Attribute
Explanation:
In order for an attribute to have a value, it must be available within the corresponding domain.
Discuss this Question
12. What is the full form of EIC?
- Entity Internal Constraints
- Embedded Internal Constraints
- Entity Integrity Constraints
- Embedded Integrity Constraints
Answer: C) Entity Integrity Constraints
Explanation:
The full form of EIC is Entity Integrity Constraints.
Discuss this Question
13. What is TRUE about Entity Integrity Constraints?
- Primary key values cannot be null according to the entity integrity constraint.
- Primary key values can be null according to the entity integrity constraint.
- Primary key values cannot be zero according to the entity integrity constraint.
- None of the above
Answer: A) Primary key values cannot be null according to the entity integrity constraint
Discuss this Question
14. Identifying individual rows in a relation is based on the ___ value, and if the ___ is null, it will not be able to locate these rows.
- Primary Key
- Foreign Key
- Alternate Key
- Composite Key
Answer: A) Primary Key
Explanation:
Identifying individual rows in a relation is based on the primary key value, and if the primary key is null, it will not be able to locate these rows.
Discuss this Question
15. Other than the primary key field, Entity Integrity Constraints allow ___ values in tables.
- Zero
- One
- Null
- Two
Answer: C) Null
Explanation:
Other than the primary key field, Entity Integrity Constraints allow null values in tables.
Discuss this Question
16. What is the full form of RIC?
- Repetitive Integrity Constraints
- Referential Integrity Constraints
- Regional Integrity Constraints
- Relational Integrity Constraints
Answer: B) Referential Integrity Constraints
Explanation:
The full form of RIC is Referential Integrity Constraints.
Discuss this Question
17. The full form of RIC is Referential Integrity Constraints.
- One
- Two
- Three
- Four
Answer: B) Two
Explanation:
Two tables are constrained by referential integrity.
Discuss this Question
18. A ___ Key in Table 1 that refers to the Primary Key in Table 2 must either have null values or be available in Table 2. This is what Referential Integrity constraints require.
- Primary
- Alternate
- Foreign
- Composite
Answer: C) Foreign
Explanation:
A Foreign Key in Table 1 that refers to the Primary Key in Table 2 must either have zero values or be available in Table 2. This is what Referential Integrity constraints require.
Discuss this Question
19. Entities are uniquely identified in entity sets by ___.
- Methods
- Tables
- Tuples
- Keys
Answer: D) Keys
Explanation:
Entities are uniquely identified in entity sets by keys.
Discuss this Question
20. There can be multiple keys in an entity set, but only ___ of them will be the primary key.
- One
- Two
- Three
- Four
Answer: A) One
Explanation:
There can be multiple keys in an entity set, but only one of them will be the primary key.
Discuss this Question
21. Relational tables can include ___ primary keys.
- Only 1
- Only 2
- More than 2
- As many as you want
Answer: A) Only 1
Explanation:
Primary keys are always unique, it is used to identify the result uniquely and there is always one column in a table that can be marked as a primary key.
Discuss this Question