SUB: COMPUTER SCIENCE (CODE: 083), CLASS - 12
SET – 1
MAX MARKS: 30
TIMES: 3 HRS
Practical – 1: 08
Marks
Create a binary file with name and roll number. Search
for a given roll number and display the name, if not found display appropriate
message
Practical – 2: MySQL Queries: 04
Marks
Consider the table “RESULT” given below and write
MySQL queries for the following questions:
|
RollNo |
Name |
Class |
Gender |
City |
Marks |
|
1 |
Shiva |
XII |
M |
Bhopal |
453 |
|
2 |
Saanvi |
X |
F |
Jaipur |
551 |
|
3 |
Abhay |
X |
M |
Delhi |
553 |
|
4 |
Gauri |
XI |
F |
Jaipur |
458 |
|
5 |
Mansi |
XII |
F |
Delhi |
430 |
|
6 |
Aman |
XII |
M |
Delhi |
530 |
(a) Display the details of
class XII students in descending order of their marks.
(b) Delete the column “Gender”
from the table.
(c) Display the city with
number of students belongs to that city.
(d) Change the city of ‘Gauri’
from ‘Jaipur’ to ‘Noida’.
3. Report File 7
Marks
4. Project 8
Marks
5. Viva voce 3
Marks
Sign of Internal Examiner Sign
of External Examiner
SUB: COMPUTER SCIENCE (CODE: 083), CLASS - 12
SET – 2
MAX MARKS:
30 TIMES: 3 HRS
Practical – 1: 08
Marks
Create a binary file with roll number, name and marks.
Input a roll number and update the marks.
Practical – 2: MySQL Queries: 04
Marks
Consider the table “Emp” given below and write
MySQL queries for the following questions:
|
ID |
Name |
Age |
Gender |
City |
Salary |
|
1 |
Shiva |
25 |
M |
Bhopal |
34000 |
|
2 |
Saanvi |
27 |
F |
Jaipur |
42000 |
|
3 |
Abhay |
26 |
M |
Delhi |
55000 |
|
4 |
Gauri |
28 |
F |
Jaipur |
45000 |
|
5 |
Mansi |
25 |
F |
Delhi |
43000 |
|
6 |
Aman |
28 |
M |
Delhi |
53000 |
(a) Display the details of all
employees in descending order of their salary.
(b) Delete the column “Gender”
from the table.
(c) Display the city with
number of employees belongs to that city.
(d) Increase the salary by 10%
of all employees.
3. Report File 7
Marks
4. Project 8
Marks
5. Viva voce 3
Marks
Sign of Internal Examiner Sign
of External Examiner
SUB: COMPUTER SCIENCE (CODE: 083), CLASS - 12
SET – 3
MAX MARKS:
30 TIMES: 3 HRS
Practical – 1: 08
Marks
Write a menu driven program which insert, delete and
display the details of a book such as book_id, book_name and price using Stack.
Practical – 2: MySQL Queries: 04
Marks
Consider the table “SALES” given below and write
MySQL queries for the following questions:
|
Code |
Category |
Sale |
Profit |
|
101 |
Cosmetics |
24000 |
6500.34 |
|
102 |
Books |
22500 |
4500.00 |
|
103 |
Stationary |
31000 |
NULL |
|
104 |
Gift |
27500 |
2561.76 |
|
105 |
Baby Products |
35000 |
1500.26 |
(a) Display the average sale
of all categories.
(b) Add a new column named
“Brand” of varchar (20) type.
(c) Update the profit 4000 of
category which profit is NULL
(d) Display all the details in
descending order of Sale.
3. Report File 7
Marks
4. Project 8
Marks
5. Viva voce 3
Marks
Sign of Internal Examiner Sign
of External Examiner
SUB: COMPUTER SCIENCE (CODE: 083), CLASS - 12
SET – 4
MAX MARKS:
30 TIMES: 3 HRS
Practical – 1: 08
Marks
Write a menu driven program which insert, delete and
display the details of an employee such as eid, ename and salary using Stack.
Practical – 2: MySQL Queries: 04
Marks
Consider the table “Product” given below and write
MySQL queries for the following questions:
|
ID |
Name |
Brand |
Price |
|
1 |
Keyboard |
HP |
850 |
|
2 |
Mouse |
HP |
450 |
|
3 |
Monitor |
Sumsung |
5500 |
|
4 |
Pen Drive |
SanDisk |
750 |
|
5 |
UPS |
Microtek |
1550 |
(a) Display the details of all
products in descending order of their price.
(b) Find the average price of
all products.
(c) Display the name of
products whose price is more than 1000.
(d) Add a new column ‘Model’
with varchar(20) data type.
3. Report File 7
Marks
4. Project 8
Marks
5. Viva voce 3
Marks
Sign of Internal Examiner Sign
of External Examiner
No comments:
Post a Comment