37 previous year questions on SQL Commands and Queries (DBMS and SQL) in 11 HP Junior Office Assistant (IT) papers, 2026, 2025, 2022, 2021: 2% of all the JOA IT questions we hold.
WHERE, ORDER BY, GROUP BY, HAVING, DISTINCT, joins
SQL Commands and Queries questions by year
Year
Questions
2026
27
2025
1
2022
2
2021
7
Sample SQL Commands and Queries questions
Answers, explanations and all 37 questions are in the practice app.
Question 59 · Syllabus as per Essential Qualification
When switching from one database to another in a DBMS, which command should be executed?
(A)SELECT
(B)CHOOSE
(C)HIGHLIGHT
(D)USE
Show in Hindi
DBMS में एक डेटाबेस से दूसरे डेटाबेस पर स्विच करते समय, कौन-सी कमांड एक्सीक्यूट की जानी चाहिए?
(A) SELECT
(B) CHOOSE
(C) HIGHLIGHT
(D) USE
Question 59 · Syllabus as per Essential Qualification
In a database system, which aspect describes the ability to change the storage structure without affecting the application programs that use the data?
(A)Physical data independence
(B)Data redundancy
(C)Data consistency
(D)Logical data independence
Show in Hindi
डेटाबेस सिस्टम में, कौन-सा पहलू डेटा का उपयोग करने वाले एप्लिकेशन प्रोग्राम को प्रभावित किए बिना स्टोरेज स्ट्रक्चर (storage structure) को बदलने की क्षमता का वर्णन करता है?
(A) फिजिकल डेटा इंडिपेंडेंस (Physical data independence)
(B) डेटा रिडंडेंसी (Data redundancy)
(C) डेटा कंसिस्टेंसी (Data consistency)
(D) लॉजिकल डेटा इंडिपेंडेंस (Logical data independence)
How many SQL Commands and Queries questions have come in JOA IT?
37 questions in 11 of the 16 papers on AiPYQs (2026, 2025, 2022, 2021), about 2% 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 SQL Commands and Queries 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.