New ! Computer Science MCQ Practise Tests



12th Standard Computer Science Data Manipulation Through SQL English Medium Free Online Test One Mark Questions 2020 - 2021

12th Standard

    Reg.No. :
  •  
  •  
  •  
  •  
  •  
  •  

Computer Science

Time : 00:10:00 Hrs
Total Marks : 10

    Answer all the questions

    10 x 1 = 10
  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. Which of the following clause avoide the duplicate?

    (a)

    Distinct

    (b)

    Remove

    (c)

    Where

    (d)

    GroupBy

  4. The SQlite command opens the already created database is

    (a)

    Cursor

    (b)

    Sql-comm

    (c)

    Connect

    (d)

    Connection

  5. Which of the following is used define a SQL command in SQlite3?

    (a)

    " "

    (b)

    " " " "

    (c)

    ' '

    (d)

    " " " " "

  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. cursor.description will be stored as a

    (a)

    list

    (b)

    set

    (c)

    tuple

    (d)

    dictionary

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

    (a)

    connect

    (b)

    cursor

    (c)

    CSV

    (d)

    python

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

    (a)

    cursor. description

    (b)

    cursor.connect

    (c)

    cursor.column

    (d)

    cursor.fieldname

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

Reviews & Comments about 12th Standard Computer Science Data Manipulation Through SQL English Medium Free Online Test One Mark Questions 2020 - 2021

Write your Comment