New ! Computer Science MCQ Practise Tests



Data Manipulation Through SQL 1 Mark Book Back Question Paper With Answer Key

12th Standard

    Reg.No. :
  •  
  •  
  •  
  •  
  •  
  •  

Computer Science

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

    Multiple Choice Question

    10 x 1 = 10
  1. Which of the following is an organized collection of data?

    (a)

    Database

    (b)

    DBMS

    (c)

    Information

    (d)

    Records

  2. SQLite falls under which database system?

    (a)

    Flat file database system

    (b)

    Relational Database system

    (c)

    Hierarchical database system

    (d)

    Object oriented Database system

  3. Which of the following is a control structure used to traverse and fetch the records of the database?

    (a)

    Pointer

    (b)

    Key

    (c)

    Cursor

    (d)

    Insertion point

  4. Any changes made in the values of the record should be saved by the command

    (a)

    Save

    (b)

    Save As

    (c)

    Commit

    (d)

    Oblige

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

    (a)

    Execute()

    (b)

    Key()

    (c)

    Cursor()

    (d)

    run()

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

  7. The function that returns the largest value of the selected column is

    (a)

    MAX()

    (b)

    LARGE()

    (c)

    HIGH()

    (d)

    MAXIMUM()

  8. Which of the following is called the master table?

    (a)

    sqlite_master

    (b)

    sql_master

    (c)

    main_master

    (d)

    master_main

  9. The most commonly used statement in SQL is

    (a)

    cursor

    (b)

    select

    (c)

    execute

    (d)

    commit

  10. Which of the following clause avoide the duplicate?

    (a)

    Distinct

    (b)

    Remove

    (c)

    Where

    (d)

    GroupBy

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

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

Write your Comment