Chapter Exam

Chapter 8: Relational Database Management System RDBMS — Online MCQ Test

Q: In a database table, a row is commonly called a ________.

Answer: A. record — A row in a table stores complete information about one item or entity and is called a record.

Q: Which LibreOffice application is used to create and manage databases?

Answer: C. LibreOffice Base — LibreOffice Base is the database management application used for creating tables, queries, forms and reports.

Q: What does RDBMS stand for?

Answer: B. Relational Database Management System — RDBMS stands for Relational Database Management System, where data is stored in related tables.

Q: Which of the following is used to uniquely identify each record in a table?

Answer: C. Primary key — A primary key uniquely identifies each record in a database table.

Q: 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?

Answer: B. Table — Data is first stored in tables. Forms, queries and reports usually depend on the data stored in tables.

Q: Which of the following is the most suitable primary key for a Student table?

Answer: B. Roll Number — Roll Number is suitable as a primary key because it is expected to be unique for each student.

Q: 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?

Answer: B. To relate marks with the correct student — A common field like StudentID helps connect related records in two tables.

Q: 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?

Answer: C. Entering two records with the same RollNo — A primary key cannot contain duplicate values, so two records cannot have the same RollNo.

Q: A query has the condition Class = 10 AND Marks > 75. Which record will be selected?

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.

INFORMATION TECHNOLOGY · Grade 10 · CBSE(NCERT)

Practice Chapter 8: Relational Database Management System RDBMS with a free chapter-wise online MCQ test for CBSE(NCERT) Grade 10 INFORMATION TECHNOLOGY. 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.

Questions

20m

Time Limit

Attempts Left

10 random questions from this chapter (mixed difficulty)
Questions you've seen before won't repeat until the pool resets
You have 20 minutes — exam auto-submits when time is up
Maximum 3 attempts per chapter
Results and explanations shown immediately after submission

New here? Register free — includes 3 free chapter exams.

Chapter 8: Relational Database Management System RDBMS — Important Questions & Answers (FAQ)

Frequently asked questions from CBSE(NCERT) Grade 10 INFORMATION TECHNOLOGY — Chapter 8: Relational Database Management System RDBMS, with answers and explanations. These are sample questions; the exam has its own separate question set.

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.

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.

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.

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 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.

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.

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.

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.

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?