Multiple Tables: Class 10 PYQs 2024–2026 with solutions
All 4 CBSE board questions asked from Multiple Tables in 3 board papers, with the year, set and marks of each. 4 are solved free below. The Class 10 Information Technology PYQ Book: Solved Board Papers 2024-2026 (CBSE) has every solution, all chapters and 3 full board papers.
Multiple Tables: board weightage
Board weightage 2024–2026
| Year | 2024 | 2025 | 2026 |
|---|---|---|---|
| Questions | 2 | 2 | 2 |
| Marks | 3 | 6 | 5 |
Most asked topics
6 questions from 3 papers. Repeated questions are shown once with every year they were asked.
1 mark: objective
While forming a relationship between two tables in Base, the ____ of the common field must be ____. (A) same, data type (B) data type, same (C) data type, different (D) primary key, same
Solution
(B) data type, same.
In Base, the relationship applied on tables can be removed with the ____ option.
Solution
Delete (right-click the relation line → Delete).
2 marks: short answer
What are the important prerequisites for setting a relationship between two tables in Base? Mention any two.
Solution
(a) Both tables must have a common column. (b) The data type of the common field must be the same in both tables.
Give any two benefits of creating relationships between tables.
Solution
(1) Saves time, as the same data need not be entered in separate tables (reduces redundancy). (2) Helps in summarising data from related tables. (Also: reduces inconsistency, maintains integrity, allows sharing, centralised control.)
4 marks: long answer
Get every solution for all chapters
- Every board question of every chapter, each fully solved the way the board gives marks
- 3 complete board papers, each followed by its solutions
- Weightage and most-asked topics for every chapter
- Instant PDF download, colour and black & white print copies
Revising the chapter first? Complete Information Technology (402) Notes for Class 10 (CBSE 2026-27) →
What you get in the pack
- CBSE Class 10 Information Technology board papers 2024 to 2026 (3 full board papers)
- All 20 chapters and 3 board papers complete
- Part A: all 20 chapters, questions sorted chapter-wise and by marks
- Year-wise weightage table and most-asked topics for every chapter
- Part B: each full board paper followed by its complete solutions
- Exact menu paths for Writer, Calc and Base practicals
- Only the current syllabus in Part A
All chapters in this pack
- PYQ Ch 1 Communication Skills II
- PYQ Ch 2 Self-Management Skills II
- PYQ Ch 3 ICT Skills II
- PYQ Ch 4 Entrepreneurial Skills II
- PYQ Ch 5 Green Skills II
- PYQ Ch 6 Introduction to Styles
- PYQ Ch 7 Working with Images
- PYQ Ch 8 Advanced Features of Writer
- PYQ Ch 9 Scenarios and Goal Seek
- PYQ Ch 10 Macros
- PYQ Ch 11 Linking Spreadsheet Data
- PYQ Ch 12 Share and Review
- PYQ Ch 13 Introduction to DBMS
- PYQ Ch 14 Starting with Base
- PYQ Ch 15 Multiple Tables
- PYQ Ch 16 Queries in Base
- PYQ Ch 17 Forms and Reports
- PYQ Ch 18 Health, Safety and Security
- PYQ Ch 19 Workplace Quality Measures
- PYQ Ch 20 Accidents and Emergencies
- Board Paper 2026 Set 402 with Solutions
- Board Paper 2025 Set 402 with Solutions
- Board Paper 2024 Set 402 with Solutions