New ! Computer Science MCQ Practise Tests

Data Manipulation Through SQL 3 Mark Creative Question Paper With Answer Key

12th Standard

    Reg.No. :
  •  
  •  
  •  
  •  
  •  
  •  

Computer Science

Time : 01:30:00 Hrs
Total Marks : 45

    3 Marks 

    15 x 3 = 45
  1. Explain how the SELECT statement can be used along with GROUP BY class.

  2. Write the sqlite steps to connect the database.

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

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

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

  6. Write a note on SELECT statement in SQL.

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

  8. How will you create database using SQ Lite?

  9. How will you display all records using fetch all ( )?

  10. How will you display a record using fetch one ( )?

  11. How will you display a record using fetchone ( )?

  12. How will display record using fetchmany( )?

  13. Write a program to display the content of tuples in new line without using loops.

  14. Explain briefly about cursor( ) method of connection?

  15. With an example,program explains briefly about SQL DISTINCT CLAUSE.

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

TN 12th Standard Computer Science free Online practice tests

Reviews & Comments about 12th Standard Computer Science English Medium - Data Manipulation Through SQL 3 Mark Creative Question Paper and Answer Key 2022 - 2023

Write your Comment