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

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.

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.

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