Chapter 8: Relational Database Management System RDBMS — Online MCQ Test
INFORMATION TECHNOLOGY · Grade 10 · CBSE(NCERT)
Practice Chapter 8: Relational Database Management System RDBMS with a free chapter-wise online MCQ test.
This chapter covers: Database RDBMS LibreOffice Base Tables Queries Forms Reports Primary Key Records Fields Data Management.
AI-generated questions from basic to board-exam level, with instant results and explanations.
Chapter 8: Relational Database Management System RDBMS — Important Questions & Answers
In a database table, a row is commonly called a ________.
- A. record
- B. field
- C. query
- D. report
Answer: A. record
A row in a table stores complete information about one item or entity and is called a record.
A row in a table stores complete information about one item or entity and is called a record.
Which LibreOffice application is used to create and manage databases?
- A. LibreOffice Writer
- B. LibreOffice Calc
- C. LibreOffice Base
- D. LibreOffice Impress
Answer: C. LibreOffice Base
LibreOffice Base is the database management application used for creating tables, queries, forms and reports.
LibreOffice Base is the database management application used for creating tables, queries, forms and reports.
What does RDBMS stand for?
- A. Record Database Management System
- B. Relational Database Management System
- C. Regular Data Backup Management System
- D. Relational Data Basic Management Software
Answer: B. Relational Database Management System
RDBMS stands for Relational Database Management System, where data is stored in related tables.
RDBMS stands for Relational Database Management System, where data is stored in related tables.
Which of the following is used to uniquely identify each record in a table?
- A. Form
- B. Report
- C. Primary key
- D. Query
Answer: C. Primary key
A primary key uniquely identifies each record in a database table.
A primary key uniquely identifies each record in a database table.
A school wants to store student details like Roll Number, Name, Class and Date of Birth. Which object should be created first in LibreOffice Base?
- A. Report
- B. Table
- C. Form
- D. Query
Answer: B. Table
Data is first stored in tables. Forms, queries and reports usually depend on the data stored in tables.
Data is first stored in tables. Forms, queries and reports usually depend on the data stored in tables.
Which of the following is the most suitable primary key for a Student table?
- A. Student Name
- B. Roll Number
- C. Class
- D. Address
Answer: B. Roll Number
Roll Number is suitable as a primary key because it is expected to be unique for each student.
Roll Number is suitable as a primary key because it is expected to be unique for each student.
A database has two tables: Students and Marks. StudentID is primary key in Students and is also stored in Marks. What is the purpose of storing StudentID in Marks?
- A. To create duplicate records unnecessarily
- B. To relate marks with the correct student
- C. To convert marks into text
- D. To remove the need for a table
Answer: B. To relate marks with the correct student
A common field like StudentID helps connect related records in two tables.
A common field like StudentID helps connect related records in two tables.
Which option best describes the difference between a table and a form?
- A. A table stores data, while a form provides a user-friendly way to enter or view data
- B. A form stores data permanently, while a table only prints data
- C. A table is used only for reports, while a form is used only for queries
- D. There is no difference between a table and a form
Answer: A. A table stores data, while a form provides a user-friendly way to enter or view data
Tables store actual data, whereas forms are interfaces used to interact with that data.
Tables store actual data, whereas forms are interfaces used to interact with that data.
A Student table has fields RollNo, Name, Class and Email. RollNo is set as the primary key. Which data entry will definitely violate the primary key rule?
- A. Entering two students with the same Class
- B. Entering two students with the same Name
- C. Entering two records with the same RollNo
- D. Entering an Email field as blank
Answer: C. Entering two records with the same RollNo
A primary key cannot contain duplicate values, so two records cannot have the same RollNo.
A primary key cannot contain duplicate values, so two records cannot have the same RollNo.
A query has the condition Class = 10 AND Marks > 75. Which record will be selected?
- A. Class 10, Marks 70
- B. Class 9, Marks 90
- C. Class 10, Marks 82
- D. Class 8, Marks 76
Answer: C. Class 10, Marks 82
With AND, both conditions must be true. Only the record with Class 10 and Marks 82 satisfies both conditions.
With AND, both conditions must be true. Only the record with Class 10 and Marks 82 satisfies both conditions.