Practical Cs
Practical Cs
ABC PUBLIC SCHOOL
AISSCE PRACTICAL EXAMINATION, 2024-25
SUBJECT COMPUTER SCIENCE
SUBJECT CODE 083
Class - XII
School Code :
D Set A
Maximum Marks : 30
1. Write a menu driven program to perform Push, Pop and Display Operations on
Stack using List. 8
2. Consider the following tables FACULTY and COURSES.
Write SQL commands for the statements (i) to (iv) 4
FACULTY
F_ID Fname Lname Hire_date Salary
102 Amit Mishra 12-10-1998 12000
103 Nitin Vyas 24-12-1994 8000
104 Rakshit Soni 18-5-2001 14000
105 Rashmi Malhotra 11-9-2004 11000
106 Sulekha Srivastava 5-6-2006 10000
COURSES
C_ID F_ID Cname Fees
C21 102 Grid Computing 40000
C22 106 System Design 16000
C23 104 Computer Security 8000
C24 106 Human Biology 15000
C25 102 Computer Network 20000
C26 105 Visual Basic 6000
(i) To display details of those Faculties whose salary is greater than 12000.
(ii) To display the details of courses whose fees is in the range of 15000 to 50000
(both values included).
(iii)
(iv) To display the record of all faculties according to their salary in descending
order.
3. Report File 7
4. Project 8
5. Viva Voce 3
Internal Examiner External Examiner
Examiner
ABC PUBLIC SCHOOL
AISSCE PRACTICAL EXAMINATION, 2024-25
SUBJECT COMPUTER SCIENCE
SUBJECT CODE 083
Class - XII
D Set B
Maximum Marks : 30
1. Write a program in Python to create a binary file with name and rollno. Search for
the given roll no. and display the name, if not found, display appropriate message.
8
2. Consider the following tables FACULTY and COURSES.
Write SQL commands for the statements (i) to (iv) 4
FACULTY
F_ID Fname Lname Hire_date Salary
102 Amit Mishra 12-10-1998 12000
103 Nitin Vyas 24-12-1994 8000
104 Rakshit Soni 18-5-2001 14000
105 Rashmi Malhotra 11-9-2004 11000
106 Sulekha Srivastava 5-6-2006 10000
COURSES
C_ID F_ID Cname Fees
C21 102 Grid Computing 40000
C22 106 System Design 16000
C23 104 Computer Security 8000
C24 106 Human Biology 15000
C25 102 Computer Network 20000
C26 105 Visual Basic 6000
(i) To display details of those Faculties whose salary is less than 12000.
(ii) To display the details of courses whose fees is in the range of 15000 to 50000
(both values included).
(iii)
(iv) To display the name of all the faculties according to their salary in ascending
order.
3. Report File 7
4. Project 8
5. Viva Voce 3