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
Year
Questions
2026
10
2022
3
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) का एक महत्वपूर्ण लाभ क्या है?
(A)यह ट्रांज़ैक्शन (transactions) की प्रोसेसिंग को धीमा कर दे ता है
(B)यह सुनिश्चित करता है कि डेटा यथार्थ और सुसंगत रहे
(C)यह डेटा का बैकअप लेना असंभव बना दे ता है
(D)यह रिकॉर्ड के डु प्लीकेशन (duplication) को बढ़ाता है
Show in English
What is a significant benefit of data integrity in a DBMS environment?
(A) It slows down processing of transactions
(B) It ensures data remains accurate and consistent
(C) It makes backup of data impossible
(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'?
(A)Entering January 15 as a date
(B)Entering March 1 as a date
(C)Entering February 30 as a date
(D)Entering December 31 as a date
Show in Hindi
'valid calendar dates' डोमेन वाले 'DateOfBirth' कॉलम के संदर्भ में, निम्नलिखित में से कौन-सा विकल्प डोमेन के उल्लंघन को दर्शाता है?
(A) तारीख के रूप में January 15 प्रविष्ट करना
(B) तारीख के रूप में March 1 प्रविष्ट करना
(C) तारीख के रूप में February 30 प्रविष्ट करना
(D) तारीख के रूप में December 31 प्रविष्ट करना
Papers with Data Models, Architecture and Normalisation 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.