The document outlines the practical examination for Computer Science (083) for Class XII, including two sets of questions. Set 1 focuses on Python functions for handling binary files and SQL queries related to account and transaction tables. Set 2 involves Python functions for list manipulation and SQL commands for courses and faculty tables.
The document outlines the practical examination for Computer Science (083) for Class XII, including two sets of questions. Set 1 focuses on Python functions for handling binary files and SQL queries related to account and transaction tables. Set 2 involves Python functions for list manipulation and SQL commands for courses and faculty tables.
The document outlines the practical examination for Computer Science (083) for Class XII, including two sets of questions. Set 1 focuses on Python functions for handling binary files and SQL queries related to account and transaction tables. Set 2 involves Python functions for list manipulation and SQL commands for courses and faculty tables.
The document outlines the practical examination for Computer Science (083) for Class XII, including two sets of questions. Set 1 focuses on Python functions for handling binary files and SQL queries related to account and transaction tables. Set 2 involves Python functions for list manipulation and SQL commands for courses and faculty tables.
SSS POSSANGIPUR B-1 JANAKPURI , ND-58 PRACTICAL EXAMINATION 2024-25 SUBJECT- COMPUTER SCIENCE (083) CLASS XII Duration: 3 hours SET-1 Maximum Marks: 30 1. A binary file ‘Student.dat’ has structure (rollno, name, marks). i.) Write a function in Python add_record() to input data for n records and add to 8 ‘Student.dat’. ii.) Write a function in Python find_record() to search a record from binary file ‘Student.dat’ on the basis of roll number. 2. Write SQL queries for (i) to (iv) based on the below given tables: TABLE : ACCOUNT Acc_No Acc_Name Address 101 Ananya Bangalore 102 Hemant Chennai 103 Riya Hyderabad 104 Lakshit Chennai 105 Rehan Chandigarh
(i) To display all the transactions of type ‘CREDIT’ from table TRANSACTION. (ii) To display the Acc_No and Amount of all Credits and Debits done in the month of April 2023 from table TRANSACTION. (iii) To display the last date of transaction(DOTr) from the table TRANSACTION for the account having Acc_No as 103. (iv) To display all the Acc_No, Acc_Name and DOTr of those who have done transaction of amount more than or equal to 3000 from tables ACCOUNT and TRANSACTION.
1. Given is a list of 10 integers, NList = [12,34,67,32,87,21,78,44,94,46]. Write separate user
defined functions in Python to perform the following operations based on this list. 8 a. Traverse the content of the list and push the even numbers into a stack. b. Pop and display the content of the stack. 2. Consider the following tables: COURSES and FACULTY. Write SQL commands for the statements from (i) to (iii) and give output for point (iv). TABLE: COURSES C_ID F_ID CName Fees C21 102 Cloud 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 4 TABLE: FACULTY F_ID FName LName Hire_Date Salary 102 Amit Mishra 12-10-1998 12000 103 Nitin Vyas 21-12-2994 8000 104 Lakshit Soni 18-05-2001 14000 105 Rashmi Malhotra 11-09-2004 11999 106 Sulekha Srivastava 05-06-2006 10000
(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. (iii) To increase the fees of all the courses by 1100. (iv) Select MIN(Salary) FROM Faculty, Courses where Courses.F_ID = Faculty.F_ID;
