HPRCA JOA IT MySQL and MS Access PYQs

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

YearQuestions
20264
20226
20215

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) को किस प्रकार बनाए रखता है?

  1. (A)यह केवल बैच (batches) में परिवर्तनों को प्रोसेस करता है
  2. (B)यह एरर से बचने के लिए यूजर कोऑर्डिनेशन (user coordination) पर निर्भर करता है
  3. (C)यह प्रत्येक यूजर को रैंडम अपडेट की सुविधा दे ता है
  4. (D)यह ट्रांजैक्शन मैनेजमेंट और कंकरेंसी कंट्रोल का उपयोग करता है
Show in English

How does a DBMS maintain data consistency when multiple users access the same data?

  1. (A) It processes changes only in batches
  2. (B) It relies on user coordination to avoid errors
  3. (C) It allows random updates by each user
  4. (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?

  1. (A)Data integrity and efficient data access
  2. (B)User authentication and network security
  3. (C)Data compression and backup
  4. (D)Data visualization and reporting
Show in Hindi

निम्नलिखित में से कौन-सा संयोजन DBMS के प्राथमिक उद्देश्यों का सर्वोत्तम वर्णन करता है?

  1. (A) डेटा इंटीग्रिटी और एफीसिएंट डेटा एक्सेस
  2. (B) यूजर ऑथेंटिकेशन और नेटवर्क सिक्योरिटी
  3. (C) डेटा कम्प्रेशन और बैकअप
  4. (D) डेटा विज़ुअलाइज़ेशन और रिपोर्टिंग

Papers with MySQL and MS Access questions

Frequently asked questions

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.