JAC 12th Computer Science Important Questions Unit 3 : झारखण्ड बोर्ड कक्षा 12th सभी विद्यार्थियों के लिए Computer Science में unit 3 Database and SQL के पिछले वर्षो में जो भी प्रश्न पूछे गए हैं, उनकी चर्चा हम इसमें करेंगे तो इन Important Questions को पढ़ लीजिए.
रांची: झारखंड एकेडमिक काउंसिल ( 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 पूछे जा रहें है..
JAC 12th Computer Science Important Questions Unit 3 -Overview
Name of Organisation | Jharkhand Academic Council Ranchi |
Category | Important Question |
Article | JAC 12th Computer Science Important Questions |
State | Jharkhand |
Question Types | Previous Year & Important Questions |
Class | 12th(Inter) |
Stream | Science |
Subject | Computer Science |
Chapter | Unit 3 |
Chapter Name | Database and SQL |
Telegram | Join Us |
परीक्षा की तैयारी करने के टिप्स-
- 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 Important Questions Unit 4 : Boolean Algebra
- JAC 12th Computer Science Important Questions Unit 5 : Networking And Internet
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)
Title | Type | Rating | Stars | Qty. | Price |
---|---|---|---|---|---|
1 | Award winner | G | Ram | 3 | 59 |
2 | Oscar | PG | Rohan | 1 | 29 |
3 | Action | PG | Ajay | 2 | 31 |
4 | Deadly Dual | PG | Harish | 2 | 69 |
5 | Comedy | PG | Harsh | 2 | 29 |
6 | Independence day | PG | Anwar | 3 | 19 |
7 | Business Comedy | R | Babu | 2 | 44 |
8 | Drama | G | Nikko | 4 | 39 |
9 | Horror | R | Arvind | 2 | 09 |
10 | Pop Gun | PG | Amir khan | 3 | 49 |
(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. | Name | Department | DOJ | Salary | Gender |
---|---|---|---|---|---|
1 | Raja | TRL | 23.06.99 | 18750 | M |
2 | Jyoti | Hindi | 22.06.88 | 19000 | F |
3 | Purnima | Sociology | 30.09.99 | 18500 | F |
4 | Ranjay | Physics | 17.07.97 | 20000 | M |
5 | Prakash | Hindi | 30.01.99 | 18000 | M |
6 | Anajana | TRL | 22.06.87 | 24000 | F |
7 | Archana | Sociology | 12.02.89 | 22000 | F |
8 | Rahul | TRL | 11.03.86 | 18700 | M |
(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. | Name | Age | Department | D.O.A | Fee | Sex |
---|---|---|---|---|---|---|
1 | Pankaj | 24 | Computer | 10.01.07 | 120 | M |
2 | Shalini | 21 | History | 24.03.98 | 200 | F |
3 | Sanjay | 22 | Hindi | 12.12.96 | 300 | M |
4 | Sudha | 25 | History | 01.07.99 | 400 | M |
5 | Rakesh | 11 | Hindi | 05.09.97 | 250 | M |
6 | Shakeel | 30 | History | 27.06.98 | 300 | M |
7 | Surya | 34 | Computer | 25.02.97 | 210 | M |
8 | Shikha | 23 | Hindi | 31.07.97 | 2000 | F |
(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. | Name | Stipend | Subject | Average | DIV |
---|---|---|---|---|---|
1 | Karan | 400 | Physics | 68 | 1 |
2 | Divakar | 450 | Computer Sci. | 68 | 1 |
3 | Divya | 300 | Chemistry | 62 | 2 |
4 | Arun | 350 | Physics | 63 | 1 |
5 | Sabina | 500 | Mathematics | 70 | 1 |
6 | John | 400 | Chemistry | 55 | 2 |
7 | Robert | 250 | Physics | 64 | 1 |
8 | Rubina | 450 | Mathematics | 68 | 1 |
9 | Vikash | 500 | Computer Science | 62 | 1 |
Mohan | 300 | Mathematics | 57 | 2 |
(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_ID | FIRSTNAME | LASTNAME | CITY |
---|---|---|---|
102 | SAM | TONES | PARIS |
105 | SARAH | ACKERMAN | NEW YORK |
144 | MANILA | SENGUPTA | NEW DELHI |
210 | GEORGE | SMITH | HOWARD |
255 | MARY | JONES | HUSTON |
300 | ROBERT | SAMUEL | WASHINGTON |
335 | HENRY | WILLIAMS | BOSTON |
400 | RONNY | LEE | NEW YORK |
451 | PAT | THOMPSON | PARIS |
W_ID | SALARY | BENEFITS | DESIGNATION |
---|---|---|---|
102 | 75000 | 15000 | MANAGER |
105 | 85000 | 25000 | DIRECTOR |
144 | 70000 | 15000 | MANAGER |
210 | 75000 | 12500 | MANAGER |
255 | 50000 | 12000 | CLERK |
300 | 45000 | 10000 | CLERK |
335 | 40000 | 10000 | CLERK |
400 | 32000 | 7500 | SALESMAN |
451 | 28000 | 7500 | SALESMAN |
(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. | Name | Age | Department | D.O.A | Charges | Gender |
---|---|---|---|---|---|---|
1 | Sandeep | 24 | Computer | 10/01/97 | 120 | M |
2 | Asha | 21 | History | 24/03/98 | 200 | F |
3 | Karan | 22 | Hindi | 12/12/96 | 300 | M |
4 | Taruna | 25 | History | 01/07/99 | 400 | F |
5 | Ashish | 22 | Hindi | 05/09/97 | 250 | M |
6 | Manish | 25 | History | 27/06/98 | 300 | M |
7 | Amit | 24 | Computer | 25/02/97 | 210 | M |
8 | Anubharti | 23 | Hindi | 31/07/97 | 200 | F |
(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. | Name | Salary | Area | Age | Grade | Deptt. |
---|---|---|---|---|---|---|
1 | Pankaj Kr | 40,000 | West | 45 | C | Civil |
2 | Salini | 35,000 | South | 38 | A | Elec |
3 | Sanjay Singh | 60,000 | North | 52 | B | Civil |
4 | Rakesh | 38,000 | North | 29 | B | Civil |
5 | Surya Prasad | 42,000 | East | 35 | A | Comp |
6 | Dinesh Kr. | 29,000 | South | 34 | A | Mech |
(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. | Name | Age | Department | Date_of_adm | Charges | Sex |
---|---|---|---|---|---|---|
1 | Amit | 22 | Computer | 10/01/98 | 320 | M |
2 | Neha | 23 | History | 24/03/99 | 400 | F |
3 | Karan | 22 | Hindi | 12/12/97 | 500 | M |
4 | Khushboo | 21 | History | 01/07/99 | 600 | F |
5 | Aman | 22 | Hindi | 05/09/98 | 350 | M |
6 | Vikash | 21 | History | 27/06/99 | 400 | M |
7 | Asit | 23 | Computer | 25/02/98 | 310 | M |
8 | Anubhuti | 23 | Hindi | 31/07/98 | 300 | F |
(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. | Class | Name | Game1 | Grade | Game2 | Grade |
---|---|---|---|---|---|---|
10 | 7 | Smith | Cricket | B | Swimmming | A |
11 | 8 | Raju | Tennis | A | Skating | C |
10 | 7 | Kamlesh | Swimming | B | Football | B |
13 | 7 | Bina | Tennis | C | Tennis | A |
14 | 9 | Anjana | Basketball | A | Cricket | A |
15 | 10 | Arpit | Cricket | A | Athletic | 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 | Age | Department | D.O.A | Charges | Sex |
---|---|---|---|---|---|---|
1 | Ramayan | 62 | Surgery | 23/02/15 | 8000 | M |
2 | Rajani | 22 | ENT | 20/01/15 | 3000 | F |
3 | Rajhans | 32 | Orthopaedic | 19/02/15 | 5500 | M |
4 | Badrinath | 12 | Surgery | 01/01/15 | 5600 | M |
5 | Satyakam | 36 | ENT | 12/01/15 | 4500 | M |
6 | Archana | 16 | ENT | 24/02/15 | 3800 | F |
7 | Baby | 29 | Cardiology | 20/02/15 | 8800 | F |
8 | Biva | 45 | Gynaecology | 22/02/15 | 9000 | F |
9 | Prakash | 19 | Cardiology | 13/01/15 | 9900 | M |
10 | Neha | 23 | Nuclear Medicine | 19/02/15 | 6000 | F |
(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 के पूछे जा रहें है.
Important Links –
Google News | Click Here |
Telegram | Click Here |
Click Here |
Conclusions –
उम्मीद करते हैं या आर्टिकल(JAC 12th Computer Science Important Questions Unit 3 ) आपको पसंद आया होगा अगर आया हो तो कृपया करके अपना प्यारा सा कंमेंट नीचे कर दे उसके साथ ही अधिक अपडेट जानने के लिए हमारे टेलीग्राम ग्रुप में ज्वाइन कर ले.