New ! Computer Science MCQ Practise Tests



12th Standard Computer Science English Medium Data Manipulation Through SQL Reduced Syllabus Important Questions 2021

12th Standard

    Reg.No. :
  •  
  •  
  •  
  •  
  •  
  •  

Computer Science

Time : 01:00:00 Hrs
Total Marks : 100

      Multiple Choice Questions


    15 x 1 = 15
  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 called the master table?

    (a)

    sqlite_master

    (b)

    sql_master

    (c)

    main_master

    (d)

    master_main

  3. A table column will be automatically auto incremented in SQlite3 by giving

    (a)

    KEY

    (b)

    PRIMARY KEY

    (c)

    PRIMARY COLUMN

    (d)

    KEY PRIMARY

  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 method is used to fetch the required number of rows in the database table?

    (a)

    fetch ( )

    (b)

    fetchamany ( )

    (c)

    fetchrows ( )

    (d)

    tablerows ( )

  6. Which of the following clause will not work in SQlite?

    (a)

    DISTINCT

    (b)

    HAVING

    (c)

    FETCHALL

    (d)

    WHERE

  7. Which SQlite clause is used to filter data base on the group functions?

    (a)

    WHERE

    (b)

    HAVING

    (c)

    ORDER

    (d)

    FILTER

  8. In which class the group functions can be used?

    (a)

    WHERE

    (b)

    HAVING

    (c)

    DISTINCT

    (d)

    GROUP BY

  9. The WHERE clause cannot be combined with

    (a)

    AND

    (b)

    OR

    (c)

    XOR

    (d)

    NOT

  10. The command to modify the values in the existing table

    (a)

    MODIFY

    (b)

    SELECT

    (c)

    UPDATE

    (d)

    CHANGE

  11. How many kinds of placeholders the SQlite3 module supports

    (a)

    1

    (b)

    2

    (c)

    3

    (d)

    5

  12. Which of the following placeholders does the SQlite3 module supports?

    (a)

    q mark style

    (b)

    named style

    (c)

    module style

    (d)

    a and b

  13. cursor.description will be stored as a

    (a)

    list

    (b)

    set

    (c)

    tuple

    (d)

    dictionary

  14. All the SQlite commands will be executed using _______ object

    (a)

    connect

    (b)

    cursor

    (c)

    CSV

    (d)

    python

  15. _______ SQlite command contain the details of each table column headings

    (a)

    cursor. description

    (b)

    cursor.connect

    (c)

    cursor.column

    (d)

    cursor.fieldname

    1. 2 Marks


    14 x 2 = 28
  16. Mention the users who uses the Database.

  17. Which method is used to connect a database? Give an example.

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

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

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

  21. What is a cursor in SQL and databases?

  22. What is the reason behind defining a SQL command with triple quotes?

  23. What is master table?

  24. How will you sort the data in a table in an ordered way?

  25. What is the use of AND, OR operators combined with WHERE clause?

  26. Write a note or cursor. description.

  27. Write the placeholders which supported by SQlite3 module Execute.

  28. How the cursor object is created?

  29. How the SQL DISTINCT class is helpful to you?

    1. 3 Marks


    11 x 3 = 33
  30. What is SQLite?What is it advantage?

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

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

  33. 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

  34. Explain how the SELECT statement can be used along with GROUP BY class.

  35. Write the sqlite steps to connect the database.

  36. Explain how a connect to be made to a database (Academy through python SQlite3.

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

  38. What is the purpose of using
    (i) COUNT ( )
    (ii) AVG ( )
    (iii) SUM ( )
    (iv) MAX ( )
    (v) MIN ( )

  39. Write a note on SELECT statement in SQL.

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

    1. 5 Marks


    5 x 5 = 25
  41. Write in brief about SQLite and the steps used to use it.

  42. 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
  43. hat is the use of HAVING clause. Give an example python script

  44. 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 :-

    I code :- Integer and act as primary key
    Item Name :- Character with length 25
    Rate :- Integer
    Record to be added :- 1008, Monitor, 15000
  45. 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 Computer Science English Medium Data Manipulation Through SQL Reduced Syllabus Important Questions 2021

Write your Comment