New ! Computer Science MCQ Practise Tests



12th Standard Computer Science English Medium Data Manipulation Through SQL Reduced Syllabus Important Questions With Answer Key 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. The most commonly used statement in SQL is

    (a)

    cursor

    (b)

    select

    (c)

    execute

    (d)

    commit

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

    (a)

    cursor ( )

    (b)

    lite ( )

    (c)

    connect ( )

    (d)

    connection ( )

  4. The SQlite command opens the already created database is

    (a)

    Cursor

    (b)

    Sql-comm

    (c)

    Connect

    (d)

    Connection

  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 SQlite keyword is used to fetch only the unique value from database table?

    (a)

    UNIQUE

    (b)

    DISTINCT

    (c)

    GROUPBY

    (d)

    HAVING

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

    (a)

    WHERE

    (b)

    HAVING

    (c)

    ORDER

    (d)

    FILTER

  8. The WHERE clause cannot be combined with

    (a)

    AND

    (b)

    OR

    (c)

    XOR

    (d)

    NOT

  9. _________ is a simple relational database system.

    (a)

    Cython

    (b)

    Boost

    (c)

    MySQL

    (d)

    SQlite

  10. ________ has a native library of SQlite.

    (a)

    Python

    (b)

    C++

    (c)

    Java

    (d)

    C

  11. __________ method run the SQL command to perform some action.

    (a)

    run

    (b)

    select

    (c)

    execution

    (d)

    execute

  12. ______ function returns the number of rows in a table satisfying the criteria specified in the where class?

    (a)

    Distinct

    (b)

    Count

    (c)

    Having

    (d)

    Counter

  13. Count ( ) returns ________ if there were no matching rows.

    (a)

    0

    (b)

    1

    (c)

    NOT NULL

    (d)

    NULL

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

    (a)

    cursor. description

    (b)

    cursor.connect

    (c)

    cursor.column

    (d)

    cursor.fieldname

  15. In Python, the path of a file can be represented as__________.

    (a)

    / or \\

    (b)

    \\ or /

    (c)

    \ or ?

    (d)

    // or ?

    1. 2 Marks


    12 x 2 = 24
  16. Mention the users who uses the Database.

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

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

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

  20. What is a cursor in SQL and databases?

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

  22. What is master table?

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

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

  25. Write a note or cursor. description.

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

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

    1. 3 Marks


    12 x 3 = 36
  28. What is SQLite?What is it advantage?

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

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

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

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

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

  34. Write the sqlite steps to connect the database.

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

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

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

  38. Write a note on SELECT statement in SQL.

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

    1. 5 Marks


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

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

  43. 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
  44. 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 With Answer Key 2021

Write your Comment