New ! Computer Science MCQ Practise Tests



12th Standard English Medium Computer Science Subject Book Back 5 Mark Questions with Solution Part - II

12th Standard

    Reg.No. :
  •  
  •  
  •  
  •  
  •  
  •  

Computer Science

Time : 01:00:00 Hrs
Total Marks : 125

    5 Marks

    25 x 5 = 125
  1. Identify in the following program
    let rec gcd a b:=
               if b <> 0 then gcd b (a mod b)
               else return a:
    i) Name of the function
    ii) Identify the statement which tells it is a recursive function
    iii) Name of the argument variable
    iv) Statement which invoke the function recursively
    v) Statement which terminates the recursion

  2. Explain the representation of Abstract datatype using rational numbers.

  3. Write any five benefits in using modular programming.

  4. What is Binary search? Discuss with example

  5. Explain the concept of Dynamic programming with suitable example.

  6. Explain input() and print() functions with examples.

  7. Write a detail note on if..else..elif statement with suitable example.

  8. Write a program to display all 3 digit odd numbers.

  9. Explain the scope of variables with an example.

  10. Explain about string operators in python with suitable example.

  11. What is the purpose of range( )? Explain with an example.

  12. What is nested tuple? Explain with an example.

  13. Write a menu driven program to add or delete stationary items. You should use dictionary to store items and the brand.

  14. Explain the different types of relationship mapping.

  15. Differentiate DBMS and RDBMS.

  16. Write the different types of constraints and their functions.

  17. Consider the following employee table. Write SQL commands for the qtns.(i) to (v).

    EMP CODE NAME DESIG PAY ALLOWANCE
    S1001 Hariharan Supervisor 29000 12000
    P1002 Shaji Operator 10000 5500
    P1003 Prasad Operator 12000 6500
    C1004 Manjima Clerk 8000 4500
    M1005 Ratheesh Mechanic 20000 7000

    (i) To display the details of all employees in descending order of pay.
    (ii) To display all employees whose allowance is between 5000 and 7000.
    (iii) To remove the employees who are mechanic.
    (iv) To add a new row.
    (v) To display the details of all employees who are operators.

  18. What are the components of SQL? Write the commands in each.

  19. Write a SQL statement to create a table for employee having any five fields and create a table constraint for the employee table.

  20. Write the different methods to read a File in Python.

  21. Write a Python program to write a CSV File with custom quotes.

  22. What is the purpose of sys, os, getopt module in Python.Explain.

  23. Write the syntax for getopt( ) and explain its arguments and return values.

  24. Write the Python script to display all the records of the following table using fetchmany()

    Icode ItemName Rate
    1003 Scanner 10500
    1004 Speaker 3000
    1005 Printer 8000
    1008 Monitor 15000
    1010 Mouse 700
  25. Consider the following table Supplier and item .Write a python script for (i) to (ii)

    SUPPLIER
    Suppno Name City Icode SuppQty
    S001 Prasad Delhi 1008 100
    S002 Anu Bangalore 1010 200
    S003 Shahid Bangalore 1008 175
    S004 Akila Hydrabad 1005 195
    S005 Girish Hydrabad 1003 25
    S006 Shylaja Chennai 1008 180
    S007 Lavanya Mumbai 1005 325

    i) Display Name, City and Itemname of suppliers who do not reside in Delhi.
    ii) Increment the SuppQty of Akila by 40

*****************************************

Reviews & Comments about 12th Standard English Medium Computer Science Subject Book Back 5 Mark Questions with Solution Part - II updated Book back Questions

Write your Comment