New ! Computer Science MCQ Practise Tests



Data Manipulation Through SQL Book Back Questions

12th Standard

    Reg.No. :
  •  
  •  
  •  
  •  
  •  
  •  

Computer Science

Time : 00:45:00 Hrs
Total Marks : 30
    5 x 1 = 5
  1. Which of the following function retrieves the average of a selected column of rows in a table?

    (a)

    Add()

    (b)

    SUM()

    (c)

    AVG( )

    (d)

    AVERAGE()

  2. The function that returns the largest value of the selected column is

    (a)

    MAX()

    (b)

    LARGE()

    (c)

    HIGH()

    (d)

    MAXIMUM()

  3. Which of the following is called the master table?

    (a)

    sqlite_master

    (b)

    sql_master

    (c)

    main_master

    (d)

    master_main

  4. The most commonly used statement in SQL is

    (a)

    cursor

    (b)

    select

    (c)

    execute

    (d)

    commit

  5. Which of the following clause avoide the duplicate?

    (a)

    Distinct

    (b)

    Remove

    (c)

    Where

    (d)

    GroupBy

  6. 3 x 2 = 6
  7. Which method is used to connect a database? Give an example.

  8. Write the command to populate record in a table. Give an example.

  9. Which method is used to fetch all rows from the database table?

  10. 3 x 3 = 9
  11. What is SQLite?What is it advantage?

  12. Mention the difference between fetchone() and fetchmany()

  13. What is the use of Where Clause.Give a python statement Using the where clause.

  14. 2 x 5 = 10
  15. hat is the use of HAVING clause. Give an example python script

  16. 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 Computer Science Chapter 15 Data Manipulation Through SQL Book Back Questions

Write your Comment