" /> -->

Data Manipulation Through SQL Model Question Paper

12th Standard EM

    Reg.No. :
  •  
  •  
  •  
  •  
  •  
  •  

Computer Science

Time : 01:00:00 Hrs
Total Marks : 40
    5 x 1 = 5
  1. SQLite falls under which database system?

    (a)

    Flat file database system

    (b)

    Relational Database system

    (c)

    Hierarchical database system

    (d)

    Object oriented Database system

  2. Which of the following is a control structure used to traverse and fetch the records of the database?

    (a)

    Pointer

    (b)

    Key

    (c)

    Cursor

    (d)

    Insertion point

  3. The SQlite command opens the already created database is

    (a)

    Cursor

    (b)

    Sql-comm

    (c)

    Connect

    (d)

    Connection

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

    (a)

    fetch ( )

    (b)

    fetchrowsAll ( )

    (c)

    fectchmany ( )

    (d)

    fetchall ( )

  5. Which SQlite keyword is used to extract only those records that fulfill a specified condition?

    (a)

    WHERE

    (b)

    EXTRACT

    (c)

    CONNECT

    (d)

    CURSOR

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

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

  9. What is master table?

  10. Write a note or cursor. description.

  11. How the cursor object is created?

  12. 5 x 3 = 15
  13. Mention the difference between fetchone() and fetchmany()

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

  15. Write the sqlite steps to connect the database.

  16. What is the use of .aggregate functions used along with SELECT statement? What are they?

  17. Write a note on SELECT statement in SQL.

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

  20. Write a Python script to create a table called ITEM with following specification.
    Add one record to the table.
    Name of the database :- ABC
    Name of the table :- Item
    Column name and specification :-

    Icode :- integer and act as primary key
    Item Name :- Character with length 25
    Rate :- Integer
    Record to be added :- 1008, Monitor,15000

     

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

TN 12th Standard EM Computer Science free Online practice tests

Reviews & Comments about 12th Computer Science - Data Manipulation Through SQL Model Question Paper

Write your Comment