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