Download AISSCE Practical Exam: Computer Science Lab Test (2023-2024) and more Exams Computer science in PDF only on Docsity!
SCHOOL CODE: XXXXX
CODE & SUB: (083) COMPUTER SCIENCE – LAB TEST
Date: 27/09/2023 Duration: 3 Hrs Max Marks: 30
1 Creating a python program named “Mycsv.py” to store the details of Empno, Name and Salary in “Emp.csv” and search for an Empno entered by the user. If found, display the details of the Employee else display Empno is not present.
2 Write SQL queries for (i) to (iv) 4 (i) To display details of all Trains which Start from New Delhi. (ii) To display the PNR, PNAME, GENDER and AGE of all Passengers whose AGE is below 50. (iii) To display total number of MALE and FEMALE Passengers. (iv) To display details of all Passengers travelling in Trains whose TNO is 12015. Marks Scored Max Marks Python Program 8 SQL Queries 4 Report File 7 Project 8 Viva Voce 3 Total 30 Internal Examiner External Examiner Name:_________________________ Name: _________________________ Sign: _________________________ Sign: _________________________
SCHOOL CODE: XXXXX
CODE & SUB: (083) COMPUTER SCIENCE – LAB TEST
Date: 27/09/2023 Duration: 3 Hrs Max Marks: 30
1 Create a python program named Count.py to read a text file – Mytext.txt and display the number of vowels/consonants/lower case/ upper case characters.
2 Consider the following tables FACULTY and COURSES. Write SQL commands for the statements (i) to (iv)
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) To increase the fees of all courses by 500 of “System Design” Course. iv) To display details of those courses which are taught by ‘Sulekha’ in descending order of courses. Marks Scored Max Marks Python Program 8 SQL Queries 4 Report File 7 Project 8 Viva Voce 3 Total 30 Internal Examiner External Examiner Name:_________________________ Name: _________________________ Sign: _________________________ Sign: _________________________
SCHOOL CODE: XXXXX
CODE & SUB: (083) COMPUTER SCIENCE – LAB TEST
Date: 27/09/2023 Duration: 3 Hrs Max Marks: 30
1 Write a python program using list to implement stack data structure and perform the following operations: a. Push(), b. Pop(), c. Display() d. Peek()
2 Write SQL queries for (i) to (iv) 4 (i)Display the Trainer Name, City & Salary in descending order of their Hiredate. (ii)To display the TNAME and CITY of Trainer who joined the Institute in the month of December 2001. (iii)To display TNAME, HIREDATE, CNAME, STARTDATE from tables TRAINER and COURSE of all those courses whose FEES is less than or equal to 10000. (iv)To display number of Trainers from each city. Marks Scored Max Marks Python Program 8 SQL Queries 4 Report File 7 Project 8 Viva Voce 3 Total 30 Internal Examiner External Examiner Name:_________________________ Name: _________________________ Sign: _________________________ Sign: _________________________
