HPRCA JOA IT Data Models, Architecture and Normalisation PYQs

13 previous year questions on Data Models, Architecture and Normalisation (DBMS and SQL) in 8 HP Junior Office Assistant (IT) papers, 2026, 2022: 0.7% of all the JOA IT questions we hold.

Questions
13
Papers
8
Years
2022-2026

What to study in Data Models, Architecture and Normalisation

  • Three-level architecture, schema, instance
  • Logical and physical data independence
  • Hierarchical, network, relational and ER models
  • Normalisation (1NF, 2NF, 3NF)

Data Models, Architecture and Normalisation questions by year

YearQuestions
202610
20223

Sample Data Models, Architecture and Normalisation questions

Answers, explanations and all 13 questions are in the practice app.

Question 60 · Syllabus as per Essential Qualification

DBMS एनवायरनमेंट में डेटा इंटीग्रिटी (data integrity) का एक महत्वपूर्ण लाभ क्या है?

  1. (A)यह ट्रांज़ैक्शन (transactions) की प्रोसेसिंग को धीमा कर दे ता है
  2. (B)यह सुनिश्चित करता है कि डेटा यथार्थ और सुसंगत रहे
  3. (C)यह डेटा का बैकअप लेना असंभव बना दे ता है
  4. (D)यह रिकॉर्ड के डु प्लीकेशन (duplication) को बढ़ाता है
Show in English

What is a significant benefit of data integrity in a DBMS environment?

  1. (A) It slows down processing of transactions
  2. (B) It ensures data remains accurate and consistent
  3. (C) It makes backup of data impossible
  4. (D) It increases duplication of records

Question 62 · Syllabus as per Essential Qualification

Which of the following illustrates a violation of a domain in the context of a 'DateOfBirth' column with the domain 'valid calendar dates'?

  1. (A)Entering January 15 as a date
  2. (B)Entering March 1 as a date
  3. (C)Entering February 30 as a date
  4. (D)Entering December 31 as a date
Show in Hindi

'valid calendar dates' डोमेन वाले 'DateOfBirth' कॉलम के संदर्भ में, निम्नलिखित में से कौन-सा विकल्प डोमेन के उल्लंघन को दर्शाता है?

  1. (A) तारीख के रूप में January 15 प्रविष्ट करना
  2. (B) तारीख के रूप में March 1 प्रविष्ट करना
  3. (C) तारीख के रूप में February 30 प्रविष्ट करना
  4. (D) तारीख के रूप में December 31 प्रविष्ट करना

Papers with Data Models, Architecture and Normalisation questions

Frequently asked questions

How many Data Models, Architecture and Normalisation questions have come in JOA IT?
13 questions in 8 of the 16 papers on AiPYQs (2026, 2022), about 0.7% 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 Data Models, Architecture and Normalisation 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.