New ! Computer Science MCQ Practise Tests



12th Standard English Medium Computer Science Subject Data Manipulation Through SQL Book Back 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 of the following function retrieves the average of a selected column of rows in a table?

    (a)

    Add()

    (b)

    SUM()

    (c)

    AVG( )

    (d)

    AVERAGE()

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

    (a)

    MAX()

    (b)

    LARGE()

    (c)

    HIGH()

    (d)

    MAXIMUM()

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

    (a)

    sqlite_master

    (b)

    sql_master

    (c)

    main_master

    (d)

    master_main

  4. The most commonly used statement in SQL is

    (a)

    cursor

    (b)

    select

    (c)

    execute

    (d)

    commit

  5. Which of the following clause avoide the duplicate?

    (a)

    Distinct

    (b)

    Remove

    (c)

    Where

    (d)

    GroupBy

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

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

Write your Comment