15 previous year questions on MySQL and MS Access (DBMS and SQL) in 5 HP Junior Office Assistant (IT) papers, 2026, 2022, 2021: 0.8% of all the JOA IT questions we hold.
Questions
15
Papers
5
Years
2021-2026
What to study in MySQL and MS Access
MySQL: features, creating, selecting, deleting and showing databases
MS Access: tables, queries, forms, reports
MySQL and MS Access questions by year
Year
Questions
2026
4
2022
6
2021
5
Sample MySQL and MS Access questions
Answers, explanations and all 15 questions are in the practice app.
Question 61 · Syllabus as per Essential Qualification
जब कई यूजर समान डेटा को एक्सेस करते हैं, तो DBMS डेटा कंसिस्टेंसी (data consistency) को किस प्रकार बनाए रखता है?
(A)यह केवल बैच (batches) में परिवर्तनों को प्रोसेस करता है
(B)यह एरर से बचने के लिए यूजर कोऑर्डिनेशन (user coordination) पर निर्भर करता है
(C)यह प्रत्येक यूजर को रैंडम अपडेट की सुविधा दे ता है
(D)यह ट्रांजैक्शन मैनेजमेंट और कंकरेंसी कंट्रोल का उपयोग करता है
Show in English
How does a DBMS maintain data consistency when multiple users access the same data?
(A) It processes changes only in batches
(B) It relies on user coordination to avoid errors
(C) It allows random updates by each user
(D) It uses transaction management and concurrency control
Question 59 · Syllabus as per Essential Qualification
Which combination best describes the primary objectives of a DBMS?
(A)Data integrity and efficient data access
(B)User authentication and network security
(C)Data compression and backup
(D)Data visualization and reporting
Show in Hindi
निम्नलिखित में से कौन-सा संयोजन DBMS के प्राथमिक उद्देश्यों का सर्वोत्तम वर्णन करता है?
How many MySQL and MS Access questions have come in JOA IT?
15 questions in 5 of the 16 papers on AiPYQs (2026, 2022, 2021), about 0.8% of all JOA IT questions we hold.
Are these the official JOA IT previous year papers?
No. They are memory-based sample papers submitted by students for analysis, not official papers. Answers in the practice app are labelled with their source.
Where can I practise MySQL and MS Access PYQs with answers?
In the AiPYQs practice app: sign in with Google and the first 50 questions of JOA IT are free every day. The exam plan unlocks every question with answers, AI Insights and a study planner.