New ! Computer Science MCQ Practise Tests



Data Manipulation Through SQL Model Question Paper

12th Standard

    Reg.No. :
  •  
  •  
  •  
  •  
  •  
  •  

Computer Science

Time : 01:30:00 Hrs
Total Marks : 40
    5 x 1 = 5
  1. Which of the following is an organized collection of data?

    (a)

    Database

    (b)

    DBMS

    (c)

    Information

    (d)

    Records

  2. Which of the following executes the SQL command to perform some action?

    (a)

    Execute()

    (b)

    Key()

    (c)

    Cursor()

    (d)

    run()

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

    (a)

    MAX()

    (b)

    LARGE()

    (c)

    HIGH()

    (d)

    MAXIMUM()

  4. Which of the following clause avoide the duplicate?

    (a)

    Distinct

    (b)

    Remove

    (c)

    Where

    (d)

    GroupBy

  5. Which method is SQlite is used create a connection with a database file created?

    (a)

    cursor ( )

    (b)

    lite ( )

    (c)

    connect ( )

    (d)

    connection ( )

  6. 4 x 2 = 8
  7. Mention the users who uses the Database.

  8. What is the advantage of declaring a column as “INTEGER PRIMARY KEY”

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

  10. What is master table?

  11. 4 x 3 = 12
  12. What is SQLite?What is it advantage?

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

  14. Read the following details.Based on that write a python script to display records in desending order of
    Eno
    database name :- organization.db
    Table name :- Employee
    Columns in the table :- Eno, EmpName, Esal, Dept

  15. List the classes used in the SQL SELECT statement.

  16. 3 x 5 = 15
  17. Write in brief about SQLite and the steps used to use it.

  18. hat is the use of HAVING clause. Give an example python script

  19. 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 - Data Manipulation Through SQL Model Question Paper

Write your Comment