[go: up one dir, main page]
Scribd
Upload
10 views3 pages

Sample Qp Practical

The document outlines the practical examination format for Computer Science (083) for three sets (A, B, and C), each consisting of programming tasks in Python and MySQL queries related to employee and student databases. Each set includes questions worth a total of 30 marks, covering practical file submissions, project work, and viva-voce. The examination tests students' ability to write code and execute database queries based on given tables and conditions.

Uploaded by

Diksha Kumari
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
10 views3 pages

Sample Qp Practical

The document outlines the practical examination format for Computer Science (083) for three sets (A, B, and C), each consisting of programming tasks in Python and MySQL queries related to employee and student databases. Each set includes questions worth a total of 30 marks, covering practical file submissions, project work, and viva-voce. The examination tests students' ability to write code and execute database queries based on given tables and conditions.

Uploaded by

Diksha Kumari
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

PRACTICAL EXAMINATION

COMPUTER SCIENCE (083)


Set A
Date : CBSE Roll No : ____________
Max. Marks: 30 Time: 3:00 Hours

Q1. Lab Test – Python Program: 08 marks


Write a program in Python to Open a text file name "Study.txt" and write few lines of string
in it and then write code to count the occurrence of word “and” or “my”
Me and my friend and his father went to market.

Q2. MySQL Query : 04 marks


Create Database CBSE24 and Create following table inside newly created database.

Consider the table given below and answer the following questions:

TABLE: EMPLOYEE
Ecode eName Salary Zone Age Grade Dept
101 Mukul 30000 West 28 A 11
102 Kritika 35000 Centre 51 A 22
103 Naveen 32000 East 40 NULL 11
105 Uday 38000 North 38 C 33
107 Nupur 32000 East 26 NULL 11

TABLE: DEPARTMENT
Dept Dname Entitlement
11 Sales Taxi
22 Store Air
33 Finance Car
Write the Query for the following:
1. Display the details of all the employees who are getting a salary of less than 33000.
2. Display the sum of salary of Grade ‘B’ employees.
3. Display the employee name, age and zone of employees in the ascending order of their
age of East department
4. Display Employee Code, Employee Name and Department Name for all employees

Q4) Practical File: 07 marks


Q5) Project work: 08 marks
Q6) Viva-voce: 03 marks

Internal External
AISSCE PRACTICAL EXAMINATION
COMPUTER SCIENCE (083)
SET B
Date : CBSE Roll No : ____________
Max. Marks: 30 Time: 3:00 Hours

Q1. Lab Test – Python Program: 08 marks


Write a program in Python to create stack name “employee” having employee code and
name of 03 employees. Then Insert the details of one more employee to the stack. (PUSH
Operation).
Consider employee code 101,102,103 and name as Kamal, Rajesh and Kush

Q2. MySQL Query : 04 marks


Create Database CBSE24 and Create following table inside newly created database.
Consider the table given below and answer the following questions :

TABLE: STUDENT
Enrol SName Fee House Class Grade Scode
101 Nanda 5000 Green 11 A S11
102 Saurabh 3000 Blue 12 B S33
103 Kamal 3000 Green 12 Null S33
105 Praveen 2500 Red 11 C S11
107 Arvind 4500 Blue 12 NULL S22

TABLE: STREAM
Scode Sname Chapters
S11 Science 15
S22 Commerce 11
S33 Humanities 12

Write the Query for the following:


1. Display the details of all the students who are paying fee less than 3000.
2. Display the sum of fee of Class 11 students.
3. Display the student name, class, fee and House of students in the ascending order of their
fee of Blue department
4. Display Student Enrolment no, Student Name and Stream Name for all students

Q4) Practical File: 07 marks


Q5) Project work: 08 marks
Q6) Viva-voce: 03 marks

Internal External
AISSCE PRACTICAL EXAMINATION
COMPUTER SCIENCE (083)
Set C
Date : CBSE Roll No : ____________
Max. Marks: 30 Time: 3:00 Hours

Q1. Lab Test – Python Program: 08 marks


Write a program in Python to create stack name “employee” having employee code and
name of 03 employees. Then remove the details of one employee from the stack. (POP
Operation)
Consider employee code 101,102,103 and name as Kamal, Rajesh and Kush

Q2. MySQL Query : 04 marks


Create Database CBSE24 and Create following table inside newly created database.
Consider the table given below and answer the following questions :

TABLE: STUDENT
Enrol SName Fee House Class Grade Scode
101 Nanda 5000 Green 11 A S11
102 Saurabh 3000 Blue 12 B S33
103 Kamal 3000 Green 12 Null S33
105 Praveen 2500 Red 11 C S11
107 Arvind 4500 Green 12 NULL S22

TABLE: STREAM
Scode Sname Chapters
S11 Science 15
S22 Commerce 11
S33 Humanities 12

Write the Query for the following:


1. Display the details of all the students who are paying fee more than 3000.
2. Display the sum of fee of Class 12 students.
3. Display the student name, class, fee and House of students in the ascending order of their
fee of Green department
4. Display Student Enrolment no, Student Name and Stream Name for all students

Q4) Practical File: 07 marks


Q5) Project work: 08 marks
Q6) Viva-voce: 03 marks

Internal External

You might also like