🧩 Section A: Multiple Choice Questions (1 Mark Each)
1. What does DBMS stand for?
a) Data Basic Management System
b) Database Management System
c) Data Base Manipulation Software
d) Data Binary Management System
2. Which of the following is an example of DBMS software?
a) MS Excel
b) MS Access
c) MS Word
d) PowerPoint
3. A database is a collection of _______.
a) Programs
b) Data
c) Numbers
d) Files only
4. The smallest unit of data in a database is:
a) Record
b) Field
c) Character
d) File
5. A record in a database corresponds to a:
a) Row
b) Column
c) Table
d) Query
6. In a database table, columns are called:
a) Records
b) Fields
c) Entries
d) Keys
7. Which of the following uniquely identifies a record in a table?
a) Foreign Key
b) Candidate Key
c) Primary Key
d) Super Key
8. Which of these is NOT a DBMS software?
a) Oracle
b) MySQL
c) MS Access
d) Notepad
9. Data stored in rows and columns form a:
a) Table
b) Form
c) Query
d) Report
10. What is a “Form” in a DBMS?
a) Used to enter data
b) Used to print data
c) Used to delete database
d) Used to backup database
11. Which of these is used to extract information from a database?
a) Report
b) Table
c) Query
d) Form
12. In MS Access, a “Query” is used to:
a) View specific data
b) Delete database
c) Design tables
d) None of these
13. Which of the following is a type of database relationship?
a) One-to-one
b) One-to-many
c) Many-to-many
d) All of the above
14. Which field type can store numbers in Access?
a) Text
b) Number
c) Memo
d) Yes/No
15. What is the extension of an Access database file?
a) .mdb
b) .accdb
c) .db
d) .txt
16. In DBMS, data redundancy means:
a) Duplicate data
b) Missing data
c) Linked data
d) None of these
17. The process of organizing data to avoid redundancy is called:
a) Structuring
b) Normalization
c) Repetition
d) Grouping
18. DBMS reduces _______.
a) Security
b) Redundancy
c) Accuracy
d) Reliability
19. The “Save” command in Access stores data in:
a) Report
b) Table
c) Form
d) Query
20. Which of the following statements is true?
a) DBMS cannot handle large data
b) DBMS improves data sharing
c) DBMS increases data redundancy
d) DBMS reduces data security
21. A “Report” in DBMS is used to:
a) Enter data
b) Present data in printable form
c) Create new tables
d) Modify records
22. In a table, a set of related fields is called:
a) Record
b) Key
c) Query
d) Form
23. Which of these is not a data type in Access?
a) Currency
b) Memo
c) Boolean
d) Paragraph
24. Data integrity means:
a) Data accuracy and consistency
b) Data duplication
c) Data deletion
d) Data storage
25. The SQL command used to retrieve data is:
a) SELECT
b) UPDATE
c) INSERT
d) DELETE
26. What does SQL stand for?
a) Structured Query Language
b) Standard Question Language
c) Simple Query Logic
d) Sequential Query Language
27. Which key combination saves a record in Access?
a) Ctrl + S
b) Shift + S
c) Alt + S
d) F1
28. Which data type stores dates in Access?
a) Date/Time
b) Date Only
c) Time Only
d) Text
29. Which symbol is used for wildcard in Access queries?
a) *
b) #
c) &
d) %
30. Referential integrity ensures:
a) Accuracy of data between related tables
b) Speed of queries
c) Storage of backup
d) Printing of reports
🧠 Section B: Fill in the Blanks (10 Questions)
31. A ___________ is a software used to manage a database.
32. In a database, each row represents a ___________.
33. Each column in a table is known as a ___________.
34. The key that uniquely identifies a record is called ___________.
35. A ___________ is used to search and extract information.
36. The process of reducing redundancy is called ___________.
37. The language used for querying databases is ___________.
38. The “Report” in Access is used for ___________.
39. MS Access files are saved with the extension ___________.
40. ___________ relationships connect multiple tables in DBMS.
✅ Section C: True or False (10 Questions)
41. A table can have multiple primary keys.
42. A query helps to sort and filter data.
43. Forms are used only to print data.
44. Data redundancy improves data accuracy.
45. MS Access is an example of RDBMS.
46. Reports are dynamic and used for data entry.
47. Data in DBMS can be easily shared among users.
48. Referential integrity prevents orphan records.
49. The field size property defines maximum characters in a field.
50. Memo field type stores large text data.
🧮 Section D: Short Answer Questions (2 Marks Each)
51. Define database and give two examples.
52. Explain the difference between a table and a query.
53. What is a primary key? Give an example.
54. Write two advantages of using DBMS.
55. What is normalization? Why is it important?
56. Define referential integrity.
57. What are forms used for in a database?
58. Differentiate between data and information.
59. Explain one-to-many relationship with example.
60. Write the purpose of “Reports” in a DBMS.
🧾 Section E: Application-Based / Case Study Questions (2–3
Marks Each)
61. A school maintains data of students such as Roll No, Name, Class, and Fees Paid.
Identify the primary key.
Suggest a suitable data type for each field.
62. A hospital database stores patient records. Explain how queries can help the staff.
63. Write SQL commands to:
Create a table named “Employee”.
Add columns: Emp_ID, Name, Salary.
64. Explain how referential integrity is maintained between “Customer” and “Orders” tables.
65. Write two differences between Flat File and Relational Database.
66. How can reports be useful for a shopkeeper maintaining daily sales data?
67. Create a table for “Library” with suitable fields.
68. Explain the term “Data Redundancy” with an example.
69. How can Access Forms make data entry easier for non-technical users?
70. Differentiate between Data, Database, and DBMS with examples.