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 को पढ़ लीजिए.

रांची: झारखंड एकेडमिक काउंसिल ( 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 Telegram	Join Now
Join WhatsApp	Join Now

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

Important Links –

Google News	Click Here
Telegram	Click Here
Whatsapp	Click Here

Conclusions –

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