College Half Yearly Practical Examination 2024-25 COMPUTER SCIENCE (083)
DATE: 03.12.24(TUE) BATCH II: XII A ROLL NO: 12126 TO 12149
I. Write a python program to implement searching methods based on user choice using a list data-structure. (linear & binary) II. Write a function that accepts an integer list as argument and shift all odd numbers to the left and even numbers to the right of the list without changing the order. III. Write a program to create a CSV file and also display the contents of the file. IV. Write a program to create a binary file and display the records whose marks are > 95. V. Write a program to implement stack operations in Python. VI. Write SQL commands for the statements (i) to (iv) on the table MOVIE
(i) Display all the information from the movie table.
SELECT * FROM MOVIE; (ii) List the different categories of movies. SELECT CATEGORY FROM MOVIE; OR SELECT DISTINCT (CATEGORY) FROM MOVIE; (iii) List details of all movies which fall in the category of Comedy or Action. SELECT * FROM MOVIE WHERE CATEGORY = “COMEDY” OR CATEGORY = “ACTION”; (iv)List MoviesId , MovieName and Cost of All movies with Product Cost greater than 10,000 and less than 1,00,000 SELECT MOVIEID,MOVIE_NAME, PRODUCTIONCOST FROM MOVIE WHERE PRODUCTIONCOST > 10000 OR PRODUCTION COST < 100000;
