HPRCA JOA IT Keys, Tuples and Attributes PYQs

11 previous year questions on Keys, Tuples and Attributes (DBMS and SQL) in 7 HP Junior Office Assistant (IT) papers, 2026, 2022, 2021: 0.6% of all the JOA IT questions we hold.

Questions
11
Papers
7
Years
2021-2026

What to study in Keys, Tuples and Attributes

  • Entity, tuple, attribute, domain, degree, cardinality
  • Primary, foreign, candidate, super and composite keys

Keys, Tuples and Attributes questions by year

YearQuestions
20268
20222
20211

Sample Keys, Tuples and Attributes questions

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

Question 62 · Syllabus as per Essential Qualification

Which key can be a combination of multiple columns to ensure uniqueness?

  1. (A)Unique key
  2. (B)Super key
  3. (C)Foreign key
  4. (D)Composite key
Show in Hindi

विशिष्टता सुनिश्चित करने के लिए कौन-सी की (key) कई कॉलम का संयोजन हो सकती है?

  1. (A) यूनिक की (Unique key)
  2. (B) सुपर की (Super key)
  3. (C) फॉरेन की (Foreign key)
  4. (D) कम्पोजिट की (Composite key)

Question 64 · Syllabus as per Essential Qualification

Which attribute type is created by combining 'Street', 'City', and 'Zip code' component?

  1. (A)Composite attribute
  2. (B)Multivalued attribute
  3. (C)Simple attribute
  4. (D)Derived attribute
Show in Hindi

'Street', 'City' और 'Zip code' घटकों को मिलाकर किस प्रकार का एट्रिब्यूट टाइप (attribute type) बनाया जाता है?

  1. (A) कम्पोजिट एट्रिब्यूट (Composite attribute)
  2. (B) मल्टीवैल्यूड एट्रिब्यूट (Multivalued attribute)
  3. (C) सिंपल एट्रिब्यूट (Simple attribute)
  4. (D) डिराइव्ड एट्रिब्यूट (Derived attribute)

Papers with Keys, Tuples and Attributes questions

Frequently asked questions

How many Keys, Tuples and Attributes questions have come in JOA IT?
11 questions in 7 of the 16 papers on AiPYQs (2026, 2022, 2021), about 0.6% 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 Keys, Tuples and Attributes 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.