JAC 12th Computer Science Important Questions Unit 3

JAC 12th Computer Science Important Questions Unit 3 : झारखण्ड बोर्ड कक्षा 12th सभी विद्यार्थियों के लिए Computer Science में unit 3 Database and SQL के पिछले वर्षो में जो भी प्रश्न पूछे गए हैं, उनकी चर्चा हम इसमें करेंगे तो इन Important Questions को पढ़ लीजिए.

IMG 20221228 WA0015
JAC 12th Computer Science Important Questions Unit 3

रांची: झारखंड एकेडमिक काउंसिल ( JAC Board) कक्षा JAC 12th Computer Science Important Questions के पिछले वर्षों के सभी महत्वपूर्ण प्रश्न (important Questions) आपको यहाँ पर बताए जा रहे है, जो बोर्ड परीक्षा 2023 के लिए बहुत महत्वपूर्ण है. अगर आप इन सभी प्रश्नों को याद कर लेते हो तो अवश्य ही आप JAC Board class 12th Computer Science  Exam 2023 में अच्छे अंक प्राप्त कर सकते हो.

विद्यार्थी इसका उत्तर स्वयं करें। ये सारे प्रश्न आपके परीक्षा (JAC 12th Computer Science Important Questions For Board Exams)में बार – बार पूछे जा रहे है। इसमें आपको सभी chapter का अलग-अलग पिछले 11 वर्षों के महत्वपूर्ण प्रश्न मिलेंगे। यानि 2009-2020 इसमें आपको ये भी बताया जा रहा है कि कौन से प्रश्न किस तरह केJAC 12th Computer Science Important Questions पूछे जा रहें है..

Join TelegramJoin Now
Join WhatsApp Join Now

JAC 12th Computer Science Important Questions Unit 3 -Overview

Name of OrganisationJharkhand Academic Council Ranchi
CategoryImportant Question
ArticleJAC 12th Computer Science Important Questions
StateJharkhand
Question TypesPrevious Year & Important Questions
Class12th(Inter)
StreamScience
SubjectComputer Science
Chapter Unit 3
Chapter NameDatabase and SQL
TelegramJoin Us
Overview

परीक्षा की तैयारी करने के टिप्स-

  • Study Schedule बनाएं : एक Study schedule बनाए ताकि आप जेएसी(JAC Board) 12वीं routine 2023 की सहायता से पहले ही पूरा syllabus कवर कर सके, परीक्षा से पहले सिलेबस को पूरा करने से revision के लिए पर्याप्त समय मिलेगा.
  • Short Notes बनाएं : विषयों को Important Point में सारांशित करके छोटे नोट्स बनाने से रिवीजन भाग को आसान बनाने में मदद मिलेगी, इसके अलावा छात्र विषयों का रिवीजन करने के लिए हर जगह भारी पाठ्य पुस्तकें ले जाने से बच सकते है.
  • परीक्षा से पहले पूरा करें Syllabus : 12वीं के syllabus का पता होना छात्रों के लिए important है क्योंकि इससे महत्वपूर्ण विषयों, परीक्षा की अवधि और अंकन योजना के बारे में जानकारी मिलती है. छात्रों को सलाह दी गई है कि वे 12वीं Routine 2023 जारी होने से पहले पाठ्यक्रम को पूरा कर ले।
  • पिछले साल के प्रश्नपत्रों को हल करें :पिछले साल के 12वीं के प्रश्न पत्री का अभ्यास करना परीक्षा को सफलतापूर्वक पास करने की कुंजी है, तैयारी के स्तर का आत्म विश्लेषण करने के लिए छात्रों को सभी subjects के प्रश्न पत्रों का revision करना चाहिए, इसके अलावा यह students को समय प्रबंधन सीखने और गणना की गति में सुधार करने में भी help कर सकता है.

Also Read –

JAC 12th Computer Science Previous Years Important Questions Unit 3-

Q1. Define ‘Primary Key’.(2009)
Q2. Read the output for SQL command given in on the basis of table MOVIE :(2009)

TitleTypeRatingStarsQty.Price
1Award winner GRam359
2OscarPGRohan129
3ActionPGAjay231
4Deadly DualPGHarish269
5ComedyPGHarsh229
6Independence day PGAnwar319
7Business Comedy RBabu244
8DramaGNikko439
9HorrorRArvind209
10Pop GunPGAmir khan349

(i) Select AVG(Price) from MOVIE where<30. (ii) Select Max(Price) from MOVIE where price >30.
(iii) Select Sum (Price and Qty.) from MOVIE where Qty <4.

Q3. What are the various data models available for database system?(2010)
Q4. What is difference between WHERE and HAVING clause?(2010)
Q5. What a data definition language and data manipulation language?(2010)
Q6. Infix expression into its equivalent prefix expression.(2010)
Q7. What is a database system?(2011)
Q8. What is a primary key?(2011)
Q9. What is normalisation? define First Normal forms.(2011)
Q10. Given the following teacher relation:(2011)

No.NameDepartmentDOJSalaryGender
1RajaTRL23.06.9918750M
2Jyoti Hindi22.06.8819000F
3Purnima Sociology 30.09.9918500F
4RanjayPhysics17.07.9720000M
5PrakashHindi30.01.9918000M
6AnajanaTRL22.06.8724000F
7ArchanaSociology 12.02.8922000F
8RahulTRL11.03.8618700M

(i) To select * all the information of teacher in TRL department.
(ii) To list the name of female teacher in Hindi department .
(iii) To list all names of the teachers with date of joining in ascending order.
(iv) To display teacher’s name , department and salary of female teacher.
(v) To count the number of teachers whose salary less than 20000.

Q11. Define candidate key and foreign key.(2012)
Q12. What is meant by functional dependency ? Give example of functional dependence.(2012)
Q13. How many types of users work on database system?(2012)
Q14. What are the various data models available for database system?(2012)
Q15. Write SQL commands for a) to d) on the basis of table of STUDENT.(2012)

No.NameAgeDepartmentD.O.AFeeSex
1Pankaj24Computer10.01.07120M
2Shalini21History24.03.98200F
3Sanjay22Hindi12.12.96300M
4Sudha25History 01.07.99400M
5Rakesh11Hindi05.09.97250M
6Shakeel30History27.06.98300M
7Surya34Computer 25.02.97210M
8Shikha23Hindi31.07.972000F

(a) To show all information about the students of History department.
(b) To list the names of female students who are in Hindi department.
(c) To list names of all students with their data of admission in ascending order.
(d) To display student’s name, fee, age for male students only.

Q16. What is a relation? What is the difference between a tuples and an attributes?(2013)
Q17. Define the following terms : (2013)
a) 1NF
b) Key
Q18. Define the following terms:(2013)
a) Variable
b) Encoder
c) DCL
Q19. What are the various levels of data abstraction in a database system? (2013)
Q20. Write SQL commands for (a) to (d) on the basis of the table GRADUATE. (2013)

Si.No.NameStipendSubject AverageDIV
1Karan400Physics 681
2Divakar450Computer Sci.681
3Divya300Chemistry622
4Arun350Physics631
5Sabina 500Mathematics 701
6John400Chemistry552
7Robert250Physics641
8Rubina450Mathematics681
9Vikash500Computer Science 621
Mohan300Mathematics572

(a) List the names of those students who obtained DIV 1 sorted by NAME.
(b) Display a report, listing Name, STIPEND, SUBJECT and amount of stipend received in a year assuming that the STIPEND is paid every month.
(c) To count the number of students who are PHYSICS or COMPUTER SC. graduates.
(d) To insert a new row in the GRADUATE table :
11, “KAJOL”, 300, “COMPUTER SC.”, 75, 1

Q21. What is data independence? How is logical data Independence different from physical data independance?(2014)
Q22. Consider the following table EMPLOYEE and DESIG write SQL command for the statement (i) to (v) and give output for SQL queries (v) to (viii).(2014)

W_IDFIRSTNAMELASTNAMECITY
102SAMTONESPARIS
105SARAHACKERMANNEW YORK
144MANILASENGUPTANEW DELHI
210GEORGESMITHHOWARD
255MARYJONESHUSTON
300ROBERTSAMUELWASHINGTON
335HENRYWILLIAMSBOSTON
400RONNYLEENEW YORK
451PATTHOMPSONPARIS
EMPLOYEE ↑
W_IDSALARYBENEFITSDESIGNATION
1027500015000MANAGER
1058500025000DIRECTOR
1447000015000MANAGER
2107500012500MANAGER
2555000012000CLERK
3004500010000CLERK
3354000010000CLERK
400320007500SALESMAN
451280007500SALESMAN
DESIG ↑

(i) Display FirstName and City of Employee having salary between 50,000 and 90,000.
(ii) Display details of Employees who are from ”PARIS” city.
(iii) Increase the benefits of employee having W_ID= 210 by 500.
(iv)Count number of employees whose name starts from character ‘S’.
(v)Select MAX(salary) from DESIG.
(vi) Select FirstName from employee, design where designation =”MANAGER’ and employee, W_ID =desig. W_ID.
(vii)Select COUNT (DISTINCT designation) from DESIG.
(viii) Select designation, SUM(salary) from DESIG Group by designation having Count(*)>2.

Q23. Define second and third normal forms.(2015, 2017)
Q24. Write SQL Commands for (a) to (d) on the basis of STUDENT relation given below -(2015)

Si.No.NameAgeDepartment D.O.AChargesGender
1Sandeep24Computer10/01/97120M
2Asha21History24/03/98200F
3Karan 22Hindi12/12/96300M
4Taruna25History01/07/99400F
5Ashish22Hindi05/09/97250M
6Manish25History27/06/98300M
7Amit24Computer 25/02/97210M
8Anubharti23Hindi31/07/97200F

(a) To Show all information about the student of History Department.
(b) To list the name of female students who are in hindi department.
(c) To list the name of all students with their admission in ascending order.
(d) To count the number of students with age < 23.
Q25. Define Primary key and candidate key.(2016)

Q26. Write the SQL Commands for the queries (a) to (d) on the basis of Employee relation given below -(2016)

No.NameSalaryAreaAgeGradeDeptt.
1Pankaj Kr40,000West45CCivil
2Salini35,000South38AElec
3Sanjay Singh60,000North52BCivil
4Rakesh38,000North29BCivil
5Surya Prasad42,000East35AComp
6Dinesh Kr.29,000South34AMech

(a) To display the name of all employees who are in the area south.
(b) To display the name and age of all employees having age >40.
(c) To display list of all employees whose salary >=30000 & <=40000.
(d) To display the employee names in descending order of age.

Q27. Write SQL commands for (a) to (d) on the basis of STUDENT relation given below-(2017)

Si.No.NameAgeDepartment Date_of_admChargesSex
1Amit22Computer 10/01/98320M
2Neha23History 24/03/99400F
3Karan22Hindi12/12/97500M
4Khushboo21History01/07/99600F
5Aman22Hindi05/09/98350M
6Vikash 21History27/06/99400M
7Asit23Computer25/02/98310M
8Anubhuti23Hindi31/07/98300F

(a) To show all information about the students of Hindi department.
(b) To list the names of female st udents who are in A History department.
(c)To list the names of all st udents with their date of admission in descending order
(d) To count the number of students with age 22.
Q28. How many types of users work on database system?(2018)
Q29. Write SQL Commands for (a) to (d) on the basis of SPORTS relation given below: -(2018)

Student No.ClassNameGame1GradeGame2Grade
107SmithCricketBSwimmmingA
118RajuTennisASkatingC
107Kamlesh Swimming BFootballB
137BinaTennisCTennisA
149AnjanaBasketball ACricketA
1510ArpitCricket AAthletic C

(a) Display t he names of the studetns who have grade C in either Game1 or Game 2 or both.
(b) Display the number of students getting Grade A in Cricket.
(C) Display the names of students who have same game for both Game1 and Game 2.
(d) dislay themetaken up by the students, whose names start wíth A.
Q30. What is the role of a Database Administration in a database system? (2019)
Q31. Write SQL Commands for (a) to (d) on the basis of M_C_DEPT relation given below : (2019)

S.No.P_Name AgeDepartmentD.O.AChargesSex
1Ramayan62Surgery23/02/158000M
2Rajani 22ENT20/01/153000F
3Rajhans32Orthopaedic 19/02/155500M
4Badrinath12Surgery 01/01/155600M
5Satyakam36ENT12/01/154500M
6Archana 16ENT24/02/153800F
7Baby29Cardiology20/02/158800F
8Biva45Gynaecology22/02/159000F
9Prakash 19Cardiology13/01/159900M
10Neha23Nuclear Medicine 19/02/156000F

(a) To show all information about the patients of Cardiology department.
b) To list the names of female patients who are in Gynaecology department.
(c)To list the names of all patients with their dates of admission in ascending order.
(d)To count the number of patients with age 36.

Q32. Write short notes on the following :(2022)
a) DDL
b) DBMS

JAC 12th Computer Science Important Questions – FAQ’s

Previous years papers से कितने Questions पूछे जायेंगे?

अधिक से अधिक Questions Previous years papers से ही पूछे जायेंगे।

यह Previous years का पेपर कब से कब तक का है?

यह Previous years का पेपर 2009 से 2020 तक का है।

Model पेपर कब तक आएगा?

मॉडल पेपर 15 january से पहले आ जाएगा।

Model पेपर से कितने Questions पूछे जायेंगे?

2022 में 80% प्रश्न मॉडल सेट के अंदर से ही पूछे गए थें, तो इस बार भी ऐसे ही पूछे जाएँगे।

Previous year Question Paper क्यों जरूरी हैं?

यह इसलिए जरूरी हैं क्योकि ये सारे प्रश्न आपके परीक्षा में बार – बार पूछे जा रहे है। इसमें आपको ये भी बताया जा रहा है कि कौन से प्रश्न किस तरह से एवं कितने marks के पूछे जा रहें है.

Google NewsClick Here
Telegram Click Here
Whatsapp Click Here

Conclusions –

उम्मीद करते हैं या आर्टिकल(JAC 12th Computer Science Important Questions Unit 3 ) आपको पसंद आया होगा अगर आया हो तो कृपया करके अपना प्यारा सा कंमेंट नीचे कर दे उसके साथ ही अधिक अपडेट जानने के लिए हमारे टेलीग्राम ग्रुप में ज्वाइन कर ले.

Hey, I’m Vikash Kumar, I’m the owner of this website from Jharkhand. I’m still studying, in this website, you will see many categories of blogs. if you want to contact me then contact via vikashkrprasad23@gmail.com

Sharing Is Caring:

Leave a Comment