Skip to content
MCQs on Integrity Constraints in DBMS
- What is an integrity constraint?
- a) A rule that limits the type of data that can be entered into a database
- b) A mechanism to improve database performance
- c) A software that manages the database
- d) A query language for databases
Answer: a) A rule that limits the type of data that can be entered into a database
- Which type of integrity constraint ensures that all values in a column are unique and not null?
- a) PRIMARY KEY
- b) UNIQUE
- c) FOREIGN KEY
- d) CHECK
Answer: a) PRIMARY KEY
- What is the purpose of a foreign key constraint?
- a) To ensure that all values in a column are unique
- b) To link two tables together
- c) To restrict the values that can be placed in a column
- d) To ensure that all columns have non-null values
Answer: b) To link two tables together
- Which integrity constraint enforces the domain integrity by limiting the values that can be placed in a column?
- a) PRIMARY KEY
- b) UNIQUE
- c) FOREIGN KEY
- d) CHECK
Answer: d) CHECK
- Which of the following is true about the NOT NULL constraint?
- a) It ensures that all values in a column are unique.
- b) It ensures that a column cannot have null values.
- c) It links two tables together.
- d) It restricts the values that can be placed in a column.
Answer: b) It ensures that a column cannot have null values.
- Which integrity constraint can be used to enforce referential integrity?
- a) PRIMARY KEY
- b) UNIQUE
- c) FOREIGN KEY
- d) CHECK
Answer: c) FOREIGN KEY
- What does the UNIQUE constraint do?
- a) Ensures that a column cannot have null values.
- b) Ensures that all values in a column are unique.
- c) Links two tables together.
- d) Limits the values that can be placed in a column.
Answer: b) Ensures that all values in a column are unique.
- Which integrity constraint ensures entity integrity?
- a) PRIMARY KEY
- b) UNIQUE
- c) FOREIGN KEY
- d) CHECK
Answer: a) PRIMARY KEY
- Which of the following statements about the PRIMARY KEY constraint is true?
- a) A table can have multiple primary keys.
- b) A table can have only one primary key.
- c) A primary key can have duplicate values.
- d) A primary key column can have null values.
Answer: b) A table can have only one primary key.
- Which integrity constraint ensures that the relationship between two tables remains consistent?
- a) PRIMARY KEY
- b) UNIQUE
- c) FOREIGN KEY
- d) CHECK
Answer: c) FOREIGN KEY
- Which of the following constraints ensures that all entries in a column are different?
- a) PRIMARY KEY
- b) NOT NULL
- c) UNIQUE
- d) FOREIGN KEY
Answer: c) UNIQUE
- What happens if a NOT NULL constraint is violated?
- a) The transaction is committed.
- b) The column value is automatically set to zero.
- c) The transaction is rolled back.
- d) A warning is generated, but the row is inserted.
Answer: c) The transaction is rolled back.
- What is the role of the CHECK constraint?
- a) To ensure that a column cannot have null values.
- b) To limit the values that can be placed in a column based on a specific condition.
- c) To ensure that all values in a column are unique.
- d) To link two tables together.
Answer: b) To limit the values that can be placed in a column based on a specific condition.
- Which constraint would you use to ensure that the values in a column match a specified condition?
- a) PRIMARY KEY
- b) UNIQUE
- c) FOREIGN KEY
- d) CHECK
Answer: d) CHECK
- Which integrity constraint is violated when a foreign key references a non-existent primary key value?
- a) Entity integrity
- b) Domain integrity
- c) Referential integrity
- d) Key integrity
Answer: c) Referential integrity
More MCQs Of Database Systems
- Database Models MCQs in DBMS
- Hierarchical model MCQs in DBMS
- Network model MCQs in DBMS
- Relational model MCQs in DBMS
- Object-oriented model MCQs in DBMS
- NoSQL databases MCQs in DBMS
- Relational Database Model MCQs in DBMS
- tables, attributes, tuples, and relations MCQs in DBMS
- Primary keys and foreign keys MCQs in DBMS
- Integrity constraints MCQs in DBMS
- SQL (Structured Query Language) MCQs in DBMS
- Data Definition Language (DDL) MCQs in DBMS
- Data Manipulation Language (DML) MCQs in DBMS
- Data Control Language (DCL) MCQs in DBMS
- Transaction Control Language (TCL) MCQs in DBMS
- Advanced SQL queries and functions MCQs in DBMS
- Database Design MCQs in DBMS
- Entity-Relationship (ER) modeling MCQs in DBMS
- Extended ER modeling MCQs in DBMS
- Normalization and normal forms (1NF, 2NF, 3NF, BCNF) MCQs in DBMS
- Denormalization MCQs in DBMS
- Database Management System Architecture MCQs in DBMS
- Three-schema architecture (external, conceptual, internal) MCQs in DBMS
- Data independence MCQs in DBMS
- DBMS components and functions MCQs in DBMS
- Storage and File Structure MCQs in DBMS
- Data storage on physical media MCQs in DBMS
- File organization and access methods MCQs
- Indexing (B-trees, hash indexing) MCQs in DBMS
- RAID technology MCQs in DBMS
- Query Processing and Optimization MCQs in DBMS
- Database Transaction Management MCQs in DBMS
- ACID properties (Atomicity, Consistency, Isolation, Durability) MCQs in DBMS
- Transaction states and lifecycle MCQs in DBMS
- Concurrency control techniques (locking, timestamping, multiversion) MCQs in DBMS
- Deadlock detection and resolution MCQs in DBMS
- Database Security and Authorization MCQs in DBMS
- Authentication and authorization mechanisms MCQs in DBMS
- Data encryption techniques MCQs in DBMS
- Role-based access control MCQs in DBMS
- SQL injection prevention MCQs in DBMS
- Backup and Recovery MCQs in DBMS
- Backup types and strategies MCQs in DBMS
- Recovery techniques (log-based, shadow paging) MCQs in DBMS
- Disaster recovery planning MCQs in DBMS
- Distributed Databases MCQs in DBMS
- Distributed database architecture MCQs MCQs in DBMS
- Data fragmentation, replication, and allocation in DBMS
- Distributed query processing MCQs in DBMS
- Consistency models and protocols MCQs in DBMS
- SET 1: database design mcqs (database design mcqs )
- SET 2: database mcqs with answers pdf (database mcqs with answers pdf )
- SET 3: modern database management 12th edition mcqs (modern database management 12th edition mcqs)
- SET 4: database systems mcqs (database systems mcqs)
- SET 5: dbms mcqs (dbms mcqs )
- SET 6: dbms mcqs with answers (dbms mcqs with answers)
- SET 7: solved mcqs of dbms (solved mcqs of dbms)
- SET 8: dbms mcqs with answers pdf(dbms mcqs with answers pdf)
- SET 9: relational database management system mcqs(relational database management system mcqs)
- SET 10: solved mcqs of database management system(solved mcqs of database management system)
- SET 11: basic database mcqs pdf (basic database mcqs pdf)
- SET 12: relational database management system mcqs (relational database management system mcqs )
- SET 13: database mcqs online test (database mcqs online test)
- SET 14: database interview questions mcqs (database interview questions mcqs)
- SET 15: database developer mcqs (database developer mcqs)
- SET 16: database Repeated mcqs (database Repeated mcqs)
- SET 17: Database mcqs PPSC (Database mcqs PPSC)
- SET 18: Database mcqs FPSC (Database mcqs FPSC)
- SET 19: DBMS mcqs FPSC (DBMS mcqs FPSC)
New Arrival
All Copyrights Reserved 2025 Reserved by T4Tutorials