Here is a comprehensive bank of 30 Multiple Choice Questions (MCQs) designed precisely around the CBSE Class 10 IT (Code 402) Unit 3: RDBMS curriculum, complete with official board exam years (up to 2026) and textbook questions.
Q1. Which of the following is a primary benefit of using a Database Management System (DBMS)? (CBSE 2020)
A. It increases data duplication across tables.
B. It reduces data redundancy and controls unauthorized access.
C. It locks data so that files can never be shared.
D. It forces all data to be stored inside a single flat file.
🎓 Explanation: A DBMS eliminates “redundancy” (duplicate data) and secures data using user authentication.
Q2. A database structure that stores all of its information inside a single table without linking capabilities is called a: (CBSE 2022)
A. Relational Database
B. Hierarchical Database
C. Flat File Database
D. Network Database
🎓 Explanation: A flat-file database stores data in a single table (like an Excel sheet) and cannot form relationships between different tables.
Q3. Which database constraint guarantees that a column cannot accept NULL values and must hold unique values for every row? (CBSE 2023)
A. Foreign Key
B. Primary Key
C. Default Constraint
D. Check Constraint
🎓 Explanation: A Primary Key must contain completely unique values and can never be empty (cannot be NULL).
Q4. What is the fundamental purpose of a Foreign Key in a relational database? (CBSE 2024)
A. To uniquely identify every horizontal record within its own table.
B. To automatically encrypt password and text columns.
C. To establish and enforce a link between data across two separate tables.
D. To define the maximum data size allowed inside an alphanumeric field.
🎓 Explanation: A Foreign Key connects a child table to a parent table by pointing directly to the parent table’s Primary Key.
Q5. Which alphanumeric data type is ideal for storing extensive paragraphs, comments, or long descriptions? (CBSE 2020)
A. VARCHAR
B. CHAR
C. MEMO (LongVarChar)
D. BOOLEAN
🎓 Explanation: While VARCHAR is for short texts, MEMO is specifically used for massive blocks of text.
Q6. Which of the following SQL statements belongs to the Data Definition Language (DDL) category? (CBSE 2022)
A. SELECT
B. INSERT
C. UPDATE
D. CREATE TABLE
🎓 Explanation: DDL commands deal with the structural framework of the database. CREATE, ALTER, and DROP are DDL commands.
Q7. Which Data Manipulation Language (DML) command is used to read and fetch records from a database table? (CBSE 2023)
A. SELECT
B. ALTER
C. DROP
D. RENAME
🎓 Explanation: SELECT is a DML statement used to view or retrieve data values from a table without changing the structure.
Q8. In relational database terminology, a single horizontal row or record inside a table is formally called a: (CBSE 2024)
A. Tuple
B. Attribute
C. Relation
D. Domain
🎓 Explanation: In RDBMS vocabulary: Table = Relation, Row = Tuple, and Column = Attribute.
Q9. A vertical column within a relational database table that represents a specific characteristic is known as a(n): (CBSE 2020)
A. Tuple
B. Attribute
C. Relation
D. Cardinality
🎓 Explanation: Columns define characteristics or properties of the entries, which are formally called attributes.
Q10. Which database property ensures that data values remain completely accurate, valid, and reliable over time? (CBSE 2022)
A. Data Redundancy
B. Data Inconsistency
C. Data Integrity
D. Data Isolation
🎓 Explanation: “Integrity” means keeping the data uncorrupted, valid, and accurate across the database system.
Q11. When a Primary Key is built by combining two or more distinct columns together in a table, it is referred to as a: (CBSE 2023)
A. Foreign Key
B. Composite Primary Key
C. Candidate Key
D. Alternate Key
🎓 Explanation: A primary key made up of multiple fields joined together is called a “Composite Primary Key”.
Q12. Which data type must be selected if you want to store structural calendar tracking information such as a student’s Date_of_Birth? (CBSE 2024)
A. VARCHAR
B. DATE
C. INTEGER
D. LONGVARBINARY
🎓 Explanation: The DATE data type is specially formatted to hold calendar values like days, months, and years safely.
Q13. Which command is used to modify or change existing cell records that are already stored in a table? (CBSE 2020)
A. INSERT
B. ALTER
C. UPDATE
D. SELECT
🎓 Explanation: UPDATE modifies existing row values, while INSERT adds entirely new rows, and ALTER modifies structural columns.
Q14. Which command permanently deletes a specific record/row entry from a table while leaving the structural columns completely intact? (CBSE 2022)
A. DROP
B. REMOVE
C. ALTER
D. DELETE
🎓 Explanation: DELETE clears raw data records out of a table. DROP destroys the entire table schema.
Q15. In a database relationship, the “one” side is represented by the parent table containing the Primary Key, while the “many” side is represented by the child table containing the: (CBSE 2021)
A. Alternate Key
B. Foreign Key
C. Candidate Key
D. Composite Key
🎓 Explanation: Remember the golden rule: One side = Parent (Primary Key) vs. Many side = Child (Foreign Key).
Q16. Dedicated computers that hold the actual databases and run only the DBMS and related software are called: (CBSE 2025)
A. Front-ends
B. Database Servers
C. Web Browsers
D. Flat Clients
🎓 Explanation: Database servers are the dedicated back-end machines that host the software and actual database files.
Q17. In the client-server model of database access, the graphic user interface (GUI) or command line tool is referred to as the: (CBSE 2025)
A. Front-end
B. Back-end
C. Repository
D. Schema
🎓 Explanation: User-facing interfaces used to access data are called front-ends, while the server is called the back-end.
Q18. Data consistency means that there should be no: (CBSE 2021)
A. Text characters stored in numeric columns
B. Password protection on rows
C. Multiple mismatching copies of the same data
D. Tables with missing primary keys
🎓 Explanation: Consistency ensures that if data is duplicated or updated, mismatching copies do not exist across different files.
Q19. Which data type category should be used to store images, photos, or music files in a database? (CBSE 2023)
A. Alphanumeric Types
B. Binary Types
C. Numeric Types
D. Date Time Types
🎓 Explanation: Binary types (like LongVarBinary or Image) are used to store media files in raw binary format.
Q20. Which of the following is NOT an alphanumeric data type in LibreOffice Base? (CBSE 2022)
A. CHAR
B. VARCHAR
C. VARCHAR_IGNORECASE
D. TINYINT
🎓 Explanation: TINYINT belongs to the Numeric data type category, not Alphanumeric.
Q21. Which SQL command is used to add a new column like BloodGroup into an existing table? (CBSE 2026)
A. UPDATE
B. ALTER
C. CREATE
D. INSERT
🎓 Explanation: The ALTER statement is a DDL command used to add, delete, or modify columns in an existing table structure.
Q22. What character symbol is used in a SQL SELECT statement to fetch and display all columns from a table? (CBSE 2024)
A. Ampersand (&)
B. Percent (%)
C. Asterisk (*)
D. Hash (#)
🎓 Explanation: SELECT * FROM TableName uses the asterisk wildcard symbol to pull every field from that table.
Q23. If you want to remove all records from a table to clear its information but keep the table’s empty structural columns intact, which statement should you use? (CBSE 2026)
A. DROP TABLE
B. TRUNCATE TABLE
C. REMOVE TABLE
D. ALTER TABLE
🎓 Explanation: TRUNCATE deletes all rows inside a table but preserves the structure, unlike DROP which deletes everything permanently.
Q24. In DML types, a “Non-Procedural” DML means that: (Model Question)
A. The user specifies what data is needed and exactly how to get it.
B. The user only specifies what data is needed without stating how to get it.
C. The user creates structural schema models.
D. The database processes data manually.
🎓 Explanation: Non-procedural languages (like SQL) let users specify “what” they want, leaving the “how” to the software.
Q25. Which numeric data type can be used to store logical states that accept only values like ‘Yes’ or ‘No’ / ‘True’ or ‘False’? (Model Question)
A. Boolean
B. Real
C. Float
D. SmallInt
🎓 Explanation: Boolean is a special numeric subtype used strictly for binary true/false conditions.
Q26. A database contains objects that are used for storing and managing information. Which of the following is an example of a database application program? (CBSE 2021)
A. Microsoft Word
B. OpenOffice.org Base
C. Microsoft PowerPoint
D. Adobe Photoshop
🎓 Explanation: OpenOffice Base, MS Access, and MySQL are standard database programs.
Q27. Consider the command: DELETE FROM Student WHERE RollNo = 5;. This statement is classified as a: (CBSE 2025)
A. DDL Command
B. DML Command
C. DCL Command
D. TCL Command
🎓 Explanation: DELETE interacts directly with row data records, making it a Data Manipulation Language (DML) command.
Q28. The total number of attributes (columns) present inside a relation table is known as its: (Model Question)
A. Cardinality
B. Degree
C. Domain
D. Tuple
🎓 Explanation: Degree refers to the number of columns, while Cardinality refers to the total number of rows (tuples) in a table.
Q29. What happens if you execute the command DROP DATABASE Employee;? (Model Question)
A. Only the records inside the database are erased.
B. The database structure is hidden but can be recovered.
C. Complete information and tables present in the database are permanently lost.
D. The database structure is renamed to ‘Employee_Old’.
🎓 Explanation: DROP DATABASE completely destroys both the data and the structural architecture permanently.
Q30. Any field/column that possesses the necessary unique traits to become a primary key is known as a: (Model Question)
A. Foreign Key
B. Candidate Key
C. Alternate Key
D. Composite Key
🎓 Explanation: All unique columns capable of serving as a Primary Key are called Candidate Keys. The one selected becomes the Primary Key, and the rest become Alternate Keys.