Forms, Queries & Reports MCQs – DBMS Chapter-wise MCQ Set
Forms, Queries & Reports MCQs – DBMS Chapter-wise MCQ Set
Course: CBSE Class 10 Computer Science – MCQs with Answers and Explanations
Unit 3: Database Management System (DBMS)
Topic: Forms, Queries & Reports
Examination Board: CBSE Board Examinations
Unit 3: Database Management System (DBMS)
Topic: Forms, Queries & Reports
Examination Board: CBSE Board Examinations
1. A Form in DBMS is mainly used for:
Answer: B. Entering and editing data
Explanation: Forms provide a user-friendly interface to insert, modify, and view records easily.
Explanation: Forms provide a user-friendly interface to insert, modify, and view records easily.
2. A Query is used to:
Answer: B. Retrieve specific data
Explanation: Queries help filter and extract required information using conditions.
Explanation: Queries help filter and extract required information using conditions.
3. Reports are mainly used for:
Answer: C. Data presentation and printing
Explanation: Reports organize and format data for printing and sharing.
Explanation: Reports organize and format data for printing and sharing.
4. Which object allows data filtering?
Answer: C. Query
Explanation: Queries use criteria to filter records.
Explanation: Queries use criteria to filter records.
5. Forms are linked to:
Answer: B. Tables or Queries
Explanation: Forms fetch data from tables or queries.
Explanation: Forms fetch data from tables or queries.
6. Which feature allows searching records in a form?
Answer: A. Filter
Explanation: Filter helps display selected records.
Explanation: Filter helps display selected records.
7. Which view is used to modify structure of a form?
Answer: B. Design View
Explanation: Design View allows editing layout and controls.
Explanation: Design View allows editing layout and controls.
8. Queries are based on:
Answer: A. Conditions
Explanation: Conditions define which records to display.
Explanation: Conditions define which records to display.
9. Reports are generated from:
Answer: A. Tables/Queries
Explanation: Reports organize data from tables or queries.
Explanation: Reports organize data from tables or queries.
10. Which object improves user interaction?
Answer: B. Form
Explanation: Forms provide easy data entry interface.
Explanation: Forms provide easy data entry interface.
11. Query criteria is applied in:
Answer: C. Criteria Row
Explanation: Conditions are entered in the criteria row.
Explanation: Conditions are entered in the criteria row.
12. Which symbol is used for wildcards in queries?
Answer: A. *
Explanation: * represents multiple characters in search patterns.
Explanation: * represents multiple characters in search patterns.
13. Reports are best suited for:
Answer: B. Printing formatted data
Explanation: Reports format data professionally.
Explanation: Reports format data professionally.
14. Which object is not used for data modification?
Answer: C. Report
Explanation: Reports are for viewing/printing only.
Explanation: Reports are for viewing/printing only.
15. Forms can include:
Answer: D. All of these
Explanation: Forms contain controls like text boxes and buttons.
Explanation: Forms contain controls like text boxes and buttons.
16. Query design helps in:
Answer: A. Filtering records
Explanation: Query design allows applying criteria.
Explanation: Query design allows applying criteria.
17. Which object summarizes data?
Answer: B. Report
Explanation: Reports can group and summarize records.
Explanation: Reports can group and summarize records.
18. Which object displays records in tabular form?
Answer: C. Query Datasheet
Explanation: Query results appear in datasheet format.
Explanation: Query results appear in datasheet format.
19. Which tool is used to print student result sheet?
Answer: B. Report
Explanation: Reports format data for printing.
Explanation: Reports format data for printing.
20. Forms help reduce:
Answer: A. User errors
Explanation: Forms guide users during data entry, reducing mistakes.
Explanation: Forms guide users during data entry, reducing mistakes.
