New ! Computer Science MCQ Practise Tests



  1. Home
  2. 12th Standard
  3. Computer Science
  4. 12th Computer Science - Data Manipulation Through SQL Model Question Paper 1

Updated 12th Standard Computer Science Study Materials 2022-2023 Exams

12th Computer Science - Data Manipulation Through SQL Model Question Paper 1 8682895000 Jan-06 , 2020

Data Manipulation Through SQL

12th Computer Science - Data Manipulation Through SQL Model Question Paper 1

Data Manipulation Through SQL Model Question Paper 1

12th Standard

    Reg.No. :
  •  
  •  
  •  
  •  
  •  
  •  

Computer Science

Time : 01:00:00 Hrs
Total Marks : 50
    5 x 1 = 5

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

    (a)

    Execute()

    (b)

    Key()

    (c)

    Cursor()

    (d)

    run()

  2. 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()

  3. The most commonly used statement in SQL is

    (a)

    cursor

    (b)

    select

    (c)

    execute

    (d)

    commit

  4. Which method has a major role in working with python?

    (a)

    cursor ( )

    (b)

    connect ( )

    (c)

    execute ( )

    (d)

    close

  5. Which of the following statement in SQL is used to retrieve or fetch data from a table in a database?

    (a)

    select

    (b)

    inset

    (c)

    create

    (d)

    fetch

    6. 5 x 2 = 10

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

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

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

  9. How the cursor object is created?

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

    11. 5 x 3 = 15

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

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

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

  14. Write the sqlite steps to connect the database.

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

    16. 4 x 5 = 20

  16. Write in brief about SQLite and the steps used to use it.

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

  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 1

Write your Comment