New ! Computer Science MCQ Practise Tests



12th Standard English Medium Computer Science Subject Data Manipulation Through SQL Creative 1 Mark Questions with Solution Part - II

12th Standard

    Reg.No. :
  •  
  •  
  •  
  •  
  •  
  •  

Computer Science

Time : 01:00:00 Hrs
Total Marks : 5

    1 Marks

    5 x 1 = 5
  1. Which method has a major role in working with python?

    (a)

    cursor ( )

    (b)

    connect ( )

    (c)

    execute ( )

    (d)

    close

  2. Which SQlite method is used to fetch the required number of rows in the database table?

    (a)

    fetch ( )

    (b)

    fetchamany ( )

    (c)

    fetchrows ( )

    (d)

    tablerows ( )

  3. Which of the following clause is often used with aggregate functions to group the result?

    (a)

    ORDERBY

    (b)

    WHERE

    (c)

    GROUP BY

    (d)

    DISTINCT

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

    (a)

    MODIFY

    (b)

    SELECT

    (c)

    UPDATE

    (d)

    CHANGE

  5. ______ 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

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

Reviews & Comments about 12th Standard English Medium Computer Science Subject Data Manipulation Through SQL Creative 1 Mark Questions with Solution Part - II

Write your Comment