Ictswami.files.wordpress.com



A.I.S.S.C.E.(PRACTICAL EXAMINATION – 2019-2020)SUBJECT : COMPUTER SCIENCE (083) NEWCLASS: XIIDATE: /01/2019 TIME: 3 Hr. MAX.MARKS:30Q.1) a) Write a menu driven program in python to display Fibonacci series of a given 7 no and print factorial of a given no. Show result to the examiner. b) Write a python code to add student using mysql connectivity and show result to 3 the examiner. Create database and table as below: Name of database =school Name of table = student (roll,name,age,class,city) give primary key and not null constraints Q.2) Report File7Q.3) Viva voce based on the report file2Q.4) Project Work8Q.5) Project viva voce3Slip 1A.I.S.S.C.E.(PRACTICAL EXAMINATION – 2019-2020)SUBJECT : COMPUTER SCIENCE (083)CLASS: XIIDATE: /01/2019 TIME: 3 Hr. MAX.MARKS:30Q.1) a) Write a menu driven program to push book no in stack and pop it from stack 7 b) Write a python code to delete student as per given roll number in using mysql 3 connectivity and show result to the examiner. Create database and table as below: Name of database =school Name of table = student(roll,name,age,class,city)give possible constraints on your own. Insert 3 records in table.Q.2) Report File7Q.3) Viva voce based on the report file2Q.4) Project Work8Q.5) Project viva voce3Slip 2A.I.S.S.C.E.(PRACTICAL EXAMINATION – 2019-2020)SUBJECT : COMPUTER SCIENCE (083) NEWCLASS: XIIDATE: /01/2019 TIME: 3 Hr. MAX.MARKS:30Q.1) a) Write a menu driven program to insert book no in queue and delete it from 7 queue b) Write a python code to search student as per given roll number in database3 using mysql connectivity and show result to the examiner. Create database and table as below: Name of database =school Name of table = student(roll,name,age,class,city)give possible constraints on your ownQ.2) Report File7Q.3) Viva voce based on the report file2Q.4) Project Work8Q.5) Project viva voce3Slip 3A.I.S.S.C.E.(PRACTICAL EXAMINATION – 2019-2020)SUBJECT : COMPUTER SCIENCE (083) NEWCLASS: XIIDATE: /01/2019 TIME: 3 Hr. MAX.MARKS:30Q.1) a) Write a menu driven code in python to check whether string is palindrome 7 or not and no. is prime or not. Show result to the examiner. b) Write a menu driven python code to add following tuples in database using mysql connectivity and show result to the examiner 3 Consider the following table ITEMS & database as TRYCODEINAMEQTYPRICECOMPANY1001DIGITAL PAD 12112011000XENITA1006LED SCREEN 407038000SANTORAQ.2) Report File7Q.3) Viva voce based on the report file2Q.4) Project Work8Q.5) Project viva voce3Slip 4A.I.S.S.C.E.(PRACTICAL EXAMINATION – 2019-2020)SUBJECT : COMPUTER SCIENCE (083)NEWCLASS: XIIDATE: /01/2019 TIME: 3 Hr. MAX.MARKS:30Q.1) a) Write a python code for binary search using function.7 b) Write a python code to delete tuples from database as per given CODE 3 using mysql connectivity and show result to the examiner Consider the following table ITEMS & database as TRYCODEINAMEQTYPRICECOMPANY1001DIGITAL PAD 12112011000XENITA1006LED SCREEN 407038000SANTORA1004CAR GPS SYSTEM502150GEOKNOWQ.2) Report File7Q.3) Viva voce based on the report file2Q.4) Project Work8Q.5) Project viva voce3Slip 5A.I.S.S.C.E.(PRACTICAL EXAMINATION – 2019-2020)SUBJECT : COMPUTER SCIENCE (083)NEWCLASS: XIIDATE: /01/2019 TIME: 3 Hr. MAX.MARKS:30Q.1) a) Write a python code for recursive binary search function.7b) Write a python code to search an item as per given INAME in database using 3 mysql connectivity and show result to the examiner Consider the following table ITEMS & database as TRYCODEINAMEQTYPRICECOMPANY1001DIGITAL PAD 12112011000XENITA1006LED SCREEN 407038000SANTORA1004CAR GPS SYSTEM502150GEOKNOW1003DIGITAL CAMERA1608000DIGICLICK1005PEN DRIVE6001200STOREHOMEQ.2) Report File7Q.3) Viva voce based on the report file2Q.4) Project Work8Q.5) Project viva voce3Slip 6A.I.S.S.C.E.(PRACTICAL EXAMINATION – 2019-2020)SUBJECT : COMPUTER SCIENCE (083)NEWCLASS: XIIDATE: /01/2019 TIME: 3 Hr. MAX.MARKS:30Q.1) a) Write a menu driven program in python to read test file and display 7No. of wordsNo. of linesNo. of alphabetsb) Write a python code to add following tuples in database using mysql connectivity3 and show result to the examiner Consider the following table STUDENT. NONAMEAGEDEPARTMENTFEESEX1PANKAJ24COMPUTER120M2SHALINI21HISTORY200FQ.2) Report File7Q.3) Viva voce based on the report file2Q.4) Project Work8Q.5) Project viva voce3Slip 7A.I.S.S.C.E.(PRACTICAL EXAMINATION – 2019-2020)SUBJECT : COMPUTER SCIENCE (083)NEWCLASS: XIIDATE: /01/2019 TIME: 3 Hr. MAX.MARKS:30Q.1) a) Write a python code for linear search using function7 b) Write a python code to delete tuples from database as per given CODE using mysql connectivity3 and show result to the examiner Consider the following table ITEMS & database as TRY Consider the following table STUDENT. NONAMEAGEDEPARTMENTFEESEX1PANKAJ24COMPUTER120M2SHALINI21HISTORY200F3SANJAY22HINDI300M4SUDHA25HISTORY400FQ.2) Report File7Q.3) Viva voce based on the report file2Q.4) Project Work8Q.5) Project viva voce3Slip 8A.I.S.S.C.E.(PRACTICAL EXAMINATION – 2019-2020)SUBJECT : COMPUTER SCIENCE (083)NEWCLASS: XIIDATE: /01/2019 TIME: 3 Hr. MAX.MARKS:30Q.1) a) Write a menu driven python code to push and pop bookname in stack 7b) Write a python code to search a record as per given NO using 3 mysql connectivity and show result to the examiner Consider the following table ITEMS & database as TRY Consider the following table STUDENT. NONAMEAGEDEPARTMENTFEESEX1PANKAJ24COMPUTER120M2SHALINI21HISTORY200F3SANJAY22HINDI300M4SUDHA25HISTORY400FQ.2) Report File7Q.3) Viva voce based on the report file2Q.4) Project Work8Q.5) Project viva voce3Slip 9 A.I.S.S.C.E.(PRACTICAL EXAMINATION – 2019-2020)SUBJECT : COMPUTER SCIENCE (083)NEWCLASS: XIIDATE: /01/2019 TIME: 3 Hr. MAX.MARKS:30Q.1)a) Write a menu driven python code to insert and delete bookname from queue7b) Write a python code to add following tuples in database using mysql 3 connectivity and show result to the examiner Consider the following table EMPLOYEE. EMPIDFNAMELNAMECITYSALARYDESIG010RAVIKUMARMUMBAI15000MANAGER101HARRYWALTORPUNE12000CLERK215ARUNKUMARDELHI13000CLERK152SAMLEEMUMBAI20000DIRECTORQ.2) Report File7Q.3) Viva voce based on the report file2Q.4) Project Work8Q.5) Project viva voce3Slip 10A.I.S.S.C.E.(PRACTICAL EXAMINATION – 2019-2020)SUBJECT : COMPUTER SCIENCE (083)NEWCLASS: XIIDATE: /01/2019 TIME: 3 Hr. MAX.MARKS:30Q.1)a) Write a python code to write those lines which have the character 'p' from one7 text file to another text file and count no.of words from text fileb) Write a python code to delete a tuple after giving value of EMPID using mysql 3 connectivity and show result to the examiner Consider the following table EMPLOYEE. EMPIDFNAMELNAMECITYSALARYDESIG010RAVIKUMARMUMBAI15000MANAGER101HARRYWALTORPUNE12000CLERK215ARUNKUMARDELHI13000CLERK152SAMLEEMUMBAI20000DIRECTORQ.2) Report File7Q.3) Viva voce based on the report file2Q.4) Project Work8Q.5) Project viva voce3Slip 11A.I.S.S.C.E.(PRACTICAL EXAMINATION – 2019-2020)SUBJECT : COMPUTER SCIENCE (083)NEWCLASS: XIIDATE: /01/2019 TIME: 3 Hr. MAX.MARKS:30Q.1) Write a program to plot a bar chart and pie chart in python to display the result7 of a school for five consecutive years. Take years as 2015, 2016,2017,2018,2019. And percentage as 98.50,70,25,55.20,90.5,61.50 b) Write a pyhon code to search a record as per given FNAME using mysql 3 connectivity and show result to the examiner a tuple after giving value of empid using mysql connectivity and show result to the examiner Consider the following table EMPLOYEE. EMPIDFNAMELNAMECITYSALARYDESIG010RAVIKUMARMUMBAI15000MANAGER101HARRYWALTORPUNE12000CLERK215ARUNKUMARDELHI13000CLERK152SAMLEEMUMBAI20000DIRECTORQ.2) Report File7Q.3) Viva voce based on the report file2Q.4) Project Work8Q.5) Project viva voce3Slip 12A.I.S.S.C.E.(PRACTICAL EXAMINATION – 2019-2020)SUBJECT : COMPUTER SCIENCE (083)NEWCLASS: XIIDATE: /01/2019 TIME: 3 Hr. MAX.MARKS:30Q.1) a) Write a python code to plot a graph for the function y = x2 2b) Write python code for bubble sort5c) Write a python code to add following tuples in database using mysql3 connectivity and show result to the examiner Consider the following table FLIGHT. FLNOSTARTENDINGNO_FLIGHTAAIRLINESFARESIC301MUMBAIDELHI8INDIAN AIRLINES6500IC799BANGALOREDELHI2INDIGO9400MC101INDOREMUMBAI4SPICEJET13450IC302DELHIMUMBAI6JET AIRWAYS8300Q.2) Report File7Q.3) Viva voce based on the report file2Q.4) Project Work8Q.5) Project viva voce3Slip 13A.I.S.S.C.E.(PRACTICAL EXAMINATION – 2019-2020)SUBJECT : COMPUTER SCIENCE (083)NEWCLASS: XIIDATE: /01/2019 TIME: 3 Hr. MAX.MARKS:30Q.1) a) Write a python code to find base to power using recursion and factorial 7 using recursive function b) Write a python code to delete a tuple as per FLNO using mysql 3 connectivity and show result to the examiner Consider the following table FLIGHT. FLNOSTARTENDINGNO_FLIGHTAAIRLINESFARESIC301MUMBAIDELHI8INDIAN AIRLINES6500IC799BANGALOREDELHI2INDIGO9400MC101INDOREMUMBAI4SPICEJET13450IC302DELHIMUMBAI6JET AIRWAYS8300Q.2) Report File7Q.3) Viva voce based on the report file2Q.4) Project Work8Q.5) Project viva voce3Slip 14 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download